topic date impute in SAS Programming

date impute

RajasekharReddy — Thu, 19 Jan 2017 14:50:37 GMT

I want impute the below date to DATE variable

30 – if day missing

June- if month missing

DATE

1963

1955-Apr

1987

1990-Aug

Re: date impute

RW9 — Thu, 19 Jan 2017 15:10:19 GMT

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;

Re: date impute

Kurt_Bremser — Thu, 19 Jan 2017 15:25:14 GMT

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