BookmarkSubscribeRSS Feed
mona4u
Lapis Lazuli | Level 10

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
2 REPLIES 2
mona4u
Lapis Lazuli | Level 10

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1047 views
  • 1 like
  • 2 in conversation