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

[zimcom]

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?

[novinosrin · Accepted solution]

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


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

[zimcom]

@novinosrin THANK YOU!!!