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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.