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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.