Frequency table with multiple variables

Dhana18 — Thu, 03 Oct 2019 19:42:48 GMT

I have a data alike this

AlertType

Gender

MSM

Gender_Sp

Race

Ethnicity

Number of partners

Age

GCHX

SXPharyngeal

Discharge

Dysuria

SXAbdomen

Alert

Yes

male

White

hispanic

yes

Non-Alert

female

Black

non hispanic

yes

Seed

Unk

Unknown

other

hispanic

alert

female

Black

non hispanic

yes

seed

mtf

Unk

Unknown

other

hispanic

yes

Seed

Yes

male

White

non hispanic

yes

Alert

female

Black

hispanic

Non-Alert

ftm

male

other

non hispanic

yes

Seed

Unk

male

White

hispanic

-2

yes

Non-Alert

female

Black

non hispanic

-4

yes

Seed

Unk

Unknown

other

hispanic

-6

yes

I would like to have a output table like this:

	Alert	Non-Alert	Seed
	Male	Female	MSM	Male	Female	MSM	Male	Female	MSM
Gender
Race
Ethnicity
Number of Partners
Gender_sp
GCHX
SXPharyngeal
Discharge
Dysuria
SXAbdomen

What is the best way to accomplish this in an efficient way?

I greatly appreciate your help.

Re: Frequency table with multiple variables

ed_sas_member — Sun, 06 Oct 2019 09:11:58 GMT

Hi @Dhana18 ,

I believe you want to create a report rather than a SAS dataset as you want to display Gender and MSM categories by Alertype as columns.

May be you could try Proc Tabulate as shown below. In the Tables statement, you can specify the structure of your report to display statistics: (rows), (columns) * (statistics eg: n to show frequency)

proc tabulate data=have out=want;
	class AlertType Gender MSM Gender_Sp Race Ethnicity Num_partners Age GCHX SXPharyngeal Discharge Dysuria SXAbdomen;
	tables (Gender_Sp Race Ethnicity Num_partners Age GCHX SXPharyngeal Discharge Dysuria SXAbdomen),(AlertType *(Gender MSM))*n;
run;

NB: it seems that you have some data management to perform. For example, Alerttype contains "Alert" and "alert" -> proc tabulate is case-sensitive to identify modalities. So I think you can use a proc format for example to avoid these issues and group similar modalities. Or even to overwrite original data if it is allowed.

Hope this help.

topic Re: Frequency table with multiple variables in SAS Programming

Frequency table with multiple variables

Re: Frequency table with multiple variables