topic Re: Converting partial date (text) into a full date (numeric) in SAS Programming

Converting partial date (text) into a full date (numeric)

zimcom — Wed, 15 May 2019 18:10:26 GMT

I have a date of birth variable (brthdtc) saved as text with data captured as 1947/02 (yyyy/mm) and I want to convert it to numeric date as 1947-02-15 (use 15 as convention), does anyone know how to do this?

Re: Converting partial date (text) into a full date (numeric)

novinosrin — Wed, 15 May 2019 18:14:00 GMT

data have;
char_Date='1947/02';
run;


data want;
set have;
num_date=input(compress(char_Date,'/'),yymmn6.)+14;
format num_date yymmdd10.;
run;

Re: Converting partial date (text) into a full date (numeric)

zimcom — Wed, 15 May 2019 18:17:42 GMT

@novinosrin THANK YOU!!!