DATA Step, Macro, Functions and more

do while

Reply
N/A
Posts: 0

do while

I have a data like
patientid date dose
101 1/03/09 10mg

I want a output like this
patientid date dose
101 1/03/09 10mg
101 2/03/09 10mg
101 3/03/09 10mg
101 4/03/09 10mg
101 5/03/09 10mg
101 6/03/09 10mg

please tell me how to code this program
Super Contributor
Super Contributor
Posts: 3,174

Re: do while

Posted in reply to deleted_user
One option is a DATA step to read up your variables, then using a DO DT=start_date TO end_date; / END; loop you can increment your date value using the INTNX function with the "SAMEDAY" parameter argument and OUTPUT additional observations for some number of INTNX interval periods (another function argument).

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument:

data step programming basics site:sas.com

...also...

using dates intnx site:sas.com
N/A
Posts: 0

Re: do while

Posted in reply to deleted_user
I am not so sure about what actually your question really is. But you may try below code. I hope this one could help.

data DosePerDay(drop=start dd);
format patientid $3.;
format date ddmmyy8.;
format dose $4.;
start=mdy(3,1,2009);
do dd=start to start + 30;
patientid="101";
date=dd;
dose="10mg";
output;
end;
run;

proc print data=DosePerDay noobs;
run;
Ask a Question
Discussion stats
  • 2 replies
  • 110 views
  • 0 likes
  • 2 in conversation