Accessing a SAS dataset?

[Russell Reimann]

Hello,

Does anyone know how access a dataset that was created by SAS software? If
not, could you point me in the right direction?
Thanks,

-- Russ

 

[Nigel]

If you mean access from within Excel, then your best option is to use SAS to
create an Excel file of the data set and then open this from within Excel.
The file format(s), of which there are several, created by SAS are best
opended in SAS and converted within that toolset.

Cheers
Nigel

 

[Thomas Kregeloh]

Hi Russel,
what do you exactly mean by "accessing a SAS dataset"?. As you probably
know, SAS can write text files as well as CSV-files which can easily read by
any means.
So I suppose you try to read or write to a file in the specific SAS-Format.
I know there is a way to read Excel-files from SAS. Does that work for you?
If not, then try to gogle for "SAS + EXCEL" where you find texts like this
(not from me, found it):

"You can install an ODBC-driver for SAS. Basically it is an interface other
programs (such as Excel) can use to access the data in a SAS-dataset.
Once that is installed, you can create an Excel form ( or a macro or
anything in VBA) that activates the link associated with the ODBC. Then you
can do a regular sql on the dataset to extract what you want.
Another possibility is to have the VBA code actually start SAS to produce
some file readable by Excel. You could have your VBA code write an
initialization file that SAS could read, for instance giving certain
criteria for the extraction of the data."
Or try http://www.sas.com/rnd/itech/

HTH a bit
Thomas