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!
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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.