import data and naming the variable

[art297]

One of your variables was called "i" and I, without thinking, had suggested using "i" in the do loop.  As such, the loop was re-assigning the value of that variable (i.e., the eighth variable).

[R_A_G_]

Just curious to know why iii fixed the problem

thanks

[R_A_G_]

thanks didn't see the reply, please ignore the last question

[Tom]

Why not just skip the PROC IMPORT?  Save the XLS files as a CSV file and then just read it with a data step where you get to define the names?

data want ;

  infile 'myfile.csv' dsd dlm=',' truncover lrecl=30000;

  input people col1-col116;

run;

[Ksharp]

Or a faster way.

Proc import out=data datafile="C:\temp\x.xls"  dbms=xls replace;
  getnames=no;
run;

data _null_;
 set sashelp.vcolumn(keep=libname memname name where=(libname='WORK' and memname='DATA')) end=last ;
 if _n_ eq 1 then call execute('proc datasets library=work nolist;modify data; rename a=people ');
  else call execute(cats(name,'=col',_n_-1));
 if last then call execute(';quit;');
run;

Ksharp