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
