topic Re: import excel file data into sas the data with parenthesis converted into missing values in SAS Programming

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

daisy6 — Thu, 13 Jul 2017 16:52:31 GMT

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;

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

Ksharp — Fri, 14 Jul 2017 10:01:09 GMT

Did you try DBMS=XLSX ?

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

daisy6 — Fri, 14 Jul 2017 18:18:14 GMT

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!