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
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
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;
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
Thanks Tom thats what i really need...
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.