topic Re: Diagonal in colum. in SAS Programming https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/401320#M97361 <P>Hello,</P> <P>&nbsp;</P> <P>Edit : I did not pat attention to the row order =&gt; code modified a bit</P> <P>Please provide data in the form of a datastep so we can test the solutions we propose before posting them.</P> <P>&nbsp;</P> <P>Try this</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data want; set have; array tt(*) tt75-tt80; array a(6) _TEMPORARY_; if anno&lt;2018 then do; a(2018-anno)=tt(anno-2011); end; else do; new=a(anno-2016); end; run;</CODE></PRE> <P>&nbsp;</P> Thu, 05 Oct 2017 14:12:07 GMT gamotte 2017-10-05T14:12:07Z Diagonal in colum. https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/401310#M97358 <P>I have this dataset</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Cattura.JPG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/15635iB666F47E116F2F20/image-size/large?v=v2&amp;px=999" role="button" title="Cattura.JPG" alt="Cattura.JPG" /></span></P><P>&nbsp;</P><P>and I want this dataset with the&nbsp; var new</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Cattura1.JPG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/15634iF4B20A13DE5C4954/image-size/large?v=v2&amp;px=999" role="button" title="Cattura1.JPG" alt="Cattura1.JPG" /></span></P><P>&nbsp;</P><P>Thank you!</P> Thu, 05 Oct 2017 12:50:30 GMT https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/401310#M97358 Elena 2017-10-05T12:50:30Z Re: Diagonal in colum. https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/401320#M97361 <P>Hello,</P> <P>&nbsp;</P> <P>Edit : I did not pat attention to the row order =&gt; code modified a bit</P> <P>Please provide data in the form of a datastep so we can test the solutions we propose before posting them.</P> <P>&nbsp;</P> <P>Try this</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data want; set have; array tt(*) tt75-tt80; array a(6) _TEMPORARY_; if anno&lt;2018 then do; a(2018-anno)=tt(anno-2011); end; else do; new=a(anno-2016); end; run;</CODE></PRE> <P>&nbsp;</P> Thu, 05 Oct 2017 14:12:07 GMT https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/401320#M97361 gamotte 2017-10-05T14:12:07Z Re: Diagonal in colum. https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/401321#M97362 <P>Thats a bit of a mess of dataset.&nbsp; You can do it, but it would be hardcoded in a bit.&nbsp; E.g.</P> <PRE>data want; set have; if anno=2018 then new=lag2(tt79); if anno=2019 then new=lag3(tt78); ... run; </PRE> <P>I don't see a logical way of doing.</P> Thu, 05 Oct 2017 13:13:05 GMT https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/401321#M97362 RW9 2017-10-05T13:13:05Z Re: Diagonal in colum. https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/401330#M97363 <P>Is there any particular reason why you chose the numbers you selected?</P> <P>&nbsp;</P> <P>To create new variables, you must use&nbsp;one of the methods mentioned on this page: <A href="https://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a000695113.htm&nbsp;" target="_blank">https://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a000695113.htm&nbsp;</A></P> <P>&nbsp;</P> <P>To help you out specifically in your case, I am going to need to know what the source of your data is (excel, datalines, sas dataset, .csv, etc.) to give you more information on how you can add the new variable and subset the observations.</P> <P>&nbsp;</P> <P>You could use a when or an if statement to subset the variables to contain only those specific variables that only contain the observations you want. However, without knowing the reason why you want those specific numbers you chose, I am unable to help you out further.&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 05 Oct 2017 13:37:13 GMT https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/401330#M97363 danielduval0 2017-10-05T13:37:13Z Re: Diagonal in colum. https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/401342#M97368 <P>The var new is a component of a formula to estimate the people over 80.&nbsp;I need, for every codice_comune, in anno 2018 the TT79 value-anno 2016, in anno 2019 the tt78 value-anno 2015, in anno 2020 the tt77 value-anno 2014, in anno 2021 the tt76 value-anno 2014 and in anno 2022 the tt75 value-anno 2013.&nbsp;This is my dataset&nbsp;</P><P><STRONG>data</STRONG> have;</P><P>&nbsp;</P><P>&nbsp;</P><P>input codice_comune anno tt75 tt76 tt77 tt78 tt79 tt80 ;</P><P>&nbsp;</P><P>datalines;</P><P>&nbsp;</P><P>33001 2012&nbsp; 369&nbsp;&nbsp; 333&nbsp;&nbsp; 303&nbsp;&nbsp; 279&nbsp;&nbsp; 255&nbsp;&nbsp; 236</P><P>33001 2013&nbsp; 364&nbsp;&nbsp; 341&nbsp;&nbsp; 307&nbsp;&nbsp; 278&nbsp;&nbsp; 254&nbsp;&nbsp; 232</P><P>33001 2014&nbsp; 367&nbsp;&nbsp; 343&nbsp;&nbsp; 320&nbsp;&nbsp; 288&nbsp;&nbsp; 258&nbsp;&nbsp; 233</P><P>33001 2015&nbsp; 364&nbsp;&nbsp; 341&nbsp;&nbsp; 316&nbsp;&nbsp; 294&nbsp;&nbsp; 263&nbsp;&nbsp; 233</P><P>33001 2016&nbsp; 365&nbsp;&nbsp; 344&nbsp;&nbsp; 320&nbsp;&nbsp; 297&nbsp;&nbsp; 274&nbsp;&nbsp; 243</P><P>33001 2017&nbsp; 362&nbsp;&nbsp; 335&nbsp;&nbsp; 315&nbsp;&nbsp; 292&nbsp;&nbsp; 270&nbsp;&nbsp; 247</P><P>33001 2018&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33001 2019&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33001 2020&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33001 2021&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33001 2022&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33002 2012&nbsp; 563&nbsp;&nbsp; 519&nbsp;&nbsp; 462&nbsp;&nbsp; 424&nbsp;&nbsp; 378&nbsp;&nbsp; 336</P><P>33002 2013&nbsp; 564&nbsp;&nbsp; 523&nbsp;&nbsp; 480&nbsp;&nbsp; 427&nbsp;&nbsp; 393&nbsp;&nbsp; 348</P><P>33002 2014&nbsp; 563&nbsp;&nbsp; 524&nbsp;&nbsp; 483&nbsp;&nbsp; 443&nbsp;&nbsp; 391&nbsp;&nbsp; 358</P><P>33002 2015&nbsp; 560&nbsp;&nbsp; 514&nbsp;&nbsp; 476&nbsp;&nbsp; 436&nbsp;&nbsp; 396&nbsp;&nbsp; 346</P><P>33002 2016&nbsp; 557&nbsp;&nbsp; 517&nbsp;&nbsp; 472&nbsp;&nbsp; 436&nbsp;&nbsp; 399&nbsp;&nbsp; 360</P><P>33002 2017&nbsp; 551&nbsp;&nbsp; 512&nbsp;&nbsp; 473&nbsp;&nbsp; 427&nbsp;&nbsp; 392&nbsp;&nbsp; 355</P><P>33002 2018&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33002 2019&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33002 2020&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33002 2021&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33002 2022&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33003 2012&nbsp; 124&nbsp;&nbsp; 114&nbsp;&nbsp; 101&nbsp;&nbsp; 91&nbsp;&nbsp;&nbsp; 81&nbsp;&nbsp;&nbsp; 72</P><P>33003 2013&nbsp; 130&nbsp;&nbsp; 121&nbsp;&nbsp; 111&nbsp;&nbsp; 97&nbsp;&nbsp;&nbsp; 88&nbsp;&nbsp;&nbsp; 78</P><P>33003 2014&nbsp; 127&nbsp;&nbsp; 117&nbsp;&nbsp; 109&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp; 85&nbsp;&nbsp;&nbsp; 76</P><P>33003 2015&nbsp; 127&nbsp;&nbsp; 118&nbsp;&nbsp; 109&nbsp;&nbsp; 101&nbsp;&nbsp; 91&nbsp;&nbsp;&nbsp; 78</P><P>33003 2016&nbsp; 135&nbsp;&nbsp; 115&nbsp;&nbsp; 108&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp; 91&nbsp;&nbsp;&nbsp; 81</P><P>33003 2017&nbsp; 132&nbsp;&nbsp; 126&nbsp;&nbsp; 108&nbsp;&nbsp; 101&nbsp;&nbsp; 92&nbsp;&nbsp;&nbsp; 84</P><P>33003 2018&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33003 2019&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33003 2020&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33003 2021&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33003 2022&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33004 2012&nbsp; 516&nbsp;&nbsp; 469&nbsp;&nbsp; 434&nbsp;&nbsp; 406&nbsp;&nbsp; 373&nbsp;&nbsp; 338</P><P>33004 2013&nbsp; 501&nbsp;&nbsp; 468&nbsp;&nbsp; 420&nbsp;&nbsp; 388&nbsp;&nbsp; 360&nbsp;&nbsp; 328</P><P>33004 2014&nbsp; 510&nbsp;&nbsp; 470&nbsp;&nbsp; 439&nbsp;&nbsp; 391&nbsp;&nbsp; 360&nbsp;&nbsp; 332</P><P>33004 2015&nbsp; 504&nbsp;&nbsp; 463&nbsp;&nbsp; 423&nbsp;&nbsp; 394&nbsp;&nbsp; 344&nbsp;&nbsp; 315</P><P>33004 2016&nbsp; 504&nbsp;&nbsp; 456&nbsp;&nbsp; 416&nbsp;&nbsp; 378&nbsp;&nbsp; 350&nbsp;&nbsp; 304</P><P>33004 2017&nbsp; 508&nbsp;&nbsp; 465&nbsp;&nbsp; 418&nbsp;&nbsp; 377&nbsp;&nbsp; 341&nbsp;&nbsp; 314</P><P>33004 2018&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33004 2019&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33004 2020&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33004 2021&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33004 2022&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33005 2012&nbsp; 768&nbsp;&nbsp; 718&nbsp;&nbsp; 672&nbsp;&nbsp; 602&nbsp;&nbsp; 546&nbsp;&nbsp; 485</P><P>33005 2013&nbsp; 750&nbsp;&nbsp; 701&nbsp;&nbsp; 651&nbsp;&nbsp; 605&nbsp;&nbsp; 537&nbsp;&nbsp; 485</P><P>33005 2014&nbsp; 763&nbsp;&nbsp; 706&nbsp;&nbsp; 659&nbsp;&nbsp; 611&nbsp;&nbsp; 566&nbsp;&nbsp; 497</P><P>33005 2015&nbsp; 752&nbsp;&nbsp; 702&nbsp;&nbsp; 648&nbsp;&nbsp; 601&nbsp;&nbsp; 553&nbsp;&nbsp; 510</P><P>33005 2016&nbsp; 755&nbsp;&nbsp; 694&nbsp;&nbsp; 645&nbsp;&nbsp; 591&nbsp;&nbsp; 544&nbsp;&nbsp; 497</P><P>33005 2017&nbsp; 770&nbsp;&nbsp; 713&nbsp;&nbsp; 656&nbsp;&nbsp; 609&nbsp;&nbsp; 555&nbsp;&nbsp; 507</P><P>33005 2018&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33005 2019&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33005 2020&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33005 2021&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33005 2022&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33006 2012&nbsp; 914&nbsp;&nbsp; 853&nbsp;&nbsp; 785&nbsp;&nbsp; 714&nbsp;&nbsp; 623&nbsp;&nbsp; 557</P><P>33006 2013&nbsp; 933&nbsp;&nbsp; 853&nbsp;&nbsp; 795&nbsp;&nbsp; 732&nbsp;&nbsp; 665&nbsp;&nbsp; 579</P><P>33006 2014&nbsp; 976&nbsp;&nbsp; 888&nbsp;&nbsp; 808&nbsp;&nbsp; 748&nbsp;&nbsp; 687&nbsp;&nbsp; 622</P><P>33006 2015&nbsp; 997&nbsp;&nbsp; 922&nbsp;&nbsp; 835&nbsp;&nbsp; 756&nbsp;&nbsp; 696&nbsp;&nbsp; 636</P><P>33006 2016&nbsp; 991&nbsp;&nbsp; 919&nbsp;&nbsp; 847&nbsp;&nbsp; 762&nbsp;&nbsp; 687&nbsp;&nbsp; 632</P><P>33006 2017&nbsp; 991&nbsp;&nbsp; 916&nbsp;&nbsp; 844&nbsp;&nbsp; 773&nbsp;&nbsp; 692&nbsp;&nbsp; 621</P><P>33006 2018&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33006 2019&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33006 2020&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33006 2021&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33006 2022&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33007 2012&nbsp; 602&nbsp;&nbsp; 549&nbsp;&nbsp; 510&nbsp;&nbsp; 469&nbsp;&nbsp; 426&nbsp;&nbsp; 376</P><P>33007 2013&nbsp; 610&nbsp;&nbsp; 559&nbsp;&nbsp; 507&nbsp;&nbsp; 469&nbsp;&nbsp; 431&nbsp;&nbsp; 390</P><P>33007 2014&nbsp; 613&nbsp;&nbsp; 558&nbsp;&nbsp; 507&nbsp;&nbsp; 459&nbsp;&nbsp; 422&nbsp;&nbsp; 386</P><P>33007 2015&nbsp; 629&nbsp;&nbsp; 571&nbsp;&nbsp; 517&nbsp;&nbsp; 470&nbsp;&nbsp; 421&nbsp;&nbsp; 384</P><P>33007 2016&nbsp; 643&nbsp;&nbsp; 577&nbsp;&nbsp; 522&nbsp;&nbsp; 473&nbsp;&nbsp; 428&nbsp;&nbsp; 381</P><P>33007 2017&nbsp; 663&nbsp;&nbsp; 599&nbsp;&nbsp; 533&nbsp;&nbsp; 480&nbsp;&nbsp; 432&nbsp;&nbsp; 386</P><P>33007 2018&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33007 2019&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33007 2020&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33007 2021&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33007 2022&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33008 2012&nbsp; 261&nbsp;&nbsp; 235&nbsp;&nbsp; 208&nbsp;&nbsp; 185&nbsp;&nbsp; 160&nbsp;&nbsp; 141</P><P>33008 2013&nbsp; 264&nbsp;&nbsp; 235&nbsp;&nbsp; 212&nbsp;&nbsp; 186&nbsp;&nbsp; 163&nbsp;&nbsp; 138</P><P>33008 2014&nbsp; 270&nbsp;&nbsp; 243&nbsp;&nbsp; 214&nbsp;&nbsp; 192&nbsp;&nbsp; 169&nbsp;&nbsp; 148</P><P>33008 2015&nbsp; 283&nbsp;&nbsp; 256&nbsp;&nbsp; 229&nbsp;&nbsp; 203&nbsp;&nbsp; 182&nbsp;&nbsp; 160</P><P>33008 2016&nbsp; 290&nbsp;&nbsp; 265&nbsp;&nbsp; 240&nbsp;&nbsp; 214&nbsp;&nbsp; 189&nbsp;&nbsp; 169</P><P>33008 2017&nbsp; 284&nbsp;&nbsp; 266&nbsp;&nbsp; 240&nbsp;&nbsp; 215&nbsp;&nbsp; 190&nbsp;&nbsp; 167</P><P>33008 2018&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33008 2019&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33008 2020&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33008 2021&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>33008 2022&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>;</P><P>&nbsp;</P> Thu, 05 Oct 2017 14:08:15 GMT https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/401342#M97368 Elena 2017-10-05T14:08:15Z Re: Diagonal in colum. https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/401347#M97371 I have edited my solution. It seems to give the wanted result. Thu, 05 Oct 2017 14:14:00 GMT https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/401347#M97371 gamotte 2017-10-05T14:14:00Z Re: Diagonal in colum. https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/402291#M97667 <P>Yes, it's perfect! Thank you!</P> Mon, 09 Oct 2017 07:47:10 GMT https://communities.sas.com/t5/SAS-Programming/Diagonal-in-colum/m-p/402291#M97667 Elena 2017-10-09T07:47:10Z