topic Re: Dates in SAS Health and Life Sciences

Dates

R_Win — Wed, 06 Aug 2008 05:22:52 GMT

HI i have a data set i want the doff between two dates. here is the data set;

data x;
input date ddmmyy10.;
cards;
12/10/1980
09/08/1983
29/08/1985
19/09/1989
19/08/1989
;
i want the difff between two dates

Re: Dates

Cynthia_sas — Wed, 06 Aug 2008 12:39:30 GMT

Hi:
The difference between dates on each observation??? You might investigate the LAG function.

cynthia

Re: Dates

Doc_Duke — Wed, 06 Aug 2008 20:38:46 GMT

If you want all possible difference between the dates, you can use PROC SQL and do an outer join of x to x (This is often called a Cartesian Product).

*untested code;
PROC SQL;
CREATE TABLE AllDiff AS
SELECT a.date as date1,
b.date as date2,
Diff as date1-date1
FROM x AS a
OUTER JOIN x AS b;
QUIT;
RUN;

Re: Dates

sbb — Thu, 14 Aug 2008 15:00:09 GMT

You may want to explore the SAS DATA STEP functions INTCK and also INTNX; the latter function can be helpful with generating DATE and DATETIME variable values, based on other variables. For example, you can use a DATA STEP DO/END loop to generate (OUTPUT) SAS observations for each date value in a date-range, say for the past 12 months or 26 weeks.

Scott Barry
SBBWorks, Inc.

Re: Dates

deleted_user — Sat, 30 Aug 2008 02:47:17 GMT

after create the data x;
data y;
retain diff 0 old 0 date 0;
old=date;
set x;
diff=date-old;
run;