https://communities.sas.com/t5/SAS-Enterprise-Guide/To-create-an-ordered-list-with-counters-for-three-attributes/m-p/686633#M37102 <P><SPAN>I would like to create an ordered list with counters for three attributes. </SPAN></P><P><SPAN>I would like to insert the meters highlighted in red in my table. </SPAN></P><P><SPAN>could anyone help me?</SPAN></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IMMAGINE_SAS_SUPPORT.png" style="width: 896px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/49776i9E03E75A3B450D04/image-size/large?v=v2&amp;px=999" role="button" title="IMMAGINE_SAS_SUPPORT.png" alt="IMMAGINE_SAS_SUPPORT.png" /></span></P> Fri, 25 Sep 2020 08:20:38 GMT daniele_1306 2020-09-25T08:20:38Z https://communities.sas.com/t5/SAS-Enterprise-Guide/To-create-an-ordered-list-with-counters-for-three-attributes/m-p/686633#M37102 <P><SPAN>I would like to create an ordered list with counters for three attributes. </SPAN></P><P><SPAN>I would like to insert the meters highlighted in red in my table. </SPAN></P><P><SPAN>could anyone help me?</SPAN></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IMMAGINE_SAS_SUPPORT.png" style="width: 896px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/49776i9E03E75A3B450D04/image-size/large?v=v2&amp;px=999" role="button" title="IMMAGINE_SAS_SUPPORT.png" alt="IMMAGINE_SAS_SUPPORT.png" /></span></P> Fri, 25 Sep 2020 08:20:38 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/To-create-an-ordered-list-with-counters-for-three-attributes/m-p/686633#M37102 daniele_1306 2020-09-25T08:20:38Z https://communities.sas.com/t5/SAS-Enterprise-Guide/To-create-an-ordered-list-with-counters-for-three-attributes/m-p/686634#M37103 <P><SPAN>the columns not highlighted are my input data</SPAN></P> Fri, 25 Sep 2020 08:21:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/To-create-an-ordered-list-with-counters-for-three-attributes/m-p/686634#M37103 daniele_1306 2020-09-25T08:21:57Z https://communities.sas.com/t5/SAS-Enterprise-Guide/To-create-an-ordered-list-with-counters-for-three-attributes/m-p/686748#M37105 <P>Please state the rules involved.</P> <P>I would guess that you are incrementing cliente_group_cliente when the&nbsp; "id conto" value changes. Guess, because you only show one value for "id conto".</P> <P>I would also guess that counter_in_group_attivita increases when "Tipo attivita" changes.</P> <P>Those two I can do.</P> <P>I might guess that the counter_att_flag is set to 1 when flag_attivita is one then increased until the the next 1 is encountered. But it is not clear whether that count would reset when TIPO Attivita changes or not. And what if the first value of Flag_attivita is not 1 for the first value of Tipo Attivita?</P> <P>&nbsp;</P> <P>Please state the rules.</P> <P>Show examples with at least two values of ID Conto.</P> <P>I cannot write code against a picture.</P> <P>Instructions here: <A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712</A> will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the &lt;/&gt; icon or attached as text to show exactly what you have and that we can test code against.</P> Fri, 25 Sep 2020 16:16:45 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/To-create-an-ordered-list-with-counters-for-three-attributes/m-p/686748#M37105 ballardw 2020-09-25T16:16:45Z