DATA Step, Macro, Functions and more

import excel file data into sas the data with parenthesis converted into missing values

Reply
Contributor
Posts: 62

import excel file data into sas the data with parenthesis converted into missing values

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;

 

Super User
Posts: 10,035

Re: import excel file data into sas the data with parenthesis converted into missing values

Did you try  DBMS=XLSX   ?

Contributor
Posts: 62

Re: import excel file data into sas the data with parenthesis converted into missing values

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!

Ask a Question
Discussion stats
  • 2 replies
  • 126 views
  • 0 likes
  • 2 in conversation