Desktop productivity for business analysts and programmers

Demographic tabulation on EG

Accepted Solution Solved
Reply
Contributor
Posts: 65
Accepted Solution

Demographic tabulation on EG

Hi

I am having a little bit problem on my reporting project in EG

I have demographics for ove a 6 milion peope and also i have about 26 segments

i want to create report for every segment including percentage distributions for every individual segment

how ever i am unable to create a reliable quick report tabulates number of individuals fall in specific segment's demographic attributes.

I just printed the report i need attached bellow

Although it seems a easy job i have been frustrated within one way frequencies and table summary nodes

if you could help i would be appriaciate

Thank you very much

Attachment

Accepted Solutions
Solution
‎05-25-2014 10:00 AM
Trusted Advisor
Posts: 1,059

Re: Demographic tabulation on EG

I think you can also do it using the "point and click" options:

Using Describe | Summary Tables

Put Marital Status, Age, and Segment into Classification Variables, nothing in Analysis Variables

On the Summary Tables layout screen, put Marital Status and Age on the left (row) dimension, not nested. Put Segment into the top (column) dimension.

Under Segment, replace N with RowPctN. I think this will produce what you want.

Tom

View solution in original post


All Replies
Trusted Advisor
Posts: 1,203

Re: Demographic tabulation on EG

Try this.

proc tabulate data=have;

class segment age martial_status;

keylabel all='Total';

table martial_status all, segment*pctn<martial_status all>='Col %';

table age all, segment*pctn<age all>='Col %';

run;

Solution
‎05-25-2014 10:00 AM
Trusted Advisor
Posts: 1,059

Re: Demographic tabulation on EG

I think you can also do it using the "point and click" options:

Using Describe | Summary Tables

Put Marital Status, Age, and Segment into Classification Variables, nothing in Analysis Variables

On the Summary Tables layout screen, put Marital Status and Age on the left (row) dimension, not nested. Put Segment into the top (column) dimension.

Under Segment, replace N with RowPctN. I think this will produce what you want.

Tom

Contributor
Posts: 65

Re: Demographic tabulation on EG

Thanks Tom thats what i really need...

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 237 views
  • 5 likes
  • 3 in conversation