topic Re: homogeneous distribution in Statistical Procedures

homogeneous distribution

Isabel — Sat, 30 Apr 2016 05:14:32 GMT

Hi,

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.

Example (basetable):

ID COUNT AMOUNT

1 1 300

2 1 150

3 2 500

4 1 200

5 3 700

entities and percentages

ENTITY PERCENTAGE

A 20%

B 70%

C 10%

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

Re: homogeneous distribution

Ksharp — Sat, 30 Apr 2016 06:44:23 GMT

Your post is ambiguous . What output would you like to see ?

Re: homogeneous distribution

Isabel — Sat, 30 Apr 2016 07:21:16 GMT

Hi,

for example:
A 20% COUNT: 1.6 AMOUNT: 370
B 70% COUNT: 5.6 AMOUNT:1295
C 10% COUNT: 0.8 AMOUNT: 185

so:

ID  COUNT AMOUNT
1   1        300 => A
2   1        150 => A
3   2        500 => B
4   1        200 => C
5   3        700 => B

A =>COUNT: 2 AMOUNT: 450
B =>COUNT: 5 AMOUNT: 1200
C =>COUNT: 1 AMOUNT: 200

Re: homogeneous distribution

Norman21 — Sat, 30 Apr 2016 09:30:03 GMT

Hi Isabel.

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

Re: homogeneous distribution

Reeza — Sat, 30 Apr 2016 11:08:03 GMT

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.

Re: homogeneous distribution

Ksharp — Sat, 30 Apr 2016 12:37:43 GMT

Ou God. I understand something now. It is more like a SAS/OR problem. Is there any OBJECT function ? I believe there are lots of combination suited your requirement . Whether you want the minimize number of each GROUP or want the minimize difference of each GROUP ?