Hi,   when I run 4 different proc reports and I get 4 different results. I want the results to be sent to one Excel file but on different tabs.   is it possible in SAS EG? and how?   Thanks,   Nazanin ... View more

Hi,   This is my code:   proc report nowd data=work.Elig; title "CRA Eligibility to Retire4"; columns Retfy1 PRI rate; define Retfy1 / group 'Eligibility to Retire'; define PRI/ analysis n format=comma8. "# of Employees " center; define rate / computed format=percent8.1 "Rate(%)" center; compute Rate;   Rate= PRI.n/PRI.n; endcomp; rbreak after / dol skip summarize style=Header{fontweight=bold} ; compute after ; Retfy1="Total"; endcomp; footnote j=1 "Source: CAS"; run;   I would like to be able to calculate the rate over the total here:   I don't want to have 100% as shown on the table, however I want to be able to calculate the percentage of each row over the total.   Eligibility to Retire # of Employees Rate(%) 2019-20 1,247 =1247/ 34458 2020-21 1,428 100.00% 2021-22 1,367 100.00% 2022-23 1,290 100.00% 2023-24 1,262 100.00% 2024-25 1,046 100.00% 2025-26 931 100.00% 2026-27 936 100.00% 2027-28 1,161 100.00% 2028-29 1,053 100.00% 2029-30 1,141 100.00% 20xx 17,870 100.00% Already Eligible 3,726 100.00% Total 34,458 100.00%     ... View more

hi,   I can generate the first table using proc report. However, I want to generate the second table. more specifically, the highlighted addition. Highlighted addition is the subtotal of CMAs under EEOG 7.   How can I do it in proc report?   Thanks,   Nazanin ... View more

Hi, here is my output. I would like to re-label EEOG and NOC for example, when the EEOG is 2, I would like to change it to (2) middle managers. Please not that the EEOG and NOC are  numbers in my input DB, but I want to re-label it to a text in my output.   EEOG NOC country province CMA # of Employees 2         2,706 2 . Canada     2,706 3         12,689 3 1111 Canada     6,123   1112 Canada     184   1114 Canada     7   1121 Canada     518   1122 Canada     13   1123 Canada     150   2161 Canada     42   2171 Canada     1,529   2174 Canada     1,460   4151 Canada     6   4162 Canada     270   4163 Canada     268   4164 Canada     2,083   4169 Canada     5   5111 Canada     30   5122 Canada     1   this is how I define variables: proc report data=work.WFA2 spanrows;     columns EEOG NOC Country Province CMA PRI ; define EEOG / group 'EEOG' left; define NOC/ group missing 'NOC' left; define Country/ group missing ' country' left; define province / group missing 'province' left; define CMA / group missing 'CMA' left; define PRI/ analysis n format=comma8. '# of Employees ' center;   Thanks for help.   Nazanin   ... View more