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
From string date "DD/MM/YYYY" to month and year variablesHi, How can I convert strings like "01/03/1997", e.i. of type "DD/MM/YYYY", to a new numeric variab…
Pseudo R² for meqrlogit using mi estimateHey, I found the following code in this forum to get the pseudo R² for imputed data: Code: local …
Log-rank testHi All, Can I please request some advice on the following. I have produced a Kaplan Meier Curve loo…
Can I use the Heckman model?Dear Statalist, I'm encountering problem using the Heckman two stage model. My data is about invest…
Different models for different hypotheses?Dear all, I have been testing the hypotheses for my master thesis and I have run into a problem. For…
Subscribe to:
Post Comments (Atom)
0 Response to Creating a large Dummy Variable table
Post a Comment