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).
Just curious to know why iii fixed the problem
thanks
thanks didn't see the reply, please ignore the last question
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;
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.