BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
pp2014
Fluorite | Level 6

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;

1 ACCEPTED SOLUTION

Accepted Solutions
PGStats
Opal | Level 21

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

View solution in original post

1 REPLY 1
PGStats
Opal | Level 21

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 705 views
  • 1 like
  • 2 in conversation