BookmarkSubscribeRSS Feed
thanikondharish
Fluorite | Level 6

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:

 

1 REPLY 1
Cynthia_sas
Diamond | Level 26

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-c... -- that seems to do what your example shows if I am understanding your example correctly.
Cynthia

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 783 views
  • 0 likes
  • 2 in conversation