topic Re: Counting a fixed variable in SAS Programming https://communities.sas.com/t5/SAS-Programming/Counting-a-fixed-variable/m-p/611054#M178040 <P>Simple application of BY group processing.</P> <PRE><CODE class=" language-sas">data want; set have; by well_group; count+1; if first.well_group then count=1; run;</CODE></PRE> Wed, 11 Dec 2019 16:12:52 GMT Tom 2019-12-11T16:12:52Z Counting a fixed variable https://communities.sas.com/t5/SAS-Programming/Counting-a-fixed-variable/m-p/611053#M178039 <P>Dear programmers,</P> <P>&nbsp;</P> <P>How can I count a fixed variable in an easy way?</P> <P>&nbsp;</P> <P>What I have is:</P> <P>&nbsp;</P> <P>&nbsp;</P> <TABLE width="84"> <TBODY> <TR> <TD width="84">WELL_NAME</TD> </TR> <TR> <TD>A</TD> </TR> <TR> <TD>A</TD> </TR> <TR> <TD>A</TD> </TR> <TR> <TD>A</TD> </TR> <TR> <TD>A</TD> </TR> <TR> <TD>A</TD> </TR> <TR> <TD>A</TD> </TR> <TR> <TD>A</TD> </TR> <TR> <TD>A</TD> </TR> <TR> <TD>B</TD> </TR> <TR> <TD>B</TD> </TR> <TR> <TD>C</TD> </TR> <TR> <TD>C</TD> </TR> <TR> <TD>C</TD> </TR> <TR> <TD>C</TD> </TR> <TR> <TD>C</TD> </TR> <TR> <TD>C</TD> </TR> <TR> <TD>C</TD> </TR> <TR> <TD>C</TD> </TR> <TR> <TD>D</TD> </TR> <TR> <TD>D</TD> </TR> <TR> <TD>E</TD> </TR> <TR> <TD>E</TD> </TR> <TR> <TD>E</TD> </TR> <TR> <TD>E</TD> </TR> <TR> <TD>E</TD> </TR> <TR> <TD>E</TD> </TR> <TR> <TD>F</TD> </TR> <TR> <TD>F</TD> </TR> <TR> <TD>F</TD> </TR> <TR> <TD>F</TD> </TR> <TR> <TD>F</TD> </TR> <TR> <TD>F</TD> </TR> <TR> <TD>F</TD> </TR> <TR> <TD>F</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>What I want is:</P> <P>&nbsp;</P> <TABLE width="148"> <TBODY> <TR> <TD width="84">WELL_NAME</TD> <TD width="64">COUNT</TD> </TR> <TR> <TD>A</TD> <TD>1</TD> </TR> <TR> <TD>A</TD> <TD>2</TD> </TR> <TR> <TD>A</TD> <TD>3</TD> </TR> <TR> <TD>A</TD> <TD>4</TD> </TR> <TR> <TD>A</TD> <TD>5</TD> </TR> <TR> <TD>A</TD> <TD>6</TD> </TR> <TR> <TD>A</TD> <TD>7</TD> </TR> <TR> <TD>A</TD> <TD>8</TD> </TR> <TR> <TD>A</TD> <TD>9</TD> </TR> <TR> <TD>B</TD> <TD>1</TD> </TR> <TR> <TD>B</TD> <TD>2</TD> </TR> <TR> <TD>C</TD> <TD>1</TD> </TR> <TR> <TD>C</TD> <TD>2</TD> </TR> <TR> <TD>C</TD> <TD>3</TD> </TR> <TR> <TD>C</TD> <TD>4</TD> </TR> <TR> <TD>C</TD> <TD>5</TD> </TR> <TR> <TD>C</TD> <TD>6</TD> </TR> <TR> <TD>C</TD> <TD>7</TD> </TR> <TR> <TD>C</TD> <TD>8</TD> </TR> <TR> <TD>D</TD> <TD>1</TD> </TR> <TR> <TD>D</TD> <TD>2</TD> </TR> <TR> <TD>E</TD> <TD>1</TD> </TR> <TR> <TD>E</TD> <TD>2</TD> </TR> <TR> <TD>E</TD> <TD>3</TD> </TR> <TR> <TD>E</TD> <TD>4</TD> </TR> <TR> <TD>E</TD> <TD>5</TD> </TR> <TR> <TD>E</TD> <TD>6</TD> </TR> <TR> <TD>F</TD> <TD>1</TD> </TR> <TR> <TD>F</TD> <TD>2</TD> </TR> <TR> <TD>F</TD> <TD>3</TD> </TR> <TR> <TD>F</TD> <TD>4</TD> </TR> <TR> <TD>F</TD> <TD>5</TD> </TR> <TR> <TD>F</TD> <TD>6</TD> </TR> <TR> <TD>F</TD> <TD>7</TD> </TR> <TR> <TD>F</TD> <TD>8</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Best regards</P> <P>&nbsp;</P> <P>Farshid&nbsp;</P> Wed, 11 Dec 2019 15:46:55 GMT https://communities.sas.com/t5/SAS-Programming/Counting-a-fixed-variable/m-p/611053#M178039 farshidowrang 2019-12-11T15:46:55Z Re: Counting a fixed variable https://communities.sas.com/t5/SAS-Programming/Counting-a-fixed-variable/m-p/611054#M178040 <P>Simple application of BY group processing.</P> <PRE><CODE class=" language-sas">data want; set have; by well_group; count+1; if first.well_group then count=1; run;</CODE></PRE> Wed, 11 Dec 2019 16:12:52 GMT https://communities.sas.com/t5/SAS-Programming/Counting-a-fixed-variable/m-p/611054#M178040 Tom 2019-12-11T16:12:52Z Re: Counting a fixed variable https://communities.sas.com/t5/SAS-Programming/Counting-a-fixed-variable/m-p/611096#M178049 <P>This outlines how you can do this:</P> <P><A href="https://stats.idre.ucla.edu/sas/faq/how-can-i-create-an-enumeration-variable-by-groups/" target="_blank">https://stats.idre.ucla.edu/sas/faq/how-can-i-create-an-enumeration-variable-by-groups/</A></P> Wed, 11 Dec 2019 18:22:15 GMT https://communities.sas.com/t5/SAS-Programming/Counting-a-fixed-variable/m-p/611096#M178049 Reeza 2019-12-11T18:22:15Z Re: Counting a fixed variable https://communities.sas.com/t5/SAS-Programming/Counting-a-fixed-variable/m-p/611235#M178110 Thank you very much my friend!<BR /><BR />Best regards<BR /><BR />Farshid Thu, 12 Dec 2019 09:00:16 GMT https://communities.sas.com/t5/SAS-Programming/Counting-a-fixed-variable/m-p/611235#M178110 farshidowrang 2019-12-12T09:00:16Z Re: Counting a fixed variable https://communities.sas.com/t5/SAS-Programming/Counting-a-fixed-variable/m-p/611236#M178111 Thank you! Thu, 12 Dec 2019 09:00:40 GMT https://communities.sas.com/t5/SAS-Programming/Counting-a-fixed-variable/m-p/611236#M178111 farshidowrang 2019-12-12T09:00:40Z