Hello everyone, I am beginner in SAS I have this table SNAPSHOT COUNT SEGMENT GROUP def GRADE 201401 4472 PRK_LNPL 0 0 1 201401 8691 PRK_LNPL 0 0 2 201401 8289 PRK_LNPL 0 0 3 201401 2209 PRK_LNPL 0 0 4 201401 1450 PRK_LNPL 0 0 5 201401 1333 PRK_LNPL 0 0 6 201401 364 PRK_LNPL 0 0 7 201401 133 PRK_LNPL 0 0 8 201401 4 PRK_LNPL 0 1 1 201401 22 PRK_LNPL 0 1 2 201401 81 PRK_LNPL 0 1 3 201401 61 PRK_LNPL 0 1 4 201401 67 PRK_LNPL 0 1 5 201401 161 PRK_LNPL 0 1 6 201401 122 PRK_LNPL 0 1 7 201401 130 PRK_LNPL 0 1 8 201401 11642 PRK_LNPL 1 0 1 201401 19361 PRK_LNPL 1 0 2 201401 15284 PRK_LNPL 1 0 3 201401 3463 PRK_LNPL 1 0 4 201401 2056 PRK_LNPL 1 0 5 201401 1895 PRK_LNPL 1 0 6 201401 490 PRK_LNPL 1 0 7 201401 153 PRK_LNPL 1 0 8 201401 9 PRK_LNPL 1 1 1 201401 59 PRK_LNPL 1 1 2 201401 141 PRK_LNPL 1 1 3 201401 98 PRK_LNPL 1 1 4 201401 114 PRK_LNPL 1 1 5 201401 218 PRK_LNPL 1 1 6 201401 189 PRK_LNPL 1 1 7 201401 180 PRK_LNPL 1 1 8 I want this table SNAPSHOT COUNT SEGMENT GROUP def GRADE SUM DR 201401 4472 PRK_LNPL 0 0 1 4476   201401 8691 PRK_LNPL 0 0 2 8713   201401 8289 PRK_LNPL 0 0 3 8370   201401 2209 PRK_LNPL 0 0 4 2270   201401 1450 PRK_LNPL 0 0 5 1517   201401 1333 PRK_LNPL 0 0 6 1494   201401 364 PRK_LNPL 0 0 7 486   201401 133 PRK_LNPL 0 0 8 263   201401 4 PRK_LNPL 0 1 1   0,089% 201401 22 PRK_LNPL 0 1 2   0,252% 201401 81 PRK_LNPL 0 1 3   0,968% 201401 61 PRK_LNPL 0 1 4   2,687% 201401 67 PRK_LNPL 0 1 5   4,417% 201401 161 PRK_LNPL 0 1 6   10,776% 201401 122 PRK_LNPL 0 1 7   25,103% 201401 130 PRK_LNPL 0 1 8   49,430% 201401 11642 PRK_LNPL 1 0 1 11651   201401 19361 PRK_LNPL 1 0 2 19420   201401 15284 PRK_LNPL 1 0 3 15425   201401 3463 PRK_LNPL 1 0 4 3561   201401 2056 PRK_LNPL 1 0 5 2170   201401 1895 PRK_LNPL 1 0 6 2113   201401 490 PRK_LNPL 1 0 7 679   201401 153 PRK_LNPL 1 0 8 333   201401 9 PRK_LNPL 1 1 1   0,077% 201401 59 PRK_LNPL 1 1 2   0,304% 201401 141 PRK_LNPL 1 1 3   0,914% 201401 98 PRK_LNPL 1 1 4   2,752% 201401 114 PRK_LNPL 1 1 5   5,253% 201401 218 PRK_LNPL 1 1 6   10,317% 201401 189 PRK_LNPL 1 1 7   27,835% 201401 180 PRK_LNPL 1 1 8   54,054% In column SUM i need to sum values in column COUNT for each grade and group seperatedly example 4476=4472+4. In column DR i need to divide value from column COUNT and SUM for each grade and group seperatedly and only there where is in column DEF value=1. example 0,089%=4/4476. Is here anybody who can solve my problem? ... View more

Hello everyone, I am facing to this problem. I have this and I wanna converted to this format Has anybody know how to solve this problem? ... View more

Hello everyone, I have this table without Def_flag colum. I want create a new column Def_flag with value "1" or "0" when the value of column "RAT" is equal to R then 12 months before in colum Def_flag goes value "1" else "0". And for each ID must by separated. Result you can see below.   ID DATE RAT Def_flag 9 201705 N 0 9 201704 N 0 9 201703 N 0 9 201702 N 0 9 201701 N 0 9 201612 N 0 9 201611 N 0 9 201610 N 0 9 201609 N 0 9 201608 N 0 9 201607 N 0 9 201606 N 0 9 201605 N 0 9 201604 R 1 9 201603 N 1 9 201602 N 1 9 201601 N 1 9 201512 N 1 9 201511 N 1 9 201510 N 1 9 201509 N 1 9 201508 N 1 9 201507 N 1 9 201506 N 1 9 201505 N 1 9 201504 N 0 9 201503 N 0 9 201502 N 0 9 201501 N 0 9 201412 N 0 11 201705 N 0 11 201704 N 0 11 201703 N 0 11 201702 N 0 11 201701 N 0 11 201612 N 0 11 201611 N 0 11 201610 N 0 11 201609 N 0 11 201608 N 0 11 201607 N 0 11 201606 N 0 11 201605 N 0 11 201604 N 0 11 201603 R 1 11 201602 N 1 11 201601 N 1 11 201512 N 1 11 201511 N 1 11 201510 N 1 11 201509 N 1 11 201508 N 1 11 201507 N 1 11 201506 N 1 11 201505 N 1 11 201504 N 1 11 201503 N 0 11 201502 N 0 11 201501 N 0 11 201412 N 0   Can someone give me a help to create a data step? Thanks!!!! ... View more