data birthinfo1;
length name $24. dob $12. sex $1.;
input name $24. dob $12. sex $1. ;
/*put _all_;*/
datalines;
james cathryn 15/10/1991 F
john Paul Mathew Pich 12/4/1964 M
Abharam Lincoln 25/12/1966 M
Lan 22/02/1956 F
run;
Can you please help me populatiing the data into above dataset.
Regards,
SJN
data birthinfo1;
input ;
name=substr(_infile_,1,anydigit(_infile_)-1);
dob=scan(_infile_,-2,' ');
sex=scan(_infile_,-1,' ');
datalines;
james cathryn 15/10/1991 F
john Paul Mathew Pich 12/4/1964 M
Abharam Lincoln 25/12/1966 M
Lan 22/02/1956 F
;
run;
Omit the dots at length statement.
The dots are needed in format statement.
data birthinfo1; length name $24 dob $12 sex $1; input name $24. dob $12. sex $1. ; /*put _all_;*/ datalines; james cathryn 15/10/1991 F john Paul Mathew Pich 12/4/1964 M Abharam Lincoln 25/12/1966 M Lan 22/02/1956 F run;
data birthinfo1;
input ;
name=substr(_infile_,1,anydigit(_infile_)-1);
dob=scan(_infile_,-2,' ');
sex=scan(_infile_,-1,' ');
datalines;
james cathryn 15/10/1991 F
john Paul Mathew Pich 12/4/1964 M
Abharam Lincoln 25/12/1966 M
Lan 22/02/1956 F
;
run;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.