Handling Repeating Headers in Proc Report

SivaKV — Thu, 29 Nov 2018 12:00:51 GMT

Hi,

I am using Proc report procedure in SAS Studio. I am facing a challenge. Hoping one of you could help me on below.

I am using ODS PDF to print data in PDF along with PROC REPORT procedure in SAS Studio. Right now, i am printing data as below in a single page. Its like i need to create a subtotal for each col1 value. I need to show two records at the end of each col1 value. One is sum of the individual records for each state and second is half value of some of the states. It means one record with just sum of individual records and another one is calculating the record based on some state performance.

Right now, i am achieving this by printing two proc reports procedures. one for detail data and another for subtotals.When i print the second value data for col1, headers are coming again in the middle of the page, which i dont want.

I don't want to show headers in the middle of the page, always headers should show at the beginning of the page only.. Could you please help me is there any way to achieve this.

col1 col2 col3 col4
----------------------------------------------------------
Country1 State1 23 34
State2 34 12
------------------------------------------------------
subtotal1 57 46

subtotal2 29 23

col1 col2 col3 col4
-----------------------------------------------------
Country2 State1 23 34
State2 34 12
77 88
11 66
----------------------------------------------------
subtotal1 185 200

subtotal2 93 100

Re: Handling Repeating Headers in Proc Report

Cynthia_sas — Tue, 04 Dec 2018 22:10:45 GMT

Hi: PROC REPORT has a NOHEADER option on the PROC REPORT statement. If you mean you want to suppress the column headers on the second PROC REPORT step, that should be possible to do.
Cynthia

topic Handling Repeating Headers in Proc Report in SAS Programming

Handling Repeating Headers in Proc Report

Re: Handling Repeating Headers in Proc Report