I used Proc tabulate procedure to solve the tally information of the given (sample dataset) table.
But I required a tally of the Percentage columns as 100%. For more details kindly go through the below information.
input ID age$ sex$ Emp$;
1 18-25 M Govt
2 50-60 F Pvt
6 26-35 F Govt
8 18-25 M Pvt
4 26-35 F Govt
5 36-45 M Govt
9 46-55 M Pvt
3 18-25 M Govt
0 36-45 M Govt
proc tabulate data = aaa;
class age sex Emp;
tables age all,Emp*(sex=' ' *(n*f=8. reppctn='%')) all='Total'*(n*f=8. reppctn='%')/rts=10;
If you run the above code. It results N and % of 9 observations as Gender and Employment wise.
But I require a % column to calculate its value as 100% of its gender and employment like the Image given below.
Kindly suggest the code which results in an image.
If you require any clarification. I will be glad to help.
Hi: For purposes of completeness: PCTN PCTSUM ROWPCTN ROWPCTSUM COLPCTN COLPCTSUM REPPCTN REPPCTSUM PAGEPCTN PAGEPCTSUM
are all the percent statistics. Using one of these depends on whether you want the percent of the count (N) or the percent of a numeric variable (PCTSUM). Look in the TABULATE documentation and note that TABULATE does an automatic multiply by 100, so you need to use a PICTURE format to get the % sign into the TABULATE output.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.