hello,
I need to convert date-of-birth that is printed in text as YYYYNNN where NNN=days count from Jan1 inclusive.
Here are the examples:
Data have;
Input DOB $ ;
Datalines;
1975325
1993236
1980280
run;
here is the output that I would like to get:
DATA WANT;
FORMAT DOB $ 10.;
Input DOB $ ;
Datalines;
1975-11-21
1993-08-24
1980-06-10
RUN;
thank you
I don't know of an informat offhand which would handle that, but just code is pretty simple:
data have; input dob $; date_of_birth=input(cats(substr(dob,1,4),"01","01"),yymmdd10.) + input(substr(dob,5),best.); format date_of_birth date9.; datalines; 1975325 1993236 1980280 run;
So create a date of 01-01-year, and then add days on.
I don't know of an informat offhand which would handle that, but just code is pretty simple:
data have; input dob $; date_of_birth=input(cats(substr(dob,1,4),"01","01"),yymmdd10.) + input(substr(dob,5),best.); format date_of_birth date9.; datalines; 1975325 1993236 1980280 run;
So create a date of 01-01-year, and then add days on.
Thanks RW9.
Actually,after scanning the formats page there is a format to do this (always best to use the informats where possible):
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000201594.htm
data have; informat dob julian7.; input dob; format dob yymmdd10.; datalines; 1975325 1993236 1980280 run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.