Importing Data from Excel Using Unix/SAS

[nirmalraj]

Hi All,

Is there a method of importing data values from an excel worksheet(s) using unix SAS.I know we can do it using PC sas but wanted to find out for Unix Sas.I heard there is a trick for doing this.Dont know how, so just shooting across.
btw I am using SAS version 9.1

Thanks,
Raj

 

[klaz2002]

Raj,
If you save the files as CSV you could have UNIX sas read those with the Dataset import statement.

Klaz

 

[ChrisW75]

SAS Version 9 now allows you to read in from Excel files, I believe in the same way that you would with SAS/PC.

LIBNAME <libref> PATH='<location of file>'
                       <connection-options>
                       <libname-options>;

You should be able to find the details in the "What's new in SAS 9.1" section in the doco online.

http://support.sas.com/onlinedoc/913/getDoc/en/acpcref.hlp/a002656479.htm

Enjoy.

 

[nirmalraj]

Chris,

Thanks, let me try the option.I was never aware of this.I'll post the outcome.

Raj