BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
gp123
Calcite | Level 5

I need to create a block variable to keep a tab on changing doses.

 

subject dose
10002 10MG
10002 10MG
10002 20MG
10002 10MG
10002 10MG

10004 10MG
10004 10MG
10004 10MG
10004 20MG
10004 20MG

 

I want the final dataset to look like as follows.

 

subject dose block
10002 10MG   1
10002 10MG   1
10002 20MG   2
10002 10MG   3
10002 10MG   3

10004 10MG   1
10004 10MG   1
10004 10MG   1
10004 20MG   2
10004 20MG   2

 

any thoughts?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

BY groups + FIRST, this assumes your data is sorted as shown. 

 

data want;
set have;
by subject dose notsorted;

if first.subject then block=0;
if first.dose then block+1;

run;

 


@gp123 wrote:

I need to create a block variable to keep a tab on changing doses.

 

subject dose
10002 10MG
10002 10MG
10002 20MG
10002 10MG
10002 10MG

10004 10MG
10004 10MG
10004 10MG
10004 20MG
10004 20MG

 

I want the final dataset to look like as follows.

 

subject dose block
10002 10MG   1
10002 10MG   1
10002 20MG   2
10002 10MG   3
10002 10MG   3

10004 10MG   1
10004 10MG   1
10004 10MG   1
10004 20MG   2
10004 20MG   2

 

any thoughts?

 

 



 

View solution in original post

1 REPLY 1
Reeza
Super User

BY groups + FIRST, this assumes your data is sorted as shown. 

 

data want;
set have;
by subject dose notsorted;

if first.subject then block=0;
if first.dose then block+1;

run;

 


@gp123 wrote:

I need to create a block variable to keep a tab on changing doses.

 

subject dose
10002 10MG
10002 10MG
10002 20MG
10002 10MG
10002 10MG

10004 10MG
10004 10MG
10004 10MG
10004 20MG
10004 20MG

 

I want the final dataset to look like as follows.

 

subject dose block
10002 10MG   1
10002 10MG   1
10002 20MG   2
10002 10MG   3
10002 10MG   3

10004 10MG   1
10004 10MG   1
10004 10MG   1
10004 20MG   2
10004 20MG   2

 

any thoughts?

 

 



 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 1 reply
  • 360 views
  • 0 likes
  • 2 in conversation