cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Deepai
‎02-29-2020
  • 9 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

calculating proportion by cluster

by Calcite | Level 5 in SAS Programming
‎02-08-2020 11:43 AM
‎02-08-2020 11:43 AM
I have the following data, can you please help me to get the proportion of smokers in each cluster     data x; input ID cluster smoke ; cards; 1       1       1 2       1       1 3       1       1 4       2       0 5       2       1 6       2       0 7       2       1 8       3       1 9       3        0 ;run;   Expected outcome   ID   cluster  smoke  Proportion of Smokers in each cluster 1       1       1                100 2       1       1                100 3       1       1                100 4       2       0                50 5       2       1                50 6       2       0                50 7       2       1                50              8       3       1               66        9       3        0              66 10     3 .      1              66 ... View more

Obtaining cluster proportion

by Calcite | Level 5 in SAS Programming
‎02-07-2020 03:31 PM
‎02-07-2020 03:31 PM
I have 400 clusters (20,000 observations). I want to get proportion of smokers in each cluster (Smoking vs non-smoking) as a separate variable in the same data set for each cluster.  I would really appreciate the help from helping hands.    Thanks     ... View more

Re: Calculating proportion

by Calcite | Level 5 in SAS Programming
‎02-07-2020 02:22 PM
‎02-07-2020 02:22 PM
cluster  Smoker .              Proportion of smoker in each cluster (Expected outcome) .    Observations 1 .          1 (Yes)                     .5                                                                                              1 1 .          2 (No)                      .5                                                                                            2 1 .         1                             .5 1           2                             .5  2 .         1                            .667 2 .         2                            .667 2 .         1                           .667 3 .        2 3 .       1 3 .       2 ... View more

Calculating proportion

by Calcite | Level 5 in SAS Programming
‎02-07-2020 02:13 PM
‎02-07-2020 02:13 PM
I have 400 clusters (20,000 observations). I want to get proportion of smokers in each cluster (Smoking vs non-smoking) as a separate variable in the same data set for each cluster.  I would really appreciate the help from helping hands.    Thanks ... View more

cluster size

by Calcite | Level 5 in New SAS User
‎02-07-2020 12:51 PM
‎02-07-2020 12:51 PM
Hello helping hands,   I have 20,000 individuals in my dataset. All these individuals belong to 400 different clusters. I want to get how many people are there in each cluster.  i want to get the cluster size in the same dataset. Sorry i am very new with SAS.   Thanks ... View more

Re: Cluster data

by Calcite | Level 5 in SAS Programming
‎01-06-2020 12:54 PM
‎01-06-2020 12:54 PM
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.  ... View more

Re: Cluster data

by Calcite | Level 5 in SAS Programming
‎01-06-2020 12:35 PM
‎01-06-2020 12:35 PM
Thank yiu ... View more

Cluster data

by Calcite | Level 5 in SAS Programming
‎01-06-2020 10:27 AM
‎01-06-2020 10:27 AM
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 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-29-2020 01:32 AM
Quick links