I want impute the below date to DATE variable
30 – if day missing
June- if month missing
DATE |
1963 |
1955-Apr |
1987 |
1990-Aug |
Recommend using 28 for day when month = 'Feb' 😉
Dunno what kind of date format your using there is you have YYYY-MON? Basically split it to three parts, make your updates, then put it back together:
data want; set have; yr=scan(thedate,1,"-"); mon=scan(thedate,2,"-"); day=scan(thedate,3,"-"); if mon="" then mon="Jun"; if day="" then day="30"; want_date=input(cats(day,mon,yr),date9.); run;
Recommend using 28 for day when month = 'Feb' 😉
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.