Import Excel file into SAS

[eshtern]

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!

[art297]

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

[ballardw]

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.