hi
I am new to sas but need to do the following:
my data (this is just dummy data, the full set contains 25 million obs)
phone number | HV Customer | Region | Age | Port in | pmt method | spend bucket |
---|
0832122256 | High Value | Gauteng | 25 | yes | Prepaid | R120 to R155 |
0833132424 | Low Value | Gauteng | 26 | yes | postpaid | R0 to R50 |
0834532675 | Very high Value | KZN | 12 | yes | postpaid | R180 to R230 |
0854217863 | Mid Value | Limpopo | 20 | no | prepaid | R260 to R300 |
Create a random sample which consists of the following:
- 100 people should reflect a prepaid pmt method
- 25 people should be high or very high value customers (should be split between prepaid and postpaid pmt method)
- the region should comprise of 40% gauteng and the rest shoul be equally divided
- the age should be 26 and older
- 30 of the people should have ported in (yes)
- spend should be above R120
any idea as to how to go about tackling this problem