04-30-2016 01:14 AM
I need help , have to make a random homogeneous distribution of the observations on the basis of the amount of a given variable.
I have a set of records that must be assigned to specific entities based on certain percentages.
ID COUNT AMOUNT
1 1 300
2 1 150
3 2 500
4 1 200
5 3 700
entities and percentages
how can I assign the correct values of COUNT and AMOUNT entities A, B and C in relation to their proportion in the most consistent and fair as possible ?
you may kindly direct me some examples?
Thank you so much , Isabel
04-30-2016 03:21 AM
04-30-2016 05:11 AM - edited 04-30-2016 05:30 AM
Is there a rule that determines the assignment of data to groups A, B and C? Or do you want this to be random, ending up with the proportions indicated (20% of obervations in group A, etc.)?
If the latter, then AnnMaria might have the solution: http://www.thejuliagroup.com/blog/?p=2599
04-30-2016 08:37 AM
04-30-2016 07:08 AM
Proc SurveySelect is generally used for sample selection and you can specify proportions but I can't see how A/B/C tie back to your original data. Otherwise it seems a bit like three samples just stacked together.