topic Re: How to Read input File in SAS Procedures

How to Read input File

LittlesasMaster — Sun, 07 Dec 2014 13:36:26 GMT

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

Re: How to Read input File

data_null__ — Sun, 07 Dec 2014 13:51:28 GMT

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;

Re: How to Read input File

LittlesasMaster — Sun, 07 Dec 2014 18:09:36 GMT

Thanks!! a ton.

It helped.