Solved: Percent crosstable - SAS Support Communities

☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.

Fluorite | Level 6

Fluorite | Level 6

Percent crosstable

Posted 09-29-2022 11:56 AM (221 views)

I would like to know how to calculate the percent of "S" over "CES".

1 ACCEPTED SOLUTION

Accepted Solutions

Rhodochrosite | Level 12

Rhodochrosite | Level 12

Re: Percent crosstable

Posted 09-30-2022 04:16 AM (169 views) | In reply to albribmun

AggregateTable(_Sum_, Table(_Sum_, Fixed('_brand'n, 'seg'n),
'Frequency'n)) / AggregateTable(_Sum_, Table(_Sum_, Fixed(
'_brand'n), 'Frequency'n))

View solution in original post

1 REPLY 1

Rhodochrosite | Level 12

Rhodochrosite | Level 12

Re: Percent crosstable

Posted 09-30-2022 04:16 AM (170 views) | In reply to albribmun

AggregateTable(_Sum_, Table(_Sum_, Fixed('_brand'n, 'seg'n),
'Frequency'n)) / AggregateTable(_Sum_, Table(_Sum_, Fixed(
'_brand'n), 'Frequency'n))