Tag: sas/access

Introducing Analytics Pro Advanced Programming: The power of SAS on your desktop

SAS Analytics Pro Advanced Programming offers key statistical capabilities in a docker container. The product bundles selected executables from SAS Viya to create the container, which eases or streamlines the setup required for fixes and updates to the software.

Introducing Analytics Pro Advanced Programming: The power of SAS on your desktop was published on SAS Users.

Additional statistical capabilities in the containerized deployment of SAS Analytics Pro

SAS Analytics Pro consists of three core elements of the SAS system: Base SAS®, SAS/GRAPH® and SAS/STAT®. The containerized deployment option adds the full selection of SAS/ACCESS engines making it even easier to work with data from virtually any source.

Additional statistical capabilities in the containerized deployment of SAS Analytics Pro was published on SAS Users.

Tell SAS to read a database field as CHAR instead of INT or BIGINT

Yesterday a frustrated SAS user complained on Twitter. He’s working with a database that stores an ID field as a big long number (perhaps using the database BIGINT type), and SAS can’t display a number greater than 15 digits. Well, it’s actually 16 digits, depending on the value: %put Biggest […]

The post Tell SAS to read a database field as CHAR instead of INT or BIGINT appeared first on The SAS Dummy.

Using PROC SQL to get the schema of a MySQL database

It’s Friday, and on SAS Voices they are posting fun stuff about dogs who work at SAS. I’m posting about PROC SQL and MySQL. You tell me – which of us knows how to ring in the weekend with style? I’ve been working with MySQL data sources lately, and SAS/ACCESS […]

SAS and IWA: Two Hops

In an earlier post I mentioned that I would jot down a few notes about my experiences with SAS® software and Integrated Windows Authentication (IWA). This is the first of these posts and concerns the initial configuration. Chances are, if you knew…

SAS and IWA (Integrated Windows Authentication) Notes

Over the past year I have worked on a number of SAS® 9.2 platform installations helping to get Integrated Windows Authentication (IWA) working nicely for single sign-on (SSO) for the SAS platform. Whilst it’s relatively easy to turn IWA on, …