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
data temp;
informat date_val date9.;
input date_val;
if date_val = . then date_val ='31Dec2016'd;
datalines;
22Jul2016
.
21Aug2016
;
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;
data temp;
informat date_val date9.;
input date_val;
if date_val = . then date_val ='31Dec2016'd;
datalines;
22Jul2016
.
21Aug2016
;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.