Hello everyone, I need assistance with counting rows in a SAS Viya table based on a specific value in another column. I have a table with two columns: category_column and value_column. I want to determine the number of rows that belong to each category in category_column. For example, if I have the following table: category_column value_column A 10 B 20 A 30 C 40 B 50 I want to obtain the following results: category_column count A 2 B 2 C 1 I have tried using the PROC FREQ procedure, but it displays the results in a table, and I need to output the results as a dataset or table that I can use in subsequent steps. Could someone suggest an efficient method to achieve this in SAS Viya? Additional Information: SAS Viya version: i dont know I do not have access to SAS Studio. Thank you very much for your help."
... View more