Hi there, I am now learning proc sql procedure and have a question on counting and calculating percentages of subtotal. Suppose I create one dataset looks like below: group gender enrolled finished group 1 M Y Y group 1 M Y Y group 1 F Y Y group 1 F Y N group 2 M Y Y group 2 M Y Y group 2 M Y Y group 2 F Y N group 1 F Y N group 1 F Y Y group 2 M Y Y group 2 F Y Y And I would like to get some summaries on counts and percentages based on groups and gender. The output table looks like this: stat group 1 group 2 enrolled 6 6 finished 4(66%) 5(83%) F 2(50%) 4(80%) M 2(50%) 1(20%) I just calculate the counts and percentages by hands but the basic ideas are the percentages of finished will be finished/enrolled, and the percentages in the gender are the proportions of finished people. I would like to know how I can get the correct numbers and percentages using proc sql and count function in it. I also do not know whether I can transpose the output table in proc sql or not. Any thought or explanations will help, thanks!
... View more