https://communities.sas.com/t5/SAS-Programming/Assigning-extra-values/m-p/783597#M249896 <PRE><CODE class=" language-sas">data want; &nbsp; &nbsp; set have; &nbsp; &nbsp; do i=1 to 3; test_id=cats('TEST',i); output; end; run;</CODE></PRE> Thu, 02 Dec 2021 12:46:28 GMT PaigeMiller 2021-12-02T12:46:28Z https://communities.sas.com/t5/SAS-Programming/Assigning-extra-values/m-p/783596#M249895 <P>Dear All,</P> <P>&nbsp;</P> <P>Can anyone help me with the below query ?</P> <P>&nbsp;</P> <P>I have a dataset as below:</P> <P>&nbsp;</P> <P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TIME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SAMPLE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST ID</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLOOD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 hour&nbsp; &nbsp; &nbsp; &nbsp; URINE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine</P> <P>&nbsp;</P> <P>For the above data i need to assign TESTID values as some test1, test2, test3 per ID, per TIME and per sample. Desired output is as below:</P> <P>&nbsp;</P> <P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TIME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SAMPLE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST ID</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLOOD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST1</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLOOD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST2&nbsp;</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLOOD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST3</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 hour&nbsp; &nbsp; &nbsp; &nbsp; URINE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST 1</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 hour&nbsp; &nbsp; &nbsp; &nbsp; URINE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST 2</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 hour&nbsp; &nbsp; &nbsp; &nbsp; URINE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST 3</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TEST 1</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TEST 2&nbsp;</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TEST 3&nbsp; &nbsp;</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST 1</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST 2</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST 3&nbsp; &nbsp;&nbsp;</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TEST 1</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TEST 2</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TEST 3</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST 1</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST 2</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST 3</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TEST 1</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TEST 2</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TEST 3</P> Thu, 02 Dec 2021 12:54:24 GMT https://communities.sas.com/t5/SAS-Programming/Assigning-extra-values/m-p/783596#M249895 r3570 2021-12-02T12:54:24Z https://communities.sas.com/t5/SAS-Programming/Assigning-extra-values/m-p/783597#M249896 <PRE><CODE class=" language-sas">data want; &nbsp; &nbsp; set have; &nbsp; &nbsp; do i=1 to 3; test_id=cats('TEST',i); output; end; run;</CODE></PRE> Thu, 02 Dec 2021 12:46:28 GMT https://communities.sas.com/t5/SAS-Programming/Assigning-extra-values/m-p/783597#M249896 PaigeMiller 2021-12-02T12:46:28Z https://communities.sas.com/t5/SAS-Programming/Assigning-extra-values/m-p/783599#M249898 <P>Thanks Miller,</P> <P>But I have a doubt here..</P> <P>what if there are some values like ADB12PL, ADP13LM, DEF99SE which are to be assigned for TEST ID instead of test1, test2 and test3 ?</P> Thu, 02 Dec 2021 12:51:57 GMT https://communities.sas.com/t5/SAS-Programming/Assigning-extra-values/m-p/783599#M249898 r3570 2021-12-02T12:51:57Z https://communities.sas.com/t5/SAS-Programming/Assigning-extra-values/m-p/783602#M249901 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/382012">@r3570</a>&nbsp;wrote:<BR /> <P>&nbsp;</P> <P>what if there are some values like ADB12PL, ADP13LM, DEF99SE which are to be assigned for TEST ID instead of test1, test2 and test3 ?</P> <HR /></BLOCKQUOTE> <P>Explain this, please. Show an example.</P> Thu, 02 Dec 2021 13:06:07 GMT https://communities.sas.com/t5/SAS-Programming/Assigning-extra-values/m-p/783602#M249901 PaigeMiller 2021-12-02T13:06:07Z https://communities.sas.com/t5/SAS-Programming/Assigning-extra-values/m-p/783603#M249902 <P>Output required as below:</P> <P>&nbsp;</P> <P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TIME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SAMPLE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEST ID</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLOOD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADB12PL</SPAN></P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLOOD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADP13LM</SPAN></P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLOOD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>DEF99SE</SPAN></P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 hour&nbsp; &nbsp; &nbsp; &nbsp; URINE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADB12PL</SPAN></P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 hour&nbsp; &nbsp; &nbsp; &nbsp; URINE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADP13LM</SPAN></P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 hour&nbsp; &nbsp; &nbsp; &nbsp; URINE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>DEF99SE</SPAN></P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADB12PL</SPAN></P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADP13LM</SPAN></P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>DEF99SE</SPAN></P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADB12PL</SPAN></P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADP13LM</SPAN></P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>DEF99SE</SPAN> &nbsp;&nbsp;</P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADB12PL</SPAN></P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADP13LM</SPAN></P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>DEF99SE</SPAN></P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADB12PL</SPAN></P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADP13LM</SPAN></P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blood&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>DEF99SE</SPAN></P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADB12PL</SPAN></P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>ADP13LM</SPAN></P> <P>103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 hour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;urine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN>DEF99SE</SPAN></P> Thu, 02 Dec 2021 13:10:58 GMT https://communities.sas.com/t5/SAS-Programming/Assigning-extra-values/m-p/783603#M249902 r3570 2021-12-02T13:10:58Z https://communities.sas.com/t5/SAS-Programming/Assigning-extra-values/m-p/783604#M249903 <PRE><CODE class=" language-sas">data want; set have; test_id='ADB12PL'; output; test_id='ADP13LM'; output; test_id='DEF99SE'; output; run;</CODE></PRE> Thu, 02 Dec 2021 13:14:44 GMT https://communities.sas.com/t5/SAS-Programming/Assigning-extra-values/m-p/783604#M249903 PaigeMiller 2021-12-02T13:14:44Z