topic How to increase date in Statistical Procedures

How to increase date

deleted_user — Fri, 25 Dec 2009 05:51:52 GMT

I have a dataset which contains 3 variables that are patient id date and doses ,I have to increase the date

patient id date doses
101 1jan2009 10mg

I have to create a dataset like
patient id date dose
101 1jan2009 10mg
101 2jan2009 10mg
101 3jan2009 10mg
101 4jan2009 10mg
101 5jan2009 10mg

please tell me how I increase the date.

Thanks,
Regards,
Bina

Re: How to increase date

Patrick — Fri, 25 Dec 2009 08:21:27 GMT

data have;
infile datalines;
input patient_id date anydtdte. doses $;
format date date9.;
datalines;
101 1jan2009 10mg
;

data want(drop=i);
set have;
do i=1 to 5;
output;
date=date+1;
end;
run;

proc print data=want;
run;

Re: How to increase date

sbb — Fri, 25 Dec 2009 19:53:45 GMT

Most important for the OP to understand the SAS DATE variable (numeric) content - suggested link provided below from SAS DOC.

Also, it is possible to work with a DO / END code paragraph incrementing a variable from a starting date (constant) to an ending date, as shown below:

DO I=INTNX('MONTH,TODAY(),0) TO INTNX('MONTH',TODAY(),+1);
* YOUR CODE GOES HERE. ;
END;

Both the INTNX and INTCK functions are quite powerful in a DATA step process to increment and also generate ranges of date-variable values.

Scott Barry
SBBWorks, Inc.

SAS Language Reference: Concepts, About SAS Date, Time, and Datetime Values
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a002200738.htm

Re: How to increase date

deleted_user — Sun, 27 Dec 2009 13:31:14 GMT

Dear Patrick,
Thanks a lot for your kind information this code work perfectly.

Thanks,
Regards,
Leena

Re: How to increase date

deleted_user — Sun, 27 Dec 2009 13:33:26 GMT

Dear sbb,
Thanks a lot for your kind information.
Thanks,
Regards,
Leena