so I have a dataset I have people with more than one observation under the same id. And they are also grouped under different criteria, so there are different grouping variables, e.g. e.g. id var group_1 Group_2 1 x 3 A1 1 z 3 A1 2 y 1 B2 3 8 2 A3 3 e 2 A3 How can I make a report or summaried table to show the unique count of frequency by ID, under each grouping variable, and breakdown by their group value. Like this group headcount 1 3 2 4 A1 1 A3 6 B2 ........ ..... Proc SQL only counts distinct value from a variable as a whole, I don't know how to condition it. Similarly, if I use Sum(case...when) I doesn't give me discticnt count by ID. Here, to be noted that I want not the unique count of a variable, but a unique count of a variable by ID. And I don't know how to do that in Proc freq. My last resort is to separate dataset, run proc sort to delete dups, and then run proc freq.. but that willl give me a ton of tables, and I need another proc to join the info(headcounts) I want in an addional table.
... View more