topic Re: Producing a report in a specific arrangement in ODS and Base Reporting

Producing a report in a specific arrangement

nduksy — Fri, 12 Feb 2021 18:33:13 GMT

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

Re: Producing a report in a specific arrangement

Reeza — Fri, 12 Feb 2021 18:39:45 GMT

PROC FREQ output does that by default so pipe the results directly to a file or use PROC TABULATE but both will have the same issue.

ods excel file='/folders/myfolders/demo.xlsx' style=journal;
proc freq data=nameOfYourDataSet;
table ebola*truth / nopercent norow nocol;
run;
ods excel close;

Re: Producing a report in a specific arrangement

nduksy — Fri, 12 Feb 2021 18:47:50 GMT

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

Re: Producing a report in a specific arrangement

ballardw — Fri, 12 Feb 2021 19:31:22 GMT

@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.

Re: Producing a report in a specific arrangement

Reeza — Fri, 12 Feb 2021 20:33:14 GMT

Did you run the code I included and check the output?

PROC FREQ has two outputs, one creates a data set in more of a data format and their is the displayed format. The one you have shown is similar to the displayed format, which you can pipe directly to an output file.

We're happy to help but you've posted images. To 'help you with exact code' would mean having to literally type out your data shown to create the sample data, write the code AND show the output (since the code is already above), and I'm sure why you can see why posting data as text, preferably a data step would be easier to get help.

If that code doesn't work, please explain why in detail. Saying something does not work is not informative, it could mean anything from your computer exploded to a missing semicolon. Ideally, provide what you have, the starting point, what you want and what you've tried so far.

Re: Producing a report in a specific arrangement

nduksy — Fri, 12 Feb 2021 21:49:01 GMT

Thank you so much, that actually worked perfectly!!!