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!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.