topic Re: proc import in SAS Procedures

proc import

anais — Thu, 06 Sep 2012 07:38:10 GMT

Hello,

I would like to import an excel file in sas (the estension of my file is .xlsx), but i don't know how to do it?

I would like to code it instead to use "file--> import data-->...".

I tried to use the procedure import but i don't get it.

Thanks.

Anaïs

Re: proc import

shivas — Thu, 06 Sep 2012 10:51:16 GMT

Hi,

Try this..

PROC IMPORT OUT= WORK.input

DATAFILE= "F:\test.xlsx"

DBMS=EXCEL REPLACE;

RANGE="Sheet$";

GETNAMES=YES;

MIXED=NO;

SCANTEXT=YES;

USEDATE=YES;

SCANTIME=YES;

RUN;

Thanks,

Shiva

Re: proc import

anais — Thu, 06 Sep 2012 11:53:58 GMT

Thanks a lot Shiva.

I tried your codes, and I successfully get the excel file in the sas program!

Thanks,

Anaïs

Re: proc import

SusanJ516_sas — Thu, 06 Sep 2012 14:07:07 GMT

Hi Anais,

Sounds like you tried to use the documentation for PROC IMPORT but you "didn't get it." I assume you were using the SAS/ACCESS Interface to PC Files, right?

If you have feedback about the documentation that would help us improve it, please let me know. Also, for the .xlsx format, there are a number of SAS Notes; just search on xlsx and import to see them. Thanks,

Susan

Re: proc import

OS2Rules — Thu, 06 Sep 2012 14:49:12 GMT

Hi:

You know that if you use "file ---> import data ---> etc", you can save the code that was generated to load the file into SAS?

Then you just INCLUDE that code into you SAS session and save it - save you having to write the code in the first place.

Re: proc import

anais — Thu, 06 Sep 2012 15:04:08 GMT

thanks for the information. I ignored that i could save the code when i used "file--> import data..".

Can-you explain me how to save the code generated to load the file into sas?

Thanks a lot,

Anaïs

Re: proc import

Li — Wed, 12 Sep 2012 20:28:48 GMT

Does this code works under SAS 9.3 Win7 64x machine? - Thanks. Li

Re: proc import

anais — Thu, 13 Sep 2012 07:45:52 GMT

I don't know if it work under sas 9.3 Win7 64x machine.

I used the codes mentioned above on sas 9.3 32bit;

Anaïs

Re: proc import

Li — Thu, 13 Sep 2012 14:36:44 GMT

No, this will not work. I just tried. The log is:

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

Re: proc import

art297 — Thu, 13 Sep 2012 15:35:27 GMT

Li: take a look at: http://support.sas.com/kb/37/412.html