BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
2 REPLIES 2
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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
deleted_user
Not applicable
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;

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
  • 2 replies
  • 599 views
  • 0 likes
  • 2 in conversation