topic Re: Using proc SQL to sum categories? in SAS Programming

Using proc SQL to sum categories?

SAS93 — Mon, 28 Sep 2020 15:43:02 GMT

I'm new to using proc SQL, but I'm using it to look at counts of states by race/ethnicity (separate categories).

I want to include a new group called "all" for both race and ethnicity, so it would be combining (for each of race and ethnicity) the total counts for the 2 categories.

What is the easiest way to do this? To create this table, I'm using two separate tables that already have race and ethnicity broken down; would it be easier to modify those primary tables, or somehow create a new variable within the new table?

Re: Using proc SQL to sum categories?

Reeza — Mon, 28 Sep 2020 15:49:16 GMT

Not using SQL is faster - PROC MEANS does this by default or PROC TABULATE.
For MEANS look into the CLASS, WAYS and TYPES statements.

Re: Using proc SQL to sum categories?

PaigeMiller — Mon, 28 Sep 2020 15:53:33 GMT

I'm using two separate tables that already have race and ethnicity broken down

Can you show us a portion of these two tables? Can you show us the desired output?

Re: Using proc SQL to sum categories?

PGStats — Mon, 28 Sep 2020 16:15:57 GMT

@SAS93 wrote:

What is the easiest way to do this?

If you want a dataset, use proc Means. If you want a report table, use proc Tabulate.