Good afternoon,
I am working with a dataset that looks at different funding structures for subsidized housing. Each building is coded as an observation in the dataset, and that particular building may be funded by two or more different programs. For example, one building may be funded by both Section 8 and Public Housing. Through this dataset, I am trying to identify the frequency of these overlaps, essentially creating a table that counts how many 1's are shared amongst each combination of two different program types. For example, this may mean there are 510 total buildings funded by the combination of Section 8 and Public Housing and 210 funded by the combination of Section 8 and Section 202.
The database I have looks like this (and the missing can easily be replaced by a 0).
input float(overlap236 overlapstate overlap202 overlap515 overlap514 overlap521 overlap538 overlap8 overlaplihtc overlaphome overlappublichousing overlapother overlap8_811 overlap8_202 overlappbv overlapmodrehab)
. . . . . . . 1 1 . . . . . . .
. . . . . . . 1 1 . . . . . . .
. . . . . . . 1 1 . . . . . . .
. . . . . . . 1 1 . . . . 1 . .
. . . . . . . 1 1 . . . 1 . . .
. . . . . . . 1 1 . . . . 1 . .
. . . . . . . 1 1 . . . . . . .
. . . . . . . 1 . 1 . . . 1 . .
. . . . . . . 1 . 1 . . . . . .
. . . . . . . 1 1 . . . . 1 . .
Thank you very much for your help.
-Damon
Related Posts with Creating a large Dummy Variable table
Difference between margins and predictHi guys, I just noticed something weird and wanted your opinion, I'm probably misunderstanding how …
Z-Transformation for Population DataIn Excel you can do the calculation of the standard deviation in two different ways in order to perf…
Help interpreting the hazard ratio of a variable with positive and negative values in a Cox regression modelHi Statalist. I created a variable that measures 'Age Difference by Gender' within male and female …
How to choose between different regression modelsHello, One of the dependent variables for one of my statistical tests, 'distvol' is a variable meas…
Managing string variablesHi STATALIST, Could you please advice me how I can produce var3 from var2: var1 is group IDs. Cod…
Subscribe to:
Post Comments (Atom)
0 Response to Creating a large Dummy Variable table
Post a Comment