topic Re: reading txt file or datalines in SAS Programming

reading txt file or datalines

Aman4SAS — Mon, 02 Sep 2013 16:49:08 GMT

data test;

infile datalines missover;

input x y$ z;

datalines;

34 aman 56

56 vikash 34

34 aman 56

56 vikash 34

34 aman

56 34

aman 56

56 vikash 34

34 aman 56

56 vikash

34 56

56 vikas

;

run;

proc print; run;

please let me know how i can read records in correct format...

Re: reading txt file or datalines

art297 — Mon, 02 Sep 2013 17:16:33 GMT

At least for your example, the following would work:

data test;

infile datalines truncover;

input @;

_infile_=tranwrd(_infile_,' ',' ');

_infile_=tranwrd(_infile_,' ',' . ');

input x 1-2 y $ z;

datalines;

34 aman 56

56 vikash 34

34 aman 56

56 vikash 34

34 aman

56 34

aman 56

56 vikash 34

34 aman 56

56 vikash

34 56

56 vikas

;

Re: reading txt file or datalines

Aman4SAS — Tue, 03 Sep 2013 05:45:59 GMT

Thank you very much for your kind help.

sir i would like to add one thing that your ans is suitable for only this sample data in exact this format. but if i will change place of any field value(means adding one or more space in between) so it will give wrong ans. which is possible to come in complete population.

i tried something but it is not working in name field.

data test;

infile datalines truncover dlm=",";

input @;

_infile_=tranwrd(_infile_,' ',",");

input x 1-2 y $ z;

datalines;

34 aman 56

56 vikash 34

34 aman 56

56 vikash 34

34 aman

56 34

aman 56

56 vikash 34

34 aman 56

56 vikash

34 56

56 vikas

;

run;

Kindly suggest me ....

Re: reading txt file or datalines

art297 — Tue, 03 Sep 2013 13:54:09 GMT

Then try:

data test;

infile datalines truncover;

input x 1-2;

_infile_=substr(_infile_,3);

y=scan(_infile_,1);

if not anyalpha(y) then do;

call missing(y);

z=input(scan(_infile_,1),8.);

end;

else z=input(scan(_infile_,2),8.);

datalines;

34 aman 56

56 vikash 34

34 aman 56

56 vikash 34

34 aman

56 34

aman 56

56 vikash 34

34 aman 56

56 vikash

34 56

56 vikas

;