I currently generating a report using some descriptive statistics within Proc Tabulate where I generate the counts and percentages to produce an Excel output using ODS. Originally, I would produce a single cell for each value generated from Proc Tabulate, but I've received a request to combine the values into a single cell within the Excel output. For example, the output would contain n (%) within one cell. The data structure contains a record for each id with a designated cohort flag to identify the respected group. I've found that you can add the parentheses around the percentages using Proc Format along with the "prefix" option, but I'm having issues figuring out if it is possible to combine the two cells while maintaining an Excel output. I realize it isn't ideal to have two values within a single Excel sheet, but the original program incorporates Proc Tabulate to generate the statistics for the outputs and I would like to avoid running it in Proc Report if possible. This is an example of the current output: Overall Disease 1 Disease 2 Disease 3 N (count) 3,000 1,000 1,500 500 Male 1,350 450 675 225 % 45.00% 45.00% 45.00% 45.00% Female 1,650 650 825 275 % 55.00% 55.00% 55.00% 55.00% This is an example of the desired output: Overall Disease 1 Disease 2 Disease 3 N (count) 3,000 1,000 1,500 500 Male N (%) 1,350 (45.00%) 450 (45.00%) 675 (45.00%) 225 (45.00%) Female N (%) 1,650 (55.00%) 650 (55.00%) 825 (55.00%) 275 (55.00%)
... View more