Import Excel file into SAS

Reply
SAS Employee
Posts: 4

Import Excel file into SAS

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!

PROC Star
Posts: 7,363

Re: Import Excel file into SAS

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

Super User
Posts: 10,500

Re: Import Excel file into SAS

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.

Ask a Question
Discussion stats
  • 2 replies
  • 338 views
  • 0 likes
  • 3 in conversation