Proc Import. Not Importing Character values from excel file.

Nupur20 — Mon, 08 Apr 2013 17:24:22 GMT

Hi,

I am trying to import multiple excel files using the code below. There is a column in each excel file that has both numeric and text values but proc import is only importing numeric values, and put the text values as blank ('.').

Can anyone help with me this issue. I would greatly appreciate your time and suggestions.

%let subdir=S:\Temp\;

filename dir "&subdir.*.xls";

data new;

length filename fname $ 32767;

infile dir eof=last filename=fname;

input ;

last: filename=fname;

run;

proc sort data=new nodupkey;

by filename;

run;

data null;

set new end=last;

call symputx(cats('filename',_n_),filename);

call symputx(cats('dsn',_n_),scan(scan(filename,7,'\'),1,'.'));

if last then call symputx('nobs',_n_);

run;

%put &nobs;

%macro import;

%do i=1 %to &nobs;

proc import datafile="&&filename&i" out=&&dsn&i

dbms=excel replace;

sheet = "Sheet1";

getnames=yes;

mixed=yes;

run;

%end;

%mend import;

%import

Re: Proc Import. Not Importing Character values from excel file.

1zmm — Mon, 08 Apr 2013 20:57:53 GMT

Look at the SAS documentation for PROC IMPORT. Specifying a larger value in its new option, GUESSINGROWS, may solve this problem for you.

topic Proc Import. Not Importing Character values from excel file. in Statistical Procedures

Proc Import. Not Importing Character values from excel file.

Re: Proc Import. Not Importing Character values from excel file.