## Problem with missing date value

Solved
Frequent Contributor
Posts: 131

# Problem with missing date value

I have the following code I am using to fill the date if missing with end of Previous month date.  But some how it give me date = 01/01/1960

data have;

input ID  date1  : mmddyy10.     date2 : mmddyy10.  ;

format    date1 date2  mmddyy10.  ;

cards;

1    12/31/2014  1/5/2015

1    1/5/2015    2/15/2015

1    2/16/2015    .

run;

data _NULL_;

call symputx('enddt', put(intnx('month',date(),-1,'e'), mmddyy10.)) ;

run;

data have2;

set have;

if date2 = . then date2 = &enddt.;

run;

Accepted Solutions
Solution
‎03-28-2015 01:12 PM
Posts: 5,543

## Re: Problem with missing date value

You are replacing missing values in date2 with the result of expression 02/28/2015 = 0.0000354

you must give date constants the proper format :

data _NULL_;

call symputx('enddt', put(intnx('month',date(),-1,'e'), date9.)) ;

run;

%put &enddt;

data have2;

set have;

if date2 = . then date2 = "&enddt."d;

run;

PG

PG

All Replies
Solution
‎03-28-2015 01:12 PM
Posts: 5,543

## Re: Problem with missing date value

You are replacing missing values in date2 with the result of expression 02/28/2015 = 0.0000354

you must give date constants the proper format :

data _NULL_;

call symputx('enddt', put(intnx('month',date(),-1,'e'), date9.)) ;

run;

%put &enddt;

data have2;

set have;

if date2 = . then date2 = "&enddt."d;

run;

PG

PG
🔒 This topic is solved and locked.