topic Re: Converting measurement occasions to numbers in SAS Programming https://communities.sas.com/t5/SAS-Programming/Converting-measurement-occasions-to-numbers/m-p/783045#M249632 <PRE><CODE class=" language-sas">data want; set have; by location; if first.location then counter=0; counter+1; run;</CODE></PRE> <BLOCKQUOTE><HR />I want them to be categorical.<HR /></BLOCKQUOTE> <P>I don't know what 'them to be categorical' means.</P> <P>&nbsp;</P> <LI-SPOILER> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/324234">@Job04</a>&nbsp;wrote:<BR /> <P>I have bi-weekly measurements and in total 23 measurements per country. I want to convert the days of measurements which corresponds to days in&nbsp; months to simply numbering these measurement occasions from 1 to 23 for all countries. I want them to be categorical. Thank you.&nbsp;</P> <P>&nbsp;&nbsp;</P> <P>location,day<BR />Austria,14<BR />Austria,28<BR />Austria,11<BR />Austria,25<BR />Austria,11<BR />Austria,25<BR />Austria,8<BR />Austria,22<BR />Austria,6<BR />Austria,20<BR />Austria,3<BR />Austria,17<BR />Austria,1<BR />Austria,15<BR />Austria,29<BR />Austria,12<BR />Austria,26<BR />Austria,9<BR />Austria,23<BR />Austria,7<BR />Austria,21<BR />Austria,4<BR />Austria,18<BR />Belgium,14<BR />Belgium,28<BR />Belgium,11<BR />Belgium,25<BR />Belgium,11<BR />Belgium,25<BR />Belgium,8<BR />Belgium,22<BR />Belgium,6<BR />Belgium,20<BR />Belgium,3<BR />Belgium,17<BR />Belgium,1<BR />Belgium,15<BR />Belgium,29<BR />Belgium,12<BR />Belgium,26<BR />Belgium,9<BR />Belgium,23<BR />Belgium,7<BR />Belgium,21<BR />Belgium,4<BR />Belgium,18<BR />Bulgari,14<BR />Bulgari,28<BR />Bulgari,11<BR />Bulgari,25<BR />Bulgari,11<BR />Bulgari,25<BR />Bulgari,8<BR />Bulgari,22<BR />Bulgari,6<BR />Bulgari,20<BR />Bulgari,3<BR />Bulgari,17<BR />Bulgari,1<BR />Bulgari,15<BR />Bulgari,29<BR />Bulgari,12<BR />Bulgari,26<BR />Bulgari,9<BR />Bulgari,23<BR />Bulgari,7<BR />Bulgari,21<BR />Bulgari,4<BR />Bulgari,18</P> <HR /></BLOCKQUOTE> </LI-SPOILER> Mon, 29 Nov 2021 23:07:53 GMT Reeza 2021-11-29T23:07:53Z Converting measurement occasions to numbers https://communities.sas.com/t5/SAS-Programming/Converting-measurement-occasions-to-numbers/m-p/783043#M249631 <P>I have bi-weekly measurements and in total 23 measurements per country. I want to convert the days of measurements which corresponds to days in&nbsp; months to simply numbering these measurement occasions from 1 to 23 for all countries. I want them to be categorical. Thank you.&nbsp;</P><P>&nbsp;&nbsp;</P><P>location,day<BR />Austria,14<BR />Austria,28<BR />Austria,11<BR />Austria,25<BR />Austria,11<BR />Austria,25<BR />Austria,8<BR />Austria,22<BR />Austria,6<BR />Austria,20<BR />Austria,3<BR />Austria,17<BR />Austria,1<BR />Austria,15<BR />Austria,29<BR />Austria,12<BR />Austria,26<BR />Austria,9<BR />Austria,23<BR />Austria,7<BR />Austria,21<BR />Austria,4<BR />Austria,18<BR />Belgium,14<BR />Belgium,28<BR />Belgium,11<BR />Belgium,25<BR />Belgium,11<BR />Belgium,25<BR />Belgium,8<BR />Belgium,22<BR />Belgium,6<BR />Belgium,20<BR />Belgium,3<BR />Belgium,17<BR />Belgium,1<BR />Belgium,15<BR />Belgium,29<BR />Belgium,12<BR />Belgium,26<BR />Belgium,9<BR />Belgium,23<BR />Belgium,7<BR />Belgium,21<BR />Belgium,4<BR />Belgium,18<BR />Bulgari,14<BR />Bulgari,28<BR />Bulgari,11<BR />Bulgari,25<BR />Bulgari,11<BR />Bulgari,25<BR />Bulgari,8<BR />Bulgari,22<BR />Bulgari,6<BR />Bulgari,20<BR />Bulgari,3<BR />Bulgari,17<BR />Bulgari,1<BR />Bulgari,15<BR />Bulgari,29<BR />Bulgari,12<BR />Bulgari,26<BR />Bulgari,9<BR />Bulgari,23<BR />Bulgari,7<BR />Bulgari,21<BR />Bulgari,4<BR />Bulgari,18</P> Mon, 29 Nov 2021 22:58:13 GMT https://communities.sas.com/t5/SAS-Programming/Converting-measurement-occasions-to-numbers/m-p/783043#M249631 Job04 2021-11-29T22:58:13Z Re: Converting measurement occasions to numbers https://communities.sas.com/t5/SAS-Programming/Converting-measurement-occasions-to-numbers/m-p/783045#M249632 <PRE><CODE class=" language-sas">data want; set have; by location; if first.location then counter=0; counter+1; run;</CODE></PRE> <BLOCKQUOTE><HR />I want them to be categorical.<HR /></BLOCKQUOTE> <P>I don't know what 'them to be categorical' means.</P> <P>&nbsp;</P> <LI-SPOILER> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/324234">@Job04</a>&nbsp;wrote:<BR /> <P>I have bi-weekly measurements and in total 23 measurements per country. I want to convert the days of measurements which corresponds to days in&nbsp; months to simply numbering these measurement occasions from 1 to 23 for all countries. I want them to be categorical. Thank you.&nbsp;</P> <P>&nbsp;&nbsp;</P> <P>location,day<BR />Austria,14<BR />Austria,28<BR />Austria,11<BR />Austria,25<BR />Austria,11<BR />Austria,25<BR />Austria,8<BR />Austria,22<BR />Austria,6<BR />Austria,20<BR />Austria,3<BR />Austria,17<BR />Austria,1<BR />Austria,15<BR />Austria,29<BR />Austria,12<BR />Austria,26<BR />Austria,9<BR />Austria,23<BR />Austria,7<BR />Austria,21<BR />Austria,4<BR />Austria,18<BR />Belgium,14<BR />Belgium,28<BR />Belgium,11<BR />Belgium,25<BR />Belgium,11<BR />Belgium,25<BR />Belgium,8<BR />Belgium,22<BR />Belgium,6<BR />Belgium,20<BR />Belgium,3<BR />Belgium,17<BR />Belgium,1<BR />Belgium,15<BR />Belgium,29<BR />Belgium,12<BR />Belgium,26<BR />Belgium,9<BR />Belgium,23<BR />Belgium,7<BR />Belgium,21<BR />Belgium,4<BR />Belgium,18<BR />Bulgari,14<BR />Bulgari,28<BR />Bulgari,11<BR />Bulgari,25<BR />Bulgari,11<BR />Bulgari,25<BR />Bulgari,8<BR />Bulgari,22<BR />Bulgari,6<BR />Bulgari,20<BR />Bulgari,3<BR />Bulgari,17<BR />Bulgari,1<BR />Bulgari,15<BR />Bulgari,29<BR />Bulgari,12<BR />Bulgari,26<BR />Bulgari,9<BR />Bulgari,23<BR />Bulgari,7<BR />Bulgari,21<BR />Bulgari,4<BR />Bulgari,18</P> <HR /></BLOCKQUOTE> </LI-SPOILER> Mon, 29 Nov 2021 23:07:53 GMT https://communities.sas.com/t5/SAS-Programming/Converting-measurement-occasions-to-numbers/m-p/783045#M249632 Reeza 2021-11-29T23:07:53Z