https://communities.sas.com/t5/SAS-Programming/Calculating-proportion/m-p/623142#M183389 <P>How is a smoker identified in these clusters? How are the clusters identified? Can you show us the first 10 records of your data set?</P> Fri, 07 Feb 2020 19:15:22 GMT PaigeMiller 2020-02-07T19:15:22Z https://communities.sas.com/t5/SAS-Programming/Calculating-proportion/m-p/623140#M183387 <P>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.&nbsp; I would really appreciate the help from helping hands.&nbsp;</P><P>&nbsp;</P><P>Thanks</P> Fri, 07 Feb 2020 19:13:06 GMT https://communities.sas.com/t5/SAS-Programming/Calculating-proportion/m-p/623140#M183387 Deepai 2020-02-07T19:13:06Z https://communities.sas.com/t5/SAS-Programming/Calculating-proportion/m-p/623142#M183389 <P>How is a smoker identified in these clusters? How are the clusters identified? Can you show us the first 10 records of your data set?</P> Fri, 07 Feb 2020 19:15:22 GMT https://communities.sas.com/t5/SAS-Programming/Calculating-proportion/m-p/623142#M183389 PaigeMiller 2020-02-07T19:15:22Z https://communities.sas.com/t5/SAS-Programming/Calculating-proportion/m-p/623147#M183392 <P>cluster&nbsp; Smoker .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Proportion of smoker in each cluster (Expected outcome) .&nbsp; &nbsp; Observations</P><P>1 .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 (Yes)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>1 .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 (No)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2</P><P>1 .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.5</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.5&nbsp;</P><P>2 .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .667</P><P>2 .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .667</P><P>2 .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.667</P><P>3 .&nbsp; &nbsp; &nbsp; &nbsp; 2</P><P>3 .&nbsp; &nbsp; &nbsp; &nbsp;1</P><P>3 .&nbsp; &nbsp; &nbsp; &nbsp;2</P> Fri, 07 Feb 2020 19:24:23 GMT https://communities.sas.com/t5/SAS-Programming/Calculating-proportion/m-p/623147#M183392 Deepai 2020-02-07T19:24:23Z