topic Re: SAS EG in SAS Programming

SAS EG

ashishj816 — Wed, 03 Aug 2016 07:04:38 GMT

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

01JAN2016

22JAN2016

12FEB2016

31DEC2016

Kurt_Bremser — Wed, 03 Aug 2016 07:33:55 GMT

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 — Wed, 03 Aug 2016 07:38:12 GMT

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