How to do this question?

[Melody1027]

In the data file Exe2_Data11.txt, the field indicates contains a street address and a person who lives at that address, age and gender. Create a SAS data set that contains one
observation for each person who lives at a specific address. The finished SAS data set
looks like this:

Exe2_Data11.txt

30 Daguilar St
Mary Chan,21,F
David Chan,25,M
Man Chan,2,M
15 Fuk Hi St
William Leung,30,M
20 San Fat St
Walter Ma,25,M
John Ma,50,M
78 Stanley St

[PeterClemmensen]

Is your desired output a SAS data set or a .txt file?

[Melody1027]

SAS data set

[Kurt_Bremser]

This is in essence the same question as posted here:

https://communities.sas.com/t5/New-SAS-User/How-to-do-this-question-if-we-don-t-know-the-number-of-m... 

[Kurt_Bremser]

data want;
infile "path_to_your_file" dlm="," dsd truncover;
length
  address $100
  name $50
  age 8
  gender $1
;
retain address;
input @;
if countw(_infile_,",") > 1
then do;
  input name age gender;
  output;
end;
else input address $100.;
run;