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

[daisy6]

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;

[Ksharp]

Did you try  DBMS=XLSX   ?

[daisy6]

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!