How to Read input File

[LittlesasMaster]

Hi All,

I am new to SAS and these days learning Base SAS Programming, I am not able to read this input file.

File name- Test.txt

data in file are Name, Age and Gender

like this.....

Dharmendra Kumar Yadav 22 M

Sonu 34 M

Deepa 45 F

David Fills 44 M

John Don 33 M

Can any one tell me how to read this data with these vars- Name, Age and Gender.

Thanks!! in advance

[data_null__ · Accepted solution]

You know that age is the second word from the right and you can use that to find the length of name.

data names;
   input @;
   call scan(_infile_,-2,p,l,' ');
   l = p-1;
   input name $varying64. l age sex :$1.;
   drop p l;
   cards;
Dharmendra Kumar Yadav 22 M
Sonu 34 M
Deepa 45 F
David Fills 44 M
John Don 33 M
;;;;
   run;
proc print;
   run;

[LittlesasMaster]

Thanks!! a ton.

It helped.