SAS EG

[ashishj816]

I have date column in which if blank comes i want to fill it with year end date how can i do it ?

Example:-

Date

22JUN2016

-

-

01JAN2016

22JAN2016

12FEB2016

-

then i want

Date

22JUN2016

31DEC2016

31DEC2016

01JAN2016

22JAN2016

12FEB2016

31DEC2016

[Kurt_Bremser]

I assume you want to take it from previous observations.

data want;
set have;
retain keepyear;
if date ne .
then keepyear = year(date);
else date = mdy(12,31,keepyear);
drop keepyear;
run;

[RahulG · Accepted solution]

data temp;
informat date_val date9.;
input date_val;
if date_val = . then date_val ='31Dec2016'd;
datalines;
22Jul2016
.
21Aug2016
;