Hi,

I currently have data on recycling rates for different local authorities in the UK and would like to control for the method and frequency of collection. I currently have a set of dummy variables for method, that take the value 1 if that local authority takes that method of collection and zero if they do not, where there are 30 methods. I also have a set of dummy variables that take the value 1 if the local authority uses that method of collection and the frequency of collection is longer than once a week, zero if the frequency is weekly or more, and missing if the local authority does not use that method of collection.

What is the best way to build my regression and control for these factors. Ideally i want a coefficient for each method and a coefficient for frequency, which tells us the effect of frequency of the method being longer than once a week, even though not every Local authority takes each method.

Thank You

Darcy Hill

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str43 name float(dummyfrequency11 dummyfrequency12 dummyfrequency13) long(methoddummy11 methoddummy12 methoddummy13)
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Adur District Council"        0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Allerdale Borough Council"    0 0 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Amber Valley Borough Council" 1 1 . 1 1 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Arun District Council"        . . . 0 0 0
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 1 1 1 1
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 1 1 1 1
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 1 1 1 1
"Ashfield District Council"    1 1 1 1 1 1
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 . 1 1 0
"Ashfield District Council"    1 1 . 1 1 0
end