Posts Tagged ‘ sas/access ’

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

May 19, 2016
By

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 Read more »

Tags: , , ,
Posted in SAS | Comments Off on Tell SAS to read a database field as CHAR instead of INT or BIGINT

Using PROC SQL to get the schema of a MySQL database

May 18, 2012
By

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
Read more »

Tags: , ,
Posted in SAS | Comments Off on Using PROC SQL to get the schema of a MySQL database

SAS and IWA: Two Hops

January 23, 2012
By

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...
Read more »

Tags: , , , , , , , , , , , ,
Posted in SAS | Comments Off on SAS and IWA: Two Hops

SAS and IWA (Integrated Windows Authentication) Notes

December 31, 2011
By

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, ...
Read more »

Tags: , , , , , , , , , , , ,
Posted in SAS | Comments Off on SAS and IWA (Integrated Windows Authentication) Notes

Behind the scenes: importing Excel files using SAS Enterprise Guide

May 18, 2011
By

I hope that the following statement is not too controversial...but here it goes: Microsoft Excel is not a database system. That is, I know that people do use it as a database, but it's not an application that supports the rigor and discipline of...
Read more »

Tags: , , , , , , ,
Posted in SAS | Comments Off on Behind the scenes: importing Excel files using SAS Enterprise Guide

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors







Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.