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!
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.