Do you know if there is a way for me to get all results from both proc statements to produce 3 sheets instead of 6?    I'm guessing this takes us back to the macro solution. ... View more

Still hard to understand your question. Can you post your desired output ? Is the following what you are looking for ?   data data; infile cards expandtabs truncover; input month year county $ region &$20.; cards; 1 2024 GREEN Region 1 1 2024 GREEN Region 1 1 2024 YELLOW Region 1 2 2024 YELLOW Region 1 3 2024 YELLOW Region 1 1 2024 ORANGE Region 1 1 2024 ORANGE Region 1 10 2024 BLUE Region 2 11 2024 BLUE Region 2 11 2024 BLUE Region 2 1 2024 PURPLE Region 2 3 2024 PURPLE Region 2 2 2024 RED Region 3 2 2024 RED Region 3 2 2024 RED Region 3 2 2024 RED Region 3 ; proc sql; create table levels as select distinct county,region from data union select 'Black' ,'Region 1'from data(obs=1) union select 'Red','Region 2' from data(obs=1) union select 'White','Region 2' from data(obs=1) ; create table classdata as select * from (select distinct month from data), (select distinct year from data), (select * from levels) ; quit; options missing=0; proc tabulate data=work.data classdata=classdata format=5.; class region county month year ; table Region*(county all) all,month all; keylabel n=' ' all='Total'; run;   ... View more

Did you check my post at this ? You need option CLASSDATA= .   https://communities.sas.com/t5/SAS-Procedures/Proc-Report-Renaming-the-summary-line-for-break-and-rbreak-lines/m-p/955942#M83860 ... View more

@PaigeMiller wrote: You probably want to use the WEIGHT statement.   weight population;   Also, I don't think population belongs in the CLASS statement. Since there were no VAR variables there wasn't anything to apply the Weight to.   The FREQ statement would work allowing each observation to be counted POP times. A quick test shows that POP on the Class statement doesn't cause a problem if used as a FREQ variable, using the Have dataset in another post.   proc tabulate data=have format=best12. ; class sex county year pop / ; freq POP; tables county=''*(sex='' all), year=''*n/printmiss box='Sex' rts=20; keylabel n=' ' all='Total' sum=' '; run;   ... View more

title "Syphilis Cases with Adverse Outcomes by Month"; options missing=0; ods escapechar='~'; proc tabulate data=sashelp.class missing; class sex age/ preloadfmt; var weight; table sex=""*age="", weight/ printmiss BOX="Adverse Outcomes"; footnote1 j=l "%sysfunc(repeat(~_,115))2022 is preliminary data"; footnote2 j=l "%sysfunc(repeat(~_,115))Adverse Outcomes includes Syphilis cases where Neuro/Ocular/Otic/Late Clinical Manifestations is indicated as Possible, Likely or Confirmed"; footnote3 j=l "%sysfunc(repeat(~_,115))Clinical Manifestations are not mutually exclusive"; footnote4 j=l "%sysfunc(repeat(~_,115))Excludes Congenital Syphilis cases"; footnote5 j=l "%sysfunc(repeat(~_,115))Data subject to change as additional information is reported"; footnote6 j=l "%sysfunc(repeat(~_,115))Source: Ohio Department of Health, STD Surveillance Programs."; footnote7 j=l "%sysfunc(repeat(~_,115))STD Surveillance data reported through edate. "; run;   ... View more