|
|
 | | From: | Jianping Zhu | | Subject: | read text file into sas dataset | | Date: | 23 Jan 05 01:53:51 GMT |
|
|
 | myfile.txt
row.names,school,minority,female,ses,mathach,size,sector,mea
ses
141,1317,0,1,0.062,18.827,455,1,0.351
142,1317,0,1,0.132,14.752,455,1,0.351
143,1317,0,1,0.502,23.355,455,1,0.351
144,1317,0,1,0.542,18.939,455,1,0.351
145,1317,0,1,0.582,15.784,455,1,0.351
146,1317,0,1,0.702,13.677,455,1,0.351
I want to read above file into sas dataset.
the first line contains varible names,
how can i do it?
|
|
| | From: | xiangyang.ye at gmail.com | | Subject: | Re: read text file into sas dataset | | Date: | 22 Jan 2005 18:50:40 -0800 |
|
|
| Hi Jianping,
Suppose myfile.txt is in 'c:\' folder.
proc import datafile="c:\myfile.txt"
out=myfile dbms=dlm replace;
delimiter=',';
getnames=yes;
run;
proc print data=mydata noobs;
run;
Sean
|
|
|
