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

Hello SAS world!!

 

I want to calculate difference between two dates, which are in the following formate: "12JUL2012 and 20120711".

I got a date difference as "-20101525", which is utterly wrong. Can someone help me with this problem?

 

Thanks

--Sujith

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

I suspect that DEATH_DT is actually just a number and not a date at all.  If that's true, you could try:

 

Days_to_Death = mindate - input(put(death_dt, 8.), yymmdd8.);

View solution in original post

5 REPLIES 5
Reeza
Super User

You say formats. Can you confirm that date formats are applied to both variables? Make sure it's not numeric with a numeric or datetime format. 

PGStats
Opal | Level 21

What SAS code got you that result?

PG
Sujithpeta
Quartz | Level 8

    mindate       DEATH_DT     Days_to_Death

12JUL2012        20120711         -20101525

 

data M.Death;
set M.Death;
Days_to_Death = (mindate-DEATH_DT);
run;

PGStats
Opal | Level 21

It looks like DEATH_DT is a SAS datetime and not a SAS date. Try

 

Days_to_Death = (mindate-datepart(DEATH_DT));

PG
Astounding
PROC Star

I suspect that DEATH_DT is actually just a number and not a date at all.  If that's true, you could try:

 

Days_to_Death = mindate - input(put(death_dt, 8.), yymmdd8.);

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!

How to Concatenate Values

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.

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
  • 5 replies
  • 813 views
  • 2 likes
  • 4 in conversation