topic Re: Distribution of case and controls in different age groups - Plot & table in SAS Visual Analytics

Distribution of case and controls in different age groups - Plot & table

mantubiradar19 — Mon, 23 Nov 2020 05:49:33 GMT

I have a dataset containing binary variable DIAGNOSIS (0 & 1 for control and case) and the range of AGE is from 20 ~ 80. I'm interested to see the distribution (# of cases & controls) in various age groups with an interval of 10 years. (20~30, 30~40, 50~60, 60~70, etc).

Please suggest to me how to obtain suitable tables and plots to visualize my data.

PS: I have attached an example

Thanks in advance

Re: Distribution of case and controls in different age groups - Plot & table

PetriRoine — Tue, 24 Nov 2020 06:17:56 GMT

Hello @mantubiradar19

The following instructions are based on the assumptions that the data is aligned like this:

Age	Diagnosis
37	0
76	1
29	0
…	…

Steps taken

Create Age group category:
Use the Custom category feature to create age buckets.
Create Cases measure:
Use the New Calculated Item feature to calculate number cases.
```
IF ( 'Diagnosis'n = 1 )
RETURN 1
ELSE 0
```
Create Controls measure:
Use the New Calculated Item feature to calculate number of controls.
```
IF ( 'Diagnosis'n = 0 )
RETURN 1
ELSE 0
```
Create Total measure:
Use the New Calculated Item feature to calculate number of cases + controls.
```
'Cases'n + 'Controls'n
```

Create Cases %, Controls %, and Total %
Use the New Calculated item feature to calculate three new aggregated measures.
Cases %

Sum [_ByGroup_] ('Cases'n) / Sum [_ForAll_] ('Cases'n)

Controls %

Sum [_ByGroup_] ('Controls'n) / Sum [_ForAll_] ('Controls'n)

Total %

Sum [_ByGroup_] ('Total'n) / Sum [_ForAll_] ('Total'n)

Utilize Crosstab object and assign roles as below

I hope this helps.

Best regards,

Petri

Re: Distribution of case and controls in different age groups - Plot & table

mantubiradar19 — Tue, 24 Nov 2020 11:47:38 GMT

Thank you ~ Petri