topic Re: Data Set Help in SAS Programming

Data Set Help

SJN — Sat, 01 Jul 2017 05:23:05 GMT

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

Re: Data Set Help

Shmuel — Sat, 01 Jul 2017 05:47:46 GMT

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;

Re: Data Set Help

Ksharp — Sat, 01 Jul 2017 05:49:54 GMT

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;