|
1E3 is the result of trying to display a four digit number in three columns.
Your problem is not with the data step but with whatever tool you are using to produce the printed output (probably PROC PRINT). Show us that code.
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Trish Bous
Sent: Thursday, September 23, 2010 4:48 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: WORKING WITH DATES
Hi All,
I am having some trouble looking at the difference in dates and I was hoping
that someone could help. I want to calculate the number of days between 2
dates, and my code works except when the dates are greater than 3 years
apart. Any help would be appreciated!
Code:
data admin;
set admin;
by id;
FORMAT start_DATE DATE8.;
FORMAT DAYS 8.;
if first.id then do;
days=0;
start_date = DATE;
end;
else do;
days = datdif(start_DATE,DATE, 'act/act' );
end;
RUN;
The output from my code is as follows:
Obs ID DATE days start_date DATE
491 334 03/15/2005 617 07JUL03 03/15/2005
492 334 03/21/2005 623 07JUL03 03/21/2005
493 334 04/19/2005 652 07JUL03 04/19/2005
494 332 05/10/2002 0 10MAY02 05/10/2002
495 332 08/20/2002 102 10MAY02 08/20/2002
496 332 03/08/2002 -63 10MAY02 03/08/2002
497 332 12/13/2005 1E3 10MAY02 12/13/2005
498 332 12/12/2005 1E3 10MAY02 12/12/2005
499 348 09/28/2001 0 28SEP01 09/28/2001
500 354 05/17/2004 0 17MAY04 05/17/2004
As you can see, my problem is with observations 497 and 498, where the
number of days are "1E3"
| 
