topic how to generate report with required structure(proc report) in SAS Programming

how to generate report with required structure(proc report)

thanikondharish — Sat, 21 Aug 2021 06:26:34 GMT

I have one raw dataset :

raw data:

conti $ country $ state $ pop_count $
asia ind mh 300
asia ind ka 200
asia ind tn 200

how to get output report structure like below(in proc report only):

required output:

countrywise population
conti:asia date:todaY_date
-------------------------------------------------------------------
country
state pop_count
--------------------------------------------------------------------
ind
mh 300

ka 200

tn 200

how to write code in proc report only:

Re: how to generate report with required structure(proc report)

Cynthia_sas — Sat, 21 Aug 2021 15:05:10 GMT

Hi:
What code have you tried? Did you search the Forum for previous questions like this? About a week ago, I posted an example that works in RTF and PDF using LEFTMARGIN in this posting: "Re: How to make a subgroup instead of a separate column in PROC REPORT?" which you'll find here: https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-make-a-subgroup-instead-of-a-separate-column-in-PROC/td-p/760519 -- that seems to do what your example shows if I am understanding your example correctly.
Cynthia