topic Re: How to create a variable column when repeated groups are unlabled? in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465119#M285215 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/6309">@iiibbb</a>&nbsp;You are very welcome. That's what the community is for. All of us work as a team for a common good i.e knowledge sharing</P> Fri, 25 May 2018 15:35:48 GMT novinosrin 2018-05-25T15:35:48Z How to create a variable column when repeated groups are unlabled? https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465083#M285207 <P>I have a dataset that was generated by an old FORTRAN model.&nbsp; The output are time steps, diameter groups, and some variables calculated for a model that goes with those groups.</P> <P>&nbsp;</P> <P>There are 16 lines giving model outputs for 16 diameter classes.&nbsp; The first 16 lines is species A for time X, the second 16 lines for species B for time X, the third 16 lines for species C for time X, the fourth 16 lines the combined total of the three species.<BR /><BR />Then the pattern repeats.&nbsp;&nbsp;</P> <P>&nbsp;</P> <P>Any suggestions for automating the labeling?&nbsp; I have a few dozen of these to go through and the data sets for each time X are 40K lines each.&nbsp; Attached is one set of data. and below is what I need it to look like with a new species column.&nbsp; I think with this model output it's always 16 lines per species or total.<BR /><BR /></P> <TABLE width="312"> <TBODY> <TR> <TD width="36">Species</TD> <TD width="37">time</TD> <TD width="52">group</TD> <TD width="57">numtrees</TD> <TD width="35">BA</TD> <TD width="49">STMV</TD> <TD width="46">SVTS</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">1.00-4.99</TD> <TD width="57">112</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">5.00-9.99</TD> <TD width="57">56</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">10.00-14.99</TD> <TD width="57">49</TD> <TD width="35">0.6</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">15.00-19.99</TD> <TD width="57">41</TD> <TD width="35">0.9</TD> <TD width="49">4.74</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">20.00-24.99</TD> <TD width="57">30</TD> <TD width="35">1.1</TD> <TD width="49">7.49</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">25.00-29.99</TD> <TD width="57">27</TD> <TD width="35">1.5</TD> <TD width="49">12.26</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">30.00-34.99</TD> <TD width="57">18</TD> <TD width="35">1.4</TD> <TD width="49">12.72</TD> <TD width="46">8.46</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">35.00-39.99</TD> <TD width="57">8</TD> <TD width="35">0.9</TD> <TD width="49">8.06</TD> <TD width="46">6.35</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">40.00-44.99</TD> <TD width="57">10</TD> <TD width="35">1.4</TD> <TD width="49">14.42</TD> <TD width="46">11.87</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">45.00-49.99</TD> <TD width="57">7</TD> <TD width="35">1.3</TD> <TD width="49">13.28</TD> <TD width="46">10.76</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">50.00-54.99</TD> <TD width="57">5</TD> <TD width="35">1.1</TD> <TD width="49">11.62</TD> <TD width="46">9.13</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">55.00-59.99</TD> <TD width="57">1</TD> <TD width="35">0.3</TD> <TD width="49">3.04</TD> <TD width="46">2.26</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">60.00-64.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">1.00-4.99</TD> <TD width="57">46</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">5.00-9.99</TD> <TD width="57">21</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">10.00-14.99</TD> <TD width="57">17</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">15.00-19.99</TD> <TD width="57">17</TD> <TD width="35">0.4</TD> <TD width="49">2.09</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">20.00-24.99</TD> <TD width="57">8</TD> <TD width="35">0.3</TD> <TD width="49">2</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">25.00-29.99</TD> <TD width="57">7</TD> <TD width="35">0.4</TD> <TD width="49">2.88</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">30.00-34.99</TD> <TD width="57">6</TD> <TD width="35">0.5</TD> <TD width="49">4.46</TD> <TD width="46">3.08</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">35.00-39.99</TD> <TD width="57">5</TD> <TD width="35">0.5</TD> <TD width="49">5.05</TD> <TD width="46">3.99</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">40.00-44.99</TD> <TD width="57">2</TD> <TD width="35">0.3</TD> <TD width="49">2.78</TD> <TD width="46">2.28</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">45.00-49.99</TD> <TD width="57">1</TD> <TD width="35">0.2</TD> <TD width="49">1.9</TD> <TD width="46">1.54</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">50.00-54.99</TD> <TD width="57">1</TD> <TD width="35">0.2</TD> <TD width="49">2.18</TD> <TD width="46">1.73</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">55.00-59.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">60.00-64.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">1.00-4.99</TD> <TD width="57">42</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">5.00-9.99</TD> <TD width="57">23</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">10.00-14.99</TD> <TD width="57">14</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">15.00-19.99</TD> <TD width="57">12</TD> <TD width="35">0.3</TD> <TD width="49">1.51</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">20.00-24.99</TD> <TD width="57">17</TD> <TD width="35">0.6</TD> <TD width="49">4.16</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">25.00-29.99</TD> <TD width="57">6</TD> <TD width="35">0.3</TD> <TD width="49">2.73</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">30.00-34.99</TD> <TD width="57">6</TD> <TD width="35">0.5</TD> <TD width="49">4.24</TD> <TD width="46">2.82</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">35.00-39.99</TD> <TD width="57">7</TD> <TD width="35">0.7</TD> <TD width="49">6.63</TD> <TD width="46">5.15</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">40.00-44.99</TD> <TD width="57">3</TD> <TD width="35">0.4</TD> <TD width="49">4.01</TD> <TD width="46">3.29</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">45.00-49.99</TD> <TD width="57">2</TD> <TD width="35">0.3</TD> <TD width="49">3.35</TD> <TD width="46">2.74</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">50.00-54.99</TD> <TD width="57">2</TD> <TD width="35">0.4</TD> <TD width="49">4.27</TD> <TD width="46">3.4</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">55.00-59.99</TD> <TD width="57">3</TD> <TD width="35">0.7</TD> <TD width="49">8</TD> <TD width="46">6.13</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">60.00-64.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">1.00-4.99</TD> <TD width="57">200</TD> <TD width="35">0.3</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">5.00-9.99</TD> <TD width="57">100</TD> <TD width="35">0.4</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">10.00-14.99</TD> <TD width="57">80</TD> <TD width="35">0.9</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">15.00-19.99</TD> <TD width="57">70</TD> <TD width="35">1.5</TD> <TD width="49">8.35</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">20.00-24.99</TD> <TD width="57">55</TD> <TD width="35">2</TD> <TD width="49">13.64</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">25.00-29.99</TD> <TD width="57">40</TD> <TD width="35">2.2</TD> <TD width="49">17.88</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">30.00-34.99</TD> <TD width="57">30</TD> <TD width="35">2.4</TD> <TD width="49">21.43</TD> <TD width="46">14.36</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">35.00-39.99</TD> <TD width="57">20</TD> <TD width="35">2.1</TD> <TD width="49">19.74</TD> <TD width="46">15.49</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">40.00-44.99</TD> <TD width="57">15</TD> <TD width="35">2.1</TD> <TD width="49">21.21</TD> <TD width="46">17.44</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">45.00-49.99</TD> <TD width="57">10</TD> <TD width="35">1.8</TD> <TD width="49">18.53</TD> <TD width="46">15.04</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">50.00-54.99</TD> <TD width="57">8</TD> <TD width="35">1.7</TD> <TD width="49">18.06</TD> <TD width="46">14.27</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">55.00-59.99</TD> <TD width="57">4</TD> <TD width="35">1</TD> <TD width="49">11.04</TD> <TD width="46">8.39</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">60.00-64.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">1.00-4.99</TD> <TD width="57">1063</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">5.00-9.99</TD> <TD width="57">116</TD> <TD width="35">0.4</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">10.00-14.99</TD> <TD width="57">46</TD> <TD width="35">0.5</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">15.00-19.99</TD> <TD width="57">41</TD> <TD width="35">1</TD> <TD width="49">5.66</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">20.00-24.99</TD> <TD width="57">36</TD> <TD width="35">1.4</TD> <TD width="49">9.83</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">25.00-29.99</TD> <TD width="57">23</TD> <TD width="35">1.4</TD> <TD width="49">10.92</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">30.00-34.99</TD> <TD width="57">20</TD> <TD width="35">1.6</TD> <TD width="49">14.67</TD> <TD width="46">10</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">35.00-39.99</TD> <TD width="57">13</TD> <TD width="35">1.4</TD> <TD width="49">13.6</TD> <TD width="46">10.8</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">40.00-44.99</TD> <TD width="57">7</TD> <TD width="35">1</TD> <TD width="49">10.46</TD> <TD width="46">8.6</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">45.00-49.99</TD> <TD width="57">6</TD> <TD width="35">1.1</TD> <TD width="49">10.99</TD> <TD width="46">8.93</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">50.00-54.99</TD> <TD width="57">7</TD> <TD width="35">1.5</TD> <TD width="49">15.47</TD> <TD width="46">12.27</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">55.00-59.99</TD> <TD width="57">3</TD> <TD width="35">0.8</TD> <TD width="49">8.32</TD> <TD width="46">6.32</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">60.00-64.99</TD> <TD width="57">1</TD> <TD width="35">0.3</TD> <TD width="49">3.19</TD> <TD width="46">2.35</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">5</TD> <TD width="52">1.00-4.99</TD> <TD width="57">392</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">5</TD> <TD width="52">5.00-9.99</TD> <TD width="57">48</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">5</TD> <TD width="52">10.00-14.99</TD> <TD width="57">15</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD width="36">etc.</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> <P><BR /><BR /><BR /></P> Fri, 25 May 2018 14:35:04 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465083#M285207 iiibbb 2018-05-25T14:35:04Z Re: How to create a variable column when repeated groups are unlabled? https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465093#M285208 <P>What do you mean by 'labeling'?</P> <P>Its not clear what you want as output.&nbsp;</P> <P>&nbsp;</P> <P>If you're trying to create groups, then using a combination of Species and Time in the BY statement would work.</P> <P>&nbsp;</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> <P>&nbsp;</P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/6309">@iiibbb</a>&nbsp;wrote:<BR /> <P>I have a dataset that was generated by an old FORTRAN model.&nbsp; The output are time steps, diameter groups, and some variables calculated for a model that goes with those groups.</P> <P>&nbsp;</P> <P>There are 16 lines giving model outputs for 16 diameter classes.&nbsp; The first 16 lines is species A for time X, the second 16 lines for species B for time X, the third 16 lines for species C for time X, the fourth 16 lines the combined total of the three species.<BR /><BR />Then the pattern repeats.&nbsp;&nbsp;</P> <P>&nbsp;</P> <P>Any suggestions for automating the labeling?&nbsp; I have a few dozen of these to go through and the data sets for each time X are 40K lines each.&nbsp; Attached is one set of data. and below is what I need it to look like with a new species column.&nbsp; I think with this model output it's always 16 lines per species or total.<BR /><BR /></P> <TABLE width="312"> <TBODY> <TR> <TD width="36">Species</TD> <TD width="37">time</TD> <TD width="52">group</TD> <TD width="57">numtrees</TD> <TD width="35">BA</TD> <TD width="49">STMV</TD> <TD width="46">SVTS</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">1.00-4.99</TD> <TD width="57">112</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">5.00-9.99</TD> <TD width="57">56</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">10.00-14.99</TD> <TD width="57">49</TD> <TD width="35">0.6</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">15.00-19.99</TD> <TD width="57">41</TD> <TD width="35">0.9</TD> <TD width="49">4.74</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">20.00-24.99</TD> <TD width="57">30</TD> <TD width="35">1.1</TD> <TD width="49">7.49</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">25.00-29.99</TD> <TD width="57">27</TD> <TD width="35">1.5</TD> <TD width="49">12.26</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">30.00-34.99</TD> <TD width="57">18</TD> <TD width="35">1.4</TD> <TD width="49">12.72</TD> <TD width="46">8.46</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">35.00-39.99</TD> <TD width="57">8</TD> <TD width="35">0.9</TD> <TD width="49">8.06</TD> <TD width="46">6.35</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">40.00-44.99</TD> <TD width="57">10</TD> <TD width="35">1.4</TD> <TD width="49">14.42</TD> <TD width="46">11.87</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">45.00-49.99</TD> <TD width="57">7</TD> <TD width="35">1.3</TD> <TD width="49">13.28</TD> <TD width="46">10.76</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">50.00-54.99</TD> <TD width="57">5</TD> <TD width="35">1.1</TD> <TD width="49">11.62</TD> <TD width="46">9.13</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">55.00-59.99</TD> <TD width="57">1</TD> <TD width="35">0.3</TD> <TD width="49">3.04</TD> <TD width="46">2.26</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">60.00-64.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">0</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">1.00-4.99</TD> <TD width="57">46</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">5.00-9.99</TD> <TD width="57">21</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">10.00-14.99</TD> <TD width="57">17</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">15.00-19.99</TD> <TD width="57">17</TD> <TD width="35">0.4</TD> <TD width="49">2.09</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">20.00-24.99</TD> <TD width="57">8</TD> <TD width="35">0.3</TD> <TD width="49">2</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">25.00-29.99</TD> <TD width="57">7</TD> <TD width="35">0.4</TD> <TD width="49">2.88</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">30.00-34.99</TD> <TD width="57">6</TD> <TD width="35">0.5</TD> <TD width="49">4.46</TD> <TD width="46">3.08</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">35.00-39.99</TD> <TD width="57">5</TD> <TD width="35">0.5</TD> <TD width="49">5.05</TD> <TD width="46">3.99</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">40.00-44.99</TD> <TD width="57">2</TD> <TD width="35">0.3</TD> <TD width="49">2.78</TD> <TD width="46">2.28</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">45.00-49.99</TD> <TD width="57">1</TD> <TD width="35">0.2</TD> <TD width="49">1.9</TD> <TD width="46">1.54</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">50.00-54.99</TD> <TD width="57">1</TD> <TD width="35">0.2</TD> <TD width="49">2.18</TD> <TD width="46">1.73</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">55.00-59.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">60.00-64.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">0</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">1.00-4.99</TD> <TD width="57">42</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">5.00-9.99</TD> <TD width="57">23</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">10.00-14.99</TD> <TD width="57">14</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">15.00-19.99</TD> <TD width="57">12</TD> <TD width="35">0.3</TD> <TD width="49">1.51</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">20.00-24.99</TD> <TD width="57">17</TD> <TD width="35">0.6</TD> <TD width="49">4.16</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">25.00-29.99</TD> <TD width="57">6</TD> <TD width="35">0.3</TD> <TD width="49">2.73</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">30.00-34.99</TD> <TD width="57">6</TD> <TD width="35">0.5</TD> <TD width="49">4.24</TD> <TD width="46">2.82</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">35.00-39.99</TD> <TD width="57">7</TD> <TD width="35">0.7</TD> <TD width="49">6.63</TD> <TD width="46">5.15</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">40.00-44.99</TD> <TD width="57">3</TD> <TD width="35">0.4</TD> <TD width="49">4.01</TD> <TD width="46">3.29</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">45.00-49.99</TD> <TD width="57">2</TD> <TD width="35">0.3</TD> <TD width="49">3.35</TD> <TD width="46">2.74</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">50.00-54.99</TD> <TD width="57">2</TD> <TD width="35">0.4</TD> <TD width="49">4.27</TD> <TD width="46">3.4</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">55.00-59.99</TD> <TD width="57">3</TD> <TD width="35">0.7</TD> <TD width="49">8</TD> <TD width="46">6.13</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">60.00-64.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">C</TD> <TD width="37">0</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">1.00-4.99</TD> <TD width="57">200</TD> <TD width="35">0.3</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">5.00-9.99</TD> <TD width="57">100</TD> <TD width="35">0.4</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">10.00-14.99</TD> <TD width="57">80</TD> <TD width="35">0.9</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">15.00-19.99</TD> <TD width="57">70</TD> <TD width="35">1.5</TD> <TD width="49">8.35</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">20.00-24.99</TD> <TD width="57">55</TD> <TD width="35">2</TD> <TD width="49">13.64</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">25.00-29.99</TD> <TD width="57">40</TD> <TD width="35">2.2</TD> <TD width="49">17.88</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">30.00-34.99</TD> <TD width="57">30</TD> <TD width="35">2.4</TD> <TD width="49">21.43</TD> <TD width="46">14.36</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">35.00-39.99</TD> <TD width="57">20</TD> <TD width="35">2.1</TD> <TD width="49">19.74</TD> <TD width="46">15.49</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">40.00-44.99</TD> <TD width="57">15</TD> <TD width="35">2.1</TD> <TD width="49">21.21</TD> <TD width="46">17.44</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">45.00-49.99</TD> <TD width="57">10</TD> <TD width="35">1.8</TD> <TD width="49">18.53</TD> <TD width="46">15.04</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">50.00-54.99</TD> <TD width="57">8</TD> <TD width="35">1.7</TD> <TD width="49">18.06</TD> <TD width="46">14.27</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">55.00-59.99</TD> <TD width="57">4</TD> <TD width="35">1</TD> <TD width="49">11.04</TD> <TD width="46">8.39</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">60.00-64.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">T</TD> <TD width="37">0</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">1.00-4.99</TD> <TD width="57">1063</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">5.00-9.99</TD> <TD width="57">116</TD> <TD width="35">0.4</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">10.00-14.99</TD> <TD width="57">46</TD> <TD width="35">0.5</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">15.00-19.99</TD> <TD width="57">41</TD> <TD width="35">1</TD> <TD width="49">5.66</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">20.00-24.99</TD> <TD width="57">36</TD> <TD width="35">1.4</TD> <TD width="49">9.83</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">25.00-29.99</TD> <TD width="57">23</TD> <TD width="35">1.4</TD> <TD width="49">10.92</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">30.00-34.99</TD> <TD width="57">20</TD> <TD width="35">1.6</TD> <TD width="49">14.67</TD> <TD width="46">10</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">35.00-39.99</TD> <TD width="57">13</TD> <TD width="35">1.4</TD> <TD width="49">13.6</TD> <TD width="46">10.8</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">40.00-44.99</TD> <TD width="57">7</TD> <TD width="35">1</TD> <TD width="49">10.46</TD> <TD width="46">8.6</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">45.00-49.99</TD> <TD width="57">6</TD> <TD width="35">1.1</TD> <TD width="49">10.99</TD> <TD width="46">8.93</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">50.00-54.99</TD> <TD width="57">7</TD> <TD width="35">1.5</TD> <TD width="49">15.47</TD> <TD width="46">12.27</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">55.00-59.99</TD> <TD width="57">3</TD> <TD width="35">0.8</TD> <TD width="49">8.32</TD> <TD width="46">6.32</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">60.00-64.99</TD> <TD width="57">1</TD> <TD width="35">0.3</TD> <TD width="49">3.19</TD> <TD width="46">2.35</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">A</TD> <TD width="37">5</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">5</TD> <TD width="52">1.00-4.99</TD> <TD width="57">392</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">5</TD> <TD width="52">5.00-9.99</TD> <TD width="57">48</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="36">B</TD> <TD width="37">5</TD> <TD width="52">10.00-14.99</TD> <TD width="57">15</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD width="36">etc.</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> <P><BR /><BR /><BR /></P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Fri, 25 May 2018 14:53:06 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465093#M285208 Reeza 2018-05-25T14:53:06Z Re: How to create a variable column when repeated groups are unlabled? https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465100#M285209 <P>Hi, thanks</P> <P>&nbsp;</P> <P>If you look at the sas data file B I attached before, you'll see it lacks the "Species" column.&nbsp; I need this column to work with the data.&nbsp; Each set of 16 lines belongs to one of three species, or is the total.&nbsp; The pattern repeats lines 1-16 are species A.&nbsp; Lines 17-32 are species B.&nbsp; Lines 33-48 are species C, lines 49 through 64 are the totals.&nbsp; Then the pattern repeats lines 65-80 are species A again, lines 81-96 species B... etc until line 40+K.&nbsp; I have a few dozen files that I need to create this column for.</P> <P>&nbsp;</P> <P>The table in my message text is an example of what I want it to look like compared to the attached dataset...<BR /><BR />I have an inelegant solution at this point, but I'd rather do it the right way.<BR /><BR />If that file is hard to open, it looks like this<BR /><BR /></P> <TABLE width="276"> <TBODY> <TR> <TD width="37">time</TD> <TD width="52">group</TD> <TD width="57">numtrees</TD> <TD width="35">BA</TD> <TD width="49">STMV</TD> <TD width="46">SVTS</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">1.00-4.99</TD> <TD width="57">112</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">5.00-9.99</TD> <TD width="57">56</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">10.00-14.99</TD> <TD width="57">49</TD> <TD width="35">0.6</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">15.00-19.99</TD> <TD width="57">41</TD> <TD width="35">0.9</TD> <TD width="49">4.74</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">20.00-24.99</TD> <TD width="57">30</TD> <TD width="35">1.1</TD> <TD width="49">7.49</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">25.00-29.99</TD> <TD width="57">27</TD> <TD width="35">1.5</TD> <TD width="49">12.26</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">30.00-34.99</TD> <TD width="57">18</TD> <TD width="35">1.4</TD> <TD width="49">12.72</TD> <TD width="46">8.46</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">35.00-39.99</TD> <TD width="57">8</TD> <TD width="35">0.9</TD> <TD width="49">8.06</TD> <TD width="46">6.35</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">40.00-44.99</TD> <TD width="57">10</TD> <TD width="35">1.4</TD> <TD width="49">14.42</TD> <TD width="46">11.87</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">45.00-49.99</TD> <TD width="57">7</TD> <TD width="35">1.3</TD> <TD width="49">13.28</TD> <TD width="46">10.76</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">50.00-54.99</TD> <TD width="57">5</TD> <TD width="35">1.1</TD> <TD width="49">11.62</TD> <TD width="46">9.13</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">55.00-59.99</TD> <TD width="57">1</TD> <TD width="35">0.3</TD> <TD width="49">3.04</TD> <TD width="46">2.26</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">60.00-64.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">1.00-4.99</TD> <TD width="57">46</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">5.00-9.99</TD> <TD width="57">21</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">10.00-14.99</TD> <TD width="57">17</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">15.00-19.99</TD> <TD width="57">17</TD> <TD width="35">0.4</TD> <TD width="49">2.09</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">20.00-24.99</TD> <TD width="57">8</TD> <TD width="35">0.3</TD> <TD width="49">2</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">25.00-29.99</TD> <TD width="57">7</TD> <TD width="35">0.4</TD> <TD width="49">2.88</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">30.00-34.99</TD> <TD width="57">6</TD> <TD width="35">0.5</TD> <TD width="49">4.46</TD> <TD width="46">3.08</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">35.00-39.99</TD> <TD width="57">5</TD> <TD width="35">0.5</TD> <TD width="49">5.05</TD> <TD width="46">3.99</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">40.00-44.99</TD> <TD width="57">2</TD> <TD width="35">0.3</TD> <TD width="49">2.78</TD> <TD width="46">2.28</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">45.00-49.99</TD> <TD width="57">1</TD> <TD width="35">0.2</TD> <TD width="49">1.9</TD> <TD width="46">1.54</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">50.00-54.99</TD> <TD width="57">1</TD> <TD width="35">0.2</TD> <TD width="49">2.18</TD> <TD width="46">1.73</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">55.00-59.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">60.00-64.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">1.00-4.99</TD> <TD width="57">42</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">5.00-9.99</TD> <TD width="57">23</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">10.00-14.99</TD> <TD width="57">14</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">15.00-19.99</TD> <TD width="57">12</TD> <TD width="35">0.3</TD> <TD width="49">1.51</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">20.00-24.99</TD> <TD width="57">17</TD> <TD width="35">0.6</TD> <TD width="49">4.16</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">25.00-29.99</TD> <TD width="57">6</TD> <TD width="35">0.3</TD> <TD width="49">2.73</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">30.00-34.99</TD> <TD width="57">6</TD> <TD width="35">0.5</TD> <TD width="49">4.24</TD> <TD width="46">2.82</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">35.00-39.99</TD> <TD width="57">7</TD> <TD width="35">0.7</TD> <TD width="49">6.63</TD> <TD width="46">5.15</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">40.00-44.99</TD> <TD width="57">3</TD> <TD width="35">0.4</TD> <TD width="49">4.01</TD> <TD width="46">3.29</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">45.00-49.99</TD> <TD width="57">2</TD> <TD width="35">0.3</TD> <TD width="49">3.35</TD> <TD width="46">2.74</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">50.00-54.99</TD> <TD width="57">2</TD> <TD width="35">0.4</TD> <TD width="49">4.27</TD> <TD width="46">3.4</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">55.00-59.99</TD> <TD width="57">3</TD> <TD width="35">0.7</TD> <TD width="49">8</TD> <TD width="46">6.13</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">60.00-64.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">1.00-4.99</TD> <TD width="57">200</TD> <TD width="35">0.3</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">5.00-9.99</TD> <TD width="57">100</TD> <TD width="35">0.4</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">10.00-14.99</TD> <TD width="57">80</TD> <TD width="35">0.9</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">15.00-19.99</TD> <TD width="57">70</TD> <TD width="35">1.5</TD> <TD width="49">8.35</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">20.00-24.99</TD> <TD width="57">55</TD> <TD width="35">2</TD> <TD width="49">13.64</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">25.00-29.99</TD> <TD width="57">40</TD> <TD width="35">2.2</TD> <TD width="49">17.88</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">30.00-34.99</TD> <TD width="57">30</TD> <TD width="35">2.4</TD> <TD width="49">21.43</TD> <TD width="46">14.36</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">35.00-39.99</TD> <TD width="57">20</TD> <TD width="35">2.1</TD> <TD width="49">19.74</TD> <TD width="46">15.49</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">40.00-44.99</TD> <TD width="57">15</TD> <TD width="35">2.1</TD> <TD width="49">21.21</TD> <TD width="46">17.44</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">45.00-49.99</TD> <TD width="57">10</TD> <TD width="35">1.8</TD> <TD width="49">18.53</TD> <TD width="46">15.04</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">50.00-54.99</TD> <TD width="57">8</TD> <TD width="35">1.7</TD> <TD width="49">18.06</TD> <TD width="46">14.27</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">55.00-59.99</TD> <TD width="57">4</TD> <TD width="35">1</TD> <TD width="49">11.04</TD> <TD width="46">8.39</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">60.00-64.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">0</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">1.00-4.99</TD> <TD width="57">1063</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">5.00-9.99</TD> <TD width="57">116</TD> <TD width="35">0.4</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">10.00-14.99</TD> <TD width="57">46</TD> <TD width="35">0.5</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">15.00-19.99</TD> <TD width="57">41</TD> <TD width="35">1</TD> <TD width="49">5.66</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">20.00-24.99</TD> <TD width="57">36</TD> <TD width="35">1.4</TD> <TD width="49">9.83</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">25.00-29.99</TD> <TD width="57">23</TD> <TD width="35">1.4</TD> <TD width="49">10.92</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">30.00-34.99</TD> <TD width="57">20</TD> <TD width="35">1.6</TD> <TD width="49">14.67</TD> <TD width="46">10</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">35.00-39.99</TD> <TD width="57">13</TD> <TD width="35">1.4</TD> <TD width="49">13.6</TD> <TD width="46">10.8</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">40.00-44.99</TD> <TD width="57">7</TD> <TD width="35">1</TD> <TD width="49">10.46</TD> <TD width="46">8.6</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">45.00-49.99</TD> <TD width="57">6</TD> <TD width="35">1.1</TD> <TD width="49">10.99</TD> <TD width="46">8.93</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">50.00-54.99</TD> <TD width="57">7</TD> <TD width="35">1.5</TD> <TD width="49">15.47</TD> <TD width="46">12.27</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">55.00-59.99</TD> <TD width="57">3</TD> <TD width="35">0.8</TD> <TD width="49">8.32</TD> <TD width="46">6.32</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">60.00-64.99</TD> <TD width="57">1</TD> <TD width="35">0.3</TD> <TD width="49">3.19</TD> <TD width="46">2.35</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">65.00-69.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">70.00-74.99</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">75.00+</TD> <TD width="57">0</TD> <TD width="35">0</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">1.00-4.99</TD> <TD width="57">392</TD> <TD width="35">0.1</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">5.00-9.99</TD> <TD width="57">48</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD width="37">5</TD> <TD width="52">10.00-14.99</TD> <TD width="57">15</TD> <TD width="35">0.2</TD> <TD width="49">0</TD> <TD width="46">0</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>etc</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> Fri, 25 May 2018 15:04:55 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465100#M285209 iiibbb 2018-05-25T15:04:55Z Re: How to create a variable column when repeated groups are unlabled? https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465107#M285210 <P>Well, if the only rule you have is every 16, use the MOD() function to identify each group, then assign the groups to the species.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data want; set sashelp.cars; if mod(_n_, 16)=1 then count+1; keep model make mpg_city count; run;</CODE></PRE> <P>&nbsp;</P> Fri, 25 May 2018 15:15:53 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465107#M285210 Reeza 2018-05-25T15:15:53Z Re: How to create a variable column when repeated groups are unlabled? https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465110#M285211 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/6309">@iiibbb</a>&nbsp;Are you after something as simple as this?&nbsp;</P><PRE><CODE class=" language-sas">data want; do species='A','B','C','T'; do _n_=1 to 16; set tmp1.b; output; end; end; run;</CODE></PRE> Fri, 25 May 2018 15:17:53 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465110#M285211 novinosrin 2018-05-25T15:17:53Z Re: How to create a variable column when repeated groups are unlabled? https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465113#M285212 <P>Okay.<BR /><BR />This is partway there.<BR /><BR />The problem is I have a few dozen files of differing lengths 40,000 or more lines.&nbsp; So labeling each group is still 2500 assignments I have to make to my species.<BR /><BR />So it seems that am still roughly in the same place as labeling each diameter group manually because groups 1,5,9,13,17 etc are species A, 2,6,10,14,18 etc are species B, 3,7,11,15,19 etc are species C, and 4,8,12,16,20 etc. are total.<BR /><BR />So it solves the grouping problem, but not the naming problem.</P> Fri, 25 May 2018 15:24:04 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465113#M285212 iiibbb 2018-05-25T15:24:04Z Re: How to create a variable column when repeated groups are unlabled? https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465114#M285213 <P>Use a double mod then, if you know you only have 4 groups. Do the same logic to group the others into 1 to 4.&nbsp;</P> <P>And then you're only writing about 4 If/Then or Format statements.</P> Fri, 25 May 2018 15:28:02 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465114#M285213 Reeza 2018-05-25T15:28:02Z Re: How to create a variable column when repeated groups are unlabled? https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465117#M285214 <P>Wonderful.</P> <P>&nbsp;</P> <P>I am not skilled with do statements... this did it.<BR /><BR />Thanks</P> Fri, 25 May 2018 15:34:05 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465117#M285214 iiibbb 2018-05-25T15:34:05Z Re: How to create a variable column when repeated groups are unlabled? https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465119#M285215 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/6309">@iiibbb</a>&nbsp;You are very welcome. That's what the community is for. All of us work as a team for a common good i.e knowledge sharing</P> Fri, 25 May 2018 15:35:48 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465119#M285215 novinosrin 2018-05-25T15:35:48Z Re: How to create a variable column when repeated groups are unlabled? https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465124#M285216 <P>What's funny is that I successfully filtered some of the formatting peculiarities imputing the data only to be stymied by this.<BR /><BR />Is there a way I could make this more generic... like if there were missing values?&nbsp; Could I write the code where the count might vary from group to group?<BR /><BR />Not my current problem, but I get data with missing observations all the time.</P> <P>&nbsp;</P> <P>Thanks</P> Fri, 25 May 2018 15:42:38 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465124#M285216 iiibbb 2018-05-25T15:42:38Z Re: How to create a variable column when repeated groups are unlabled? https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465127#M285217 <P>I'm afraid if the count varies you would have to let us know where to exit the loop. For example, if the count is 7, and species is B, the code would need to tweaked to exit with some kind of&nbsp; OR condition.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>EDIT: If you are working in a production environment, having to filter after making it a two step process is still safer than meddling to get it in one go. Of course on a forum, it's fun for us to solve regardless</P> Fri, 25 May 2018 15:55:07 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465127#M285217 novinosrin 2018-05-25T15:55:07Z Re: How to create a variable column when repeated groups are unlabled? https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465134#M285218 <P>Yeah... mostly just fun to think about.&nbsp; In this forum it's always better to have actual data to go with the question.<BR /><BR />I am not a heavy user of SAS and what problems I get are usually one-offs so I don't make as good of use of things like do loops because I can often do something in EXCEL first by hand in a few minutes rather than have to code and debug code for unexpected results.&nbsp; This problem I was given though, manual was going to be very tedious and I couldn't insist the people giving it to us have it perfect beforehand because they're doing us the favor.<BR /><BR />Thanks again!</P> Fri, 25 May 2018 16:07:58 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465134#M285218 iiibbb 2018-05-25T16:07:58Z Re: How to create a variable column when repeated groups are unlabled? https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465158#M285219 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/6309">@iiibbb</a>&nbsp;wrote:<BR /> <P>What's funny is that I successfully filtered some of the formatting peculiarities imputing the data only to be stymied by this.<BR /><BR />Is there a way I could make this more generic... like if there were missing values?&nbsp; Could I write the code where the count might vary from group to group?<BR /><BR />Not my current problem, but I get data with missing observations all the time.</P> <P>&nbsp;</P> <P>Thanks</P> <HR /></BLOCKQUOTE> <P>I think this question would warrant a new thread. Reference this one by copy and paste the URL. Provide a different start data and the desired result, best would be as data steps. Only paste as many variables and records needed to demonstrate the actual issue.</P> Fri, 25 May 2018 17:12:30 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-variable-column-when-repeated-groups-are/m-p/465158#M285219 ballardw 2018-05-25T17:12:30Z