My data is as follows: data test; input facilities_name $ sex totalpatients; datalines; ABCD 1 1850 CDXF 0 1234 XYZ 1 34567 qwerty 1 123 ASDF 0 1345567 rtyu 0 45 ; run;   I have to populate following table:   Sex Total no of male(1) 3 Total no of female(0) 3 Facility rank by Totalpatients          Quartile 1 (25)(mean N = XXX) (No of facilities)        Quartile 2 (50)          Quartile 3 (75)          Quartile 4 (100)     All suggestions are welcomed!  ... View more

My data is as follows: ID [num var]           Percent [Character var] 1452                      10 1254                      20.00 4852                      30 7526                      40 7542                      0 7530                      50.00 9856                      50 3256                      51 7854                     100 7128                      500 1287                      80 4568                      5.00 7540                      8.00 9530                      9 9920                      25   I'm trying to create another dataset from the above data where the percent is larger than 0 and less than or equal to 50.   I used  proc sql; create table x as select id, percent from test where "0"<percent<="50"; quit;   but it gives me the observation that has 100 percent.   Please help!     ... View more