/* NATIONAL Abor*/ proc report data=work.WFA nowd; columns EEOG NOC CMA PRI Abor Aborprc ; define EEOG / group 'EEOG' left; define NOC/ group; define CMA/ group; define PRI/ analysis n format=comma8. '# of Employees ' center; define Abor/analysis n format=comma8. '# of Abor' center; define Aborprc / computed format=percent8.1 'Abor(%)'center;   compute Aborprc;     AborPRC= Abor.n/PRI.n; endcomp; compute Expected;   compute after;   EEOG= "Total"; endcomp; compute after EEOG; line ''; endcomp; break after EEOG / dol skip summarize style=Header{fontweight=bold}; footnote "Source, CAS"; run;     just out of curiosity, can I write a "compute" to call another "proc report" ?   Thanks, Nazanin ... View more

Hi,   I did call missing: data WFA2; set WFA; if EEOG=2 then call missing(NOC,CMA); if EEOG=3 then call missing(CMA); if EEOG=5 then call missing ( NOC); run;   but my output, totally eliminated EEOG02, 03, and 05. I want o keep them , but I don't want to see NOC and CMA for them.   Thanks, Nazanin ... View more

something like this: EEOG NOC CMA # of Employees # of Abor Abor(%) 2     213 20 1.4% 3 1111   1 6.7% 1.3%   1112   2 0 0.0%   1114   7 0 0.0%   1121   11 0 0.0%             5   Winnipeg        TOTAL     42,102 1,343 3.2%   For EEOG 02, I don not need any further breakdown, but for EEOG o3, I want the breakdown by NOC, EEOG05, I want the breakdown by CMA.     Thanks,   Nazanin ... View more

Thanks Reeza,   basically, I want o run the code and in the output, I want to drop columns based on EEOG these are my columns for the whole report: columns EEOG NOC CMA PRI Abor Aborprc; but based on the table below, I don't need to see NOC or CMA for EEOG02. or for EEOG 03, I just want the breakdown by NOC. and so on.   EEOG NOC CMA # of Employees # of Abor Abor(%) 2 No No       3 Yes No       5 No yes         another way I think is writing different codes for different EEOGs and then append them together to have the total.   Thanks,   Nazanin ... View more

Thanks a lot Reeza,   I used Proc Report, and it was so fast and efficient.   regards,   Nazanin ... View more

unfortunately no!   it changed my input data!   ... View more

Thanks,   I tried proc tabulate, no luck! and also it was not the good tool. some SAS folks also recommended PROC REPORT. I have to review it! I was struggling with PROC report as well! do you know the equivalent to PROC report on Enterprise. sometimes, when I use Enterprise, I can figure out the codes foe SAS base.     best regards, Nazanin ... View more

wrote it myself. this is the original one: proc sql; title 'Self Identification by Age Group, HQ Region'; select Band2, count(SI_PRI) as SI_PRI format=comma10., count (PRI)as PRI format=comma10., calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Si where REGION="HQ" title 'Self Identification by Age Group, HQ Region'; group by Band2 union all select 'TOTAL', count(SI_PRI) as SI_PRI, count (PRI)as PRI, calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Si where REGION="HQ" ; TITLE; Quit;   proc sql; title 'Self Identification by Age Group, Atlantic Region'; select Band2, count(SI_PRI) as SI_PRI, count (PRI)as PRI, calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Si where REGION="ATLANTIC" title 'Self Identification by Age Group, Atlantic Region'; group by Band2 union all select 'TOTAL', count(SI_PRI) as SI_PRI, count (PRI)as PRI, calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Si where REGION="ATLANTIC" ; TITLE; Quit;   proc sql; title 'Self Identification by Age Group, PACIFIC Region'; select Band2, count(SI_PRI) as SI_PRI, count (PRI)as PRI, calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Si where REGION="PACIFIC" group by Band2 union all select 'TOTAL', count(SI_PRI) as SI_PRI, count (PRI)as PRI, calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Si where REGION="PACIFIC" ; TITLE; Quit;   proc sql; title 'Self Identification by Age Group, ONTARIO Region'; select Band2, count(SI_PRI) as SI_PRI, count (PRI)as PRI, calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Si where REGION="ONTARIO"   group by Band2 union all select 'TOTAL', count(SI_PRI) as SI_PRI, count (PRI)as PRI, calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Si where REGION="ONTARIO" ; TITLE; Quit;   proc sql; title 'Self Identification by Age Group, PRAIRIES Region'; select Band2, count(SI_PRI) as SI_PRI, count (PRI)as PRI, calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Si where REGION="PRAIRIES"   group by Band2 union all select 'TOTAL', count(SI_PRI) as SI_PRI, count (PRI)as PRI, calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Si where REGION="PRAIRIES" ; TITLE; Quit;   proc sql;   title 'Self Identification by Age Group, QUEBEC Region'; select Band2, count(SI_PRI) as SI_PRI, count (PRI)as PRI, calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Si where REGION="QUEBEC"   group by Band2 union all select 'TOTAL', count(SI_PRI) as SI_PRI, count (PRI)as PRI, calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Si where REGION="QUEBEC" ; TITLE; Quit;   but I want o combine all together to make it shorter and more efficient. Thanks, Nazanin ... View more

Thanks,   do you know what will be the equivalent to "proc report" in Enterprise guide? I am able to get the desired output by using proc sql, but SAS folks tell me that the proc report is more efficient. this is my code using proc sql:   proc sql; select REGION, count(SI_PRI) as SI_PRI, count (PRI)as PRI, calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Final2 group by REGION union all select 'TOTAL', count(SI_PRI) as SI_PRI, count (PRI)as PRI, calculated SI_PRI/calculated PRI "Return rate" format=percent8.1 from work.Final2 ; Quit;   regards, Nazanin ... View more

Thanks,   why did you use "Mean"?   my third column is first column/second column.   I also tried SAS Enterprise, but I receive errors when I try to change the code for calculation of third column.   regards,   Nazanin ... View more