I'm running proc report using this code and that's what I got. I'm not able to compute the right percentages.  Please advise me how I can enhance my code  to get the aimed result    proc report data=QUERIES3; column SITE_NUMBER numsites percentages; define SITE_NUMBER/ "Top 3 Sites with highest # issues"; define numsites/ analysis sum "# Open Issues"; define percentages/ computed format=percent9.3; COMPUTE percentages; percentages=(numsites/numsites.sum); endcomp; rbreak after/ summarize ; run;   Top 3 Sites with highest # issues # Open Issues percentages 1350 7 . 1601 7 . 1450 6 .   20 .   and that the aimed ressult    Top 3 Sites with highest # issues # Open Issues percentages 1350 7 35% 1601 7 35% 1450 6 30%   20 100%     ... View more

Hi,  I have this input and I'm trying to output only the max 3 by using proc report  Top 3 Sites with highest # issues # Open Issues 1350 7 1601 7 1450 6 1451 4 5006 4 1602 3 1200 2 1600 2 1050 1 5008   and this is the aimed results  Top 3 Sites with highest # issues: 1601 1350 1450 Open Issues: 7 7 6   ... View more

  I have this dataset and I want to create a report that include the max 3 of numsites. I tried proc univariate but the problem is it gonna include the highest and the lowest in the output and I couldn't find option that exclude the lowest .  Please advise me what is the best way to get the result.       Obs Site_Number numsites 1 1050 1 2 1200 2 3 1350 7 4 1450 6 5 1451 4 6 1600 2 7 1601 7 8 1602 3 9 5006 4 10 5008 1 ... View more

  I'm using proc report and this is the code that I'm using  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; and this is my current results   Sites Contracted Sites Initiated Sites Qualified Sites Supplied 34 37 6 7   but I need to know how I can get the second row  as it showing below (my aimed result)  by knowing that I got the percentages by using this formula  site contracted %=(site contacted/site contracted )*100  site initiated %= (site initiated/site contracted)*100 site qulalified%=(site qualified/site contracted)*100 site supplied %= (site supplied/site contracted)*100     Sites Contracted Sites Initiated Sites Qualified Sites Supplied 34 37 6 7 100% 108.80% 17.60% 20.60%     this is my input  Obs Sites_Contracted site_number1 Site_Approved1 Date_Supplied3 1 34 1000 . . 2 34 1001 . . 3 34 1050 1 . 4 34 1100 . 1 5 34 1200 1 1 6 34 1250 1 1 7 34 1252 . . 8 34 1300 . . 9 34 1350 . 1 10 34 1351 . . 11 34 1400 . . 12 34 1401 . . 13 34 1450 . . 14 34 1451 1 . 15 34 1452 . . 16 34 1453 . . 17 34 1500 . . 18 34 1600 1 . 19 34 1601 1 1 20 34 1602 . . 21 34 1700 . 1 22 34 1750 . . 23 34 5000 . . 24 34 5002 . . 25 34 5003 . . 26 34 5003 . . 27 34 5003 . . 28 34 5003 . . 29 34 5003 . . 30 34 5003 . . 31 34 5003 . . 32 34 5004 . . 33 34 5005 . . 34 34 5006 . . 35 34 5007 . . 36 34 5008 . 1 37 34 5009 . .   ... View more

I'm using sas studio and the problem is I went for lunch without saving the program then when I came back it's started new session and I couldn't find my program  ... View more