topic Re: Obtaining cluster proportion in SAS Programming

Obtaining cluster proportion

Deepai — Fri, 07 Feb 2020 20:31:03 GMT

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

Re: Obtaining cluster proportion

PaigeMiller — Fri, 07 Feb 2020 20:39:02 GMT

DUPLICATE THREAD

DO NOT REPLY HERE

Reply at: https://communities.sas.com/t5/SAS-Programming/Calculating-proportion/td-p/623140 where there is already one answer.

Re: Obtaining cluster proportion

ballardw — Fri, 07 Feb 2020 20:39:53 GMT

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

The example data only needs to include the variables needed to identify a cluster and your smoking variable.

Then show what you expect as a result.

In the same data set is possibly not a good idea as mixing summaries and observation values has the potential for oddness when someone forgets which variable is a summary. Can you describe exactly why you need the summary proportion on each record?