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' 😉
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.