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!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.