The following code produces a horizontal tally -- each unique observation becomes a column heading, with number of occurrences below:
proc tabulate data=sas_1.top_20;
class i2;
table i2;
run;
Does anyone know of a way to use Proc Tabulate and get a vertical list, with tally number to the right of each categorical observation?
Cats 17
Dogs 12
Birds 9
etc.
Thanks,
Nicholas Kormanik
Try
proc tabulate data=sas_1.top_20; class i2; table i2 , n; run;
if you don't want any column heading
proc tabulate data=sas_1.top_20; class i2; table i2=' ' , n=' '; run;
If all you have are the two variables, why not use proc print ?
Proc tabulate is usefull for summarizing data and reporting it as a table.
Try
proc tabulate data=sas_1.top_20; class i2; table i2 , n; run;
if you don't want any column heading
proc tabulate data=sas_1.top_20; class i2; table i2=' ' , n=' '; run;
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.