creating a dataset

SAS_inquisitive — Sun, 19 Jun 2016 16:18:16 GMT

Hello,

I have a data set below. I want to increment the visit_num upto number_of_visits for each treatment.

Treatment visit_num number_of_visits

A 101 2

B 101 3

Desired dataset:

Treatment visitnum

A 101

A 102

B 101

B 102

B 103

Thank you !

Re: creating a dataset

Reeza — Sun, 19 Jun 2016 17:36:45 GMT

Use a do loop with an explicit output statement.

Heres as a sample for you:


Data want;
Set have;

Do I=1 to num_of_visits;

Visit_num= Visit_num+I-1;

OUTPUT;

End;

run;