topic Re: Cluster data in SAS Programming

Cluster data

Deepai — Mon, 06 Jan 2020 15:27:02 GMT

i have 400 clusters, each cluster has around 50 people. i want to get the proportion of diabetes people in each cluster and create new variable naming proportion of Diabetes in the same dataset can someone help me with this

Re: Cluster data

ed_sas_member — Mon, 06 Jan 2020 15:32:20 GMT

Hi @Deepai

You can run a PROC FREQ to do this.

Assuming you have a dummy variable indicating the status of the patient regarding diabetes:

proc freq data=have noprint;
   tables flag * cluster_id / out=want;
run;

Re: Cluster data

Deepai — Mon, 06 Jan 2020 17:35:49 GMT

Thank yiu

Re: Cluster data

ed_sas_member — Mon, 06 Jan 2020 17:51:13 GMT

Thank you @Deepai!
Could you please mark the topic as answered and close it? Thank you.

Re: Cluster data

Deepai — Mon, 06 Jan 2020 17:54:57 GMT

thank you for the information, I got it but in a separate dataset

However i am trying to get the proportion of diabetes by clusters in the same dataset.