https://communities.sas.com/t5/SAS-Programming/creating-blocks/m-p/358088#M274356 <P>I need to create a block variable to keep a tab on changing doses.</P><P>&nbsp;</P><P>subject dose<BR />10002 10MG<BR />10002 10MG<BR />10002 20MG<BR />10002 10MG<BR />10002 10MG<BR /><BR />10004 10MG<BR />10004 10MG<BR />10004 10MG<BR />10004 20MG<BR />10004 20MG</P><P>&nbsp;</P><P>I want the final dataset to look like as follows.</P><P>&nbsp;</P><P>subject dose block<BR />10002 10MG &nbsp; 1<BR />10002 10MG &nbsp; 1<BR />10002 20MG &nbsp; 2<BR />10002 10MG &nbsp; 3<BR />10002 10MG &nbsp; 3<BR /><BR />10004 10MG &nbsp; 1<BR />10004 10MG &nbsp; 1<BR />10004 10MG &nbsp; 1<BR />10004 20MG &nbsp; 2<BR />10004 20MG &nbsp; 2</P><P>&nbsp;</P><P>any thoughts?</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 12 May 2017 02:05:56 GMT gp123 2017-05-12T02:05:56Z https://communities.sas.com/t5/SAS-Programming/creating-blocks/m-p/358088#M274356 <P>I need to create a block variable to keep a tab on changing doses.</P><P>&nbsp;</P><P>subject dose<BR />10002 10MG<BR />10002 10MG<BR />10002 20MG<BR />10002 10MG<BR />10002 10MG<BR /><BR />10004 10MG<BR />10004 10MG<BR />10004 10MG<BR />10004 20MG<BR />10004 20MG</P><P>&nbsp;</P><P>I want the final dataset to look like as follows.</P><P>&nbsp;</P><P>subject dose block<BR />10002 10MG &nbsp; 1<BR />10002 10MG &nbsp; 1<BR />10002 20MG &nbsp; 2<BR />10002 10MG &nbsp; 3<BR />10002 10MG &nbsp; 3<BR /><BR />10004 10MG &nbsp; 1<BR />10004 10MG &nbsp; 1<BR />10004 10MG &nbsp; 1<BR />10004 20MG &nbsp; 2<BR />10004 20MG &nbsp; 2</P><P>&nbsp;</P><P>any thoughts?</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 12 May 2017 02:05:56 GMT https://communities.sas.com/t5/SAS-Programming/creating-blocks/m-p/358088#M274356 gp123 2017-05-12T02:05:56Z https://communities.sas.com/t5/SAS-Programming/creating-blocks/m-p/358092#M274357 <P>BY groups + FIRST, this assumes your data is sorted as shown.&nbsp;</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data want; set have; by subject dose notsorted; if first.subject then block=0; if first.dose then block+1; run;</CODE></PRE> <P>&nbsp;</P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/143521">@gp123</a> wrote:<BR /> <P>I need to create a block variable to keep a tab on changing doses.</P> <P>&nbsp;</P> <P>subject dose<BR />10002 10MG<BR />10002 10MG<BR />10002 20MG<BR />10002 10MG<BR />10002 10MG<BR /><BR />10004 10MG<BR />10004 10MG<BR />10004 10MG<BR />10004 20MG<BR />10004 20MG</P> <P>&nbsp;</P> <P>I want the final dataset to look like as follows.</P> <P>&nbsp;</P> <P>subject dose block<BR />10002 10MG &nbsp; 1<BR />10002 10MG &nbsp; 1<BR />10002 20MG &nbsp; 2<BR />10002 10MG &nbsp; 3<BR />10002 10MG &nbsp; 3<BR /><BR />10004 10MG &nbsp; 1<BR />10004 10MG &nbsp; 1<BR />10004 10MG &nbsp; 1<BR />10004 20MG &nbsp; 2<BR />10004 20MG &nbsp; 2</P> <P>&nbsp;</P> <P>any thoughts?</P> <P>&nbsp;</P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> <P><BR />&nbsp;</P> Fri, 12 May 2017 02:31:52 GMT https://communities.sas.com/t5/SAS-Programming/creating-blocks/m-p/358092#M274357 Reeza 2017-05-12T02:31:52Z