Hello All,
I have the dataset below
...and I have been asked to present/generate a table like the one below.
I have played around with proc report but no luck yet. I don't know how to manipulate the data so that the numbers are placed in the right column/rows within my report.
I will appreciate some help.
Thanks
The first picture I posted is from a proc freq action.
I'll appreciate if you can help with some more clarity per using proc tabulate to produce a similar report as contained in the second picture.
Thanks
@nduksy wrote:
The first picture I posted is from a proc freq action.
I'll appreciate if you can help with some more clarity per using proc tabulate to produce a similar report as contained in the second picture.
Thanks
Actual data please. As in a data step to create a data set.
If you want to use Proc Tabulate you might be better off using the source data instead of Proc Freq output, if that is the request. Do you want the counts? the Percents? it is not clear what expect Proc Tabulate to create as there are NO VALUES in the table. Your example also implies that the Ebola Negative results are supposed to be suppressed (not shown) but have a row in the data.
Thank you so much, that actually worked perfectly!!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.