Dear Experts,
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.
data aaa;
input ID age$ sex$ Emp$;
cards;
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;
run;
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.
Thanks in advance!
You have used in your code REPPCT which is percentage per report.
You can use ROWPCTN to calculate row percentage or use PCTSUM to calculate column percentage.
You have used in your code REPPCT which is percentage per report.
You can use ROWPCTN to calculate row percentage or use PCTSUM to calculate column percentage.
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.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.