date impute

[RajasekharReddy]

I want impute the below date to DATE variable

30 – if day missing

June- if month missing

DATE

1963

1955-Apr

1987

1990-Aug

[RW9]

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;

[Kurt_Bremser · Accepted solution]

Recommend using 28 for day when month = 'Feb' 😉