Programming the statistical procedures from SAS

Proc Import. Not Importing Character values from excel file.

Reply
Contributor
Posts: 33

Proc Import. Not Importing Character values from excel file.

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

Regular Contributor
Posts: 152

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

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

Ask a Question
Discussion stats
  • 1 reply
  • 219 views
  • 0 likes
  • 2 in conversation