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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.