topic Re: Counting Rows Based on Value in Another Column in SAS Viya in SAS Viya

Counting Rows Based on Value in Another Column in SAS Viya

Yoosf — Tue, 04 Mar 2025 15:47:45 GMT

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."

Re: Counting Rows Based on Value in Another Column in SAS Viya

Ksharp — Wed, 05 Mar 2025 02:31:20 GMT

proc freq data=sashelp.class noprint;
table sex/out=want;
run;

Re: Counting Rows Based on Value in Another Column in SAS Viya

Yoosf — Wed, 05 Mar 2025 05:07:12 GMT

I do not have access to SAS Studio.

Re: Counting Rows Based on Value in Another Column in SAS Viya

Patrick — Wed, 05 Mar 2025 06:03:47 GMT

@Yoosf wrote:

I do not have access to SAS Studio.

Just run it the way you're running any other SAS code. What client are you using? Or is this about creating a report in Visual Analytics?

Re: Counting Rows Based on Value in Another Column in SAS Viya

Ksharp — Wed, 05 Mar 2025 06:16:20 GMT

"I have tried using the PROC FREQ procedure, "
Since you have already run PROC FREQ before, run my code as you did before.