need to read excel raw data

[nirmalraj]

Hi all,
Is there a way of importing or reading data from excel without converting the raw data into csv or text format.Does proc import have a solution for this.Can some one inform me of this.

Thanks in advance,
nirmal

 

[klaz2002]

Proc import can read from excel. Why not use the import data wizard located under FILE->Import Data in your SAS environment.
Klaz

 

[nirmalraj]

Klaz,

I forgot to mention that I use a unix OS through SSH.So I think wont be able to use the import wizard.I am also not using X Windows.I think proc import should be the only solution.

Thanks
Nirmal

 

[ChrisW75]

If you are using SAS version 9 you can read in the Excel files natively. We use Unix here and there isn't a direct import path unless you have the "SAS/ACCESS Interface to PC Files" installed in SAS. We always save files onto unix as CSV rather than Excel.

To test what modules you have access to in sas run this:-

proc setinit;
run;

This'll put into the log your setinit settings.
Enjoy.

 

[nirmalraj]

Chris
Thanks.We do not have "SAS/ACCESS Interface to PC Files".I think the best way is .csv format.

Thanks
Nirmal

 

[ChrisW75]

Yep, I think so too. We don't have that module on Unix, not even sure if it is available on Unix in version 8. Remember to be careful when saving data from Excel to csv, leading zeroes can be trimmed, dates can be given funny formats and things like that can mess up your import.
Enjoy.