JulianJohannesen
New Member
- Joined
- May 28, 2015
- Messages
- 1
Hello all,
I have about 29,000 records with all sorts of demographic data for individuals. These records each belong to one of 13 states or counties, 5 ethnic categories and 3 age categories. I want to assign a specific weight to each record in a category. I have my list of 13x5x3 = 195 weights. How can can assign those weights to my records without performing 195 copy and paste operations and then copying that weight factor down for the number of records in each of those categories?
<tbody>
</tbody>
I have about 29,000 records with all sorts of demographic data for individuals. These records each belong to one of 13 states or counties, 5 ethnic categories and 3 age categories. I want to assign a specific weight to each record in a category. I have my list of 13x5x3 = 195 weights. How can can assign those weights to my records without performing 195 copy and paste operations and then copying that weight factor down for the number of records in each of those categories?
A unique weight goes with each category | |||
State | Race | Age | Weight |
AZ | asian | 18-29 | weight1 |
AZ | asian | 30-59 | weight2 |
AZ | asian | 60+ | weight3 |
AZ | black | 18-29 | weight4 |
AZ | black | 30-59 | weight5 |
AZ | black | 60+ | weight6 |
AZ | caucasian | 18-29 | weight7 |
AZ | caucasian | 30-59 | weight8 |
AZ | caucasian | 60+ | weight9 |
… etc | |||
Actual data without weight included | |||
State | Race | Age | Weight |
AZ | asian | 18-29 | |
AZ | asian | 18-29 | |
AZ | asian | 18-29 | |
AZ | asian | 18-29 | |
AZ | asian | 18-29 | |
AZ | asian | 18-29 | |
AZ | asian | 30-59 | |
AZ | asian | 30-60 | |
AZ | asian | 30-61 | |
AZ | asian | 30-62 | |
AZ | asian | 30-63 | |
AZ | asian | 30-64 | |
AZ | asian | 30-65 | |
AZ | asian | 30-66 | |
… and so on for thousands of records |
<tbody>
</tbody>