topic Re: Combine levels of a variable in SAS Programming

Combine levels of a variable

epi_user — Wed, 16 Dec 2020 15:57:46 GMT

I have a dataset that has many age categories by race and I am interested in combining all age categories in each race in each county to create a "total" variable for each county .

thank you!

I'd like the final data to look like this:

County Race Age _2020

x	Asi	15-19	65
x	Asi	20-24	34
x	Asi	25-29	45
x	Asi	Total	144
y	Asi	15-19	16
y	Asi	20-24	9
y	Asi	25-29	13
y	Asi	Total	38

the original data looks like this:

County Race Age _2020

x	Asi	15-19	65
x	Asi	20-24	34
x	Asi	25-29	45
y	Asi	15-19	16
y	Asi	20-24	9
y	Asi	25-29	13

Re: Combine levels of a variable

PaigeMiller — Wed, 16 Dec 2020 16:42:22 GMT

Do you want the final output as a report or table; or do you want the final output to be a SAS data set with the extra rows?

Re: Combine levels of a variable

Reeza — Wed, 16 Dec 2020 16:36:35 GMT

How are you planning to display your table? PROC REPORT/TABULATE/MEANS can do this automatically.

And is it created from a summary procedure initially? If so, you can likely

@epi_user wrote:

I have a dataset that has many age categories by race and I am interested in combining all age categories in each race in each county to create a "total" variable for each county .

thank you!

I'd like the final data to look like this:

County Race Age _2020

x Asi 15-19 65

x Asi 20-24 34

x Asi 25-29 45

x Asi Total 144

y Asi 15-19 16

y Asi 20-24 9

y Asi 25-29 13

y Asi Total 38

the original data looks like this:

County Race Age _2020

x Asi 15-19 65

x Asi 20-24 34

x Asi 25-29 45

y Asi 15-19 16

y Asi 20-24 9

y Asi 25-29 13

add in the total calculation to that step.