this table is my DB, SAS should count the total in each EEOG from this DB, and then generate column B, then it should look at where the condition is DIS, and generate the column C. Rest of columns are the calculations based on column B and C. ... View more

Thanks,   This is my original data:   PRI EEOG PWD 1 7   2 3 DIS 3 7   4 3   5 2   6 7   7 7   8 10 DIS 9 7   10 3   11 7   ... View more

my data is something like this: basically, my program has to look at this table, and generate the second column on total counts, and subset count is where the condition is DIS. and the rest of the columns of the output are calculations.   ID EEOG PWD 1 7   2 3 DIS 3 7   4 3   5 2   6 7   7 7   8 10   9 7   10 3 DIS 11 7     Thanks, Nazanin ... View more

Thanks,   However, I need to keep the total at the bottom. Eventually, I need to produce the following table: so far, I have figured out two first columns. Column A Column B Column C Column D Column E Column F Column G   Total Subset   Fixed percentage     　EEOG # # % % 　 　 2 1417 76 =C14/B14 0.043 =B14*E14 =IF(F14-C14<0,0,F14-C14) 3 6900 417 =C15/B15 0.038 =B15*E15 =IF(F15-C15<0,0,F15-C15) 4 40 5 =C16/B16 0.046 =B16*E16 =IF(F16-C16<0,0,F16-C16) 5 79 6 =C17/B17 0.139 =B17*E17 =IF(F17-C17<0,0,F17-C17) 7 1871 148 =C18/B18 0.034 =B18*E18 =IF(F18-C18<0,0,F18-C18) 10 770 56 =C19/B19 0.07 =B19*E19 =IF(F19-C19<0,0,F19-C19) Total =SUM(B14:B19) =SUM(C14:C19) =C20/B20 0.04 =E20*B20 =IF(F20-C20<0,0,F20-C20)     do you have any suggestions?   Thanks,   Nazanin ... View more

so I have to export the table to Excel and calculate the total there? ... View more

what would be the difference between Last.PRI or First.PRI   Thanks,   Nazanin ... View more

Hi Kurt,   I want to go from table 1 to table 2:   PRI Col2 col3 col4 1 a a a 1 b b b 2 c c c 3 d d d 4 e e e 5 f f f 5 g g g 6 h h h 7 i i i 7 j j j 7 k k k   PRI Col2 col3 col4 1 b b b 2 c c c 3 d d d 4 e e e 5 g g g 6 h h h 7 j j j       please ignore this table: PRI Col2 col3 col4 1 a a a 1 b b b 2 c c c 3 d d d 4 e e e 5 g g g 6 h h h 7 j j j   basically, I want to remove duplicate PRIs, it does not matter ,at this point, what other columns have.   I wrote this: DATA nodups; set selfID3; by PRI; if (first.PRI and last.PRI) then output; run;   but it seems that the code gives me this as output: PRI Col2 col3 col4 2 c c c 3 d d d 4 e e e 6 h h h basically, it removes any duplicate records. how can I fix my code?   Thanks,   Nazanin ... View more