I have a code as below proc sql; select spriden_id ,tbraccd_detail_code,sum (tbraccd_AMOUNT) as Amount_Due from stg.tbraccd a, stg.spriden b where  b.spriden_change_ind is null group by spriden_id, tbraccd_detail_code HAVING SUM(TBRACCD_AMOUNT) <0; quit;   But my output amount_due is like -711e-16, -284E-16, etc How can i correct the amount_due's output ... View more

I have a huge table, and tried to summarize as below: Term Campus Gender id 2014 West Female 15 2014 West Male 20 2015 West Male 22 2015 East Male 23 2015 EAST Female 25 2014 EAST Female 26 2015 East Male 54 2014 East Male 54 2015 West Unreported 58 2014 EAST Male 62 2015 East Female 85   I want to create a report with that. I created with proc tabulate with most part. But i need difference part too. So i want to achieve a report as below:                                                                                                                          Campus                                                             East                                                                                                                                     West                   2014        %Tot Enrol        2015     %Tot Enrl           Difference          %Tot Enrl                 2014        %Tot Enrol        2015     %Tot Enrl           Difference         %Tot Enrl Gender             Female             1                %33.3          2           %50                    1                        %100                        1             %50                      0           %0                      -1                  Male                 2                %66.6          2            %50                   0                          %0                          1            %50                      1            %50                    0 Unreported       0                  %0              0             %0                   0                           %0                         0             %0                      1            %50                     1 All                    3               %100             4            %100                 1                           %100                     2             %100                  2           %100                     0                   %100                            Is this report achievable? I used this code before but there is no differencecode,  in here? proc tabulate data=M format=8.2 out= gender; class TERM CAMPUS GENDER/MISSING; table       GENDER ALL, (CAMPUS ALL)*TERM*(n='#Enrl'*f=8. pctn<GENDER ALL/*CAMPUS*TERM*/  ALL*GENDER   GENDER> ='% Tot Enrl') / rts=20; run;  ... View more

I have some tables as below:        Var1     Var2    Var3       Var4       Var5            AA       19,176   48.4%    20,001    49.6%       AS        9,717    24.5%    9,609      23.8%       BA        8,694    21.9%    8,891       22%       BB        2,032    5,1%      1,849      4.6% I need to add one new column at the top. And i want to sum each row. So the first new column should be like this:        Var1       Var2     Var3       Var4       Var5          Sum        39,619   100.0%   40,350    100.0%       AA         19,176   48.4%    20,001    49.6%       AS          9,717    24.5%    9,609      23.8%       BA          8,694    21.9%    8,891       22%       BB          2,032    5,1%      1,849      4.6% ... View more