Hello,
I use proc import to import excel file into SAS. The data is 52 (49.5%) in excel file while the SAS data is . missing value. Could you please help me out? Thanks ! Here is my code. I changed mixed=yes and it didnot work too.
proc import datafile="&dir.\&inf." /* STEP 4 */
out=v&&name&i. replace;
sheet="&&sheet&i.$A5:W";
getnames=yes;
mixed=no ;
run;
Did you try DBMS=XLSX ?
It does not work, if I use
proc import datafile="&dir.\xxx.xlsx"
out=test replace dbms=xlsx;
sheet="Test Analysis$A5:W";
getnames=yes;
mixed=yes;
run;
the log window shows :ERROR: XLSX file does not exist -> C:\ddd\xxx.xlsx
Thank Ksharp!
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.