I am relatively new to using SAS beyond the routine PROC proceedures.
I am trying to create a simple frequency distribution chart, but on grouped data.
In other words, I want to define 10 groups, say 0-10, 10-20, ..... 90-100
and then count how many of the originial observations are in each of these 10 groups.
Is there an easy way to do this using PROC UNIVARIATE or such?
Doc's suggestion (PROC FORMAT+PROC FREQ) is just right.
More solutions are available, but all very similar, and all within a two pass execution.
Another one, would be two SQL queries or one SQL query with sub-query, (which is still a two pass solution), with the inner query producing some temporary GROUP_ID for each row (say GROUP_ID=1 case when 0-10, GROUP_ID=2 case when 10-20, ...), and the outer query counting row for each GROUP_ID.