topic Re: how to produce two columns for the same variable in define statement in proc report in ODS and Base Reporting

how to produce two rows for the same variable in define statement in proc report

mona4u — Mon, 19 Feb 2018 19:38:25 GMT

Hi,

I need to produce a second row for each variable in my define statement that's the aimed result


Site	6-Feb-18
Sites Contracted:	34
Sites Initiated:	37	108.8%
Sites Qualified:	6	17.6%
Sites Supplied:	7	20.6%

this is the code that I want to enhance

proc report data=auto3;
column Sites_Contracted site_number1 Site_Approved1 Date_Supplied3;
define Sites_Contracted / analysis mean "Sites Contracted";
define site_number1 / analysis n "Sites Initiated";
define Site_Approved1 / sum "Sites Qualified";
define Date_Supplied3/ sum "Sites Supplied" ;

run;

this is my current result

sites Contracted Sites Initiated Sites Qualified Sites Supplied

Re: how to produce two columns for the same variable in define statement in proc report

Reeza — Mon, 19 Feb 2018 19:34:01 GMT

What does your input data look like?

Re: how to produce two columns for the same variable in define statement in proc report

mona4u — Mon, 19 Feb 2018 19:36:51 GMT

I don't think that's a matter but I need to produce another row for the same variable to compute the percentage.