topic Re: Import Excel file into SAS in SAS Programming

Import Excel file into SAS

eshtern — Fri, 12 Oct 2012 18:00:39 GMT

I am trying to create a SAS routine to read in an Excel file from 32-bit system into SAS 64-bit. I can use the Import Wizard but I want to control the input variables formats so I rather use the infile statement. I can't figure out what options to use in DBMS.

Thank you!

Re: Import Excel file into SAS

art297 — Fri, 12 Oct 2012 21:42:45 GMT

If it is a file that you can highlight and copy to your system's clipboard, then take a look at:

http://www.sascommunity.org/wiki/Copy_and_Paste_Almost_Anything

Re: Import Excel file into SAS

ballardw — Fri, 12 Oct 2012 22:47:56 GMT

Depending on how much control you need over the informat or format assignments your best bet may be to save the file as CSV, use the SAS import as CSV, copy the code out of the LOG window and modify the informat and format statements. Watch out for fields you want as character defaulting to numeric.