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
34 | 37 | 6 | 7 |
What does your input data look like?
I don't think that's a matter but I need to produce another row for the same variable to compute the percentage.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.