The SAS Output Delivery System and reporting techniques

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

Reply
Regular Contributor
Posts: 165

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

[ Edited ]

Hi, 

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

 

  
Site6-Feb-18
Sites Contracted:34
Sites Initiated:37108.8%
Sites Qualified:617.6%
Sites Supplied:720.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

343767
Super User
Posts: 23,988

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

What does your input data look like?

 

 

Regular Contributor
Posts: 165

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

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

Ask a Question
Discussion stats
  • 2 replies
  • 138 views
  • 1 like
  • 2 in conversation