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
Heteroskedastic standard errorsHello! Quick question regarding standard errors. I am running simple wage regressions to see if the…
Comparing incidence counts between countriesDear all I have a very simple dataset with three variables. Each observation is the report of one o…
Filling in missing values after summing values within a subgroupI have a large data set of medical encounters prior to a surgical date. The data is in long form wit…
Strange error when running stcrregHi all, I have been running a competing risk regression for my study. I carried out the analyses us…
Robustness - checking different samplesHello! I am using Stata16 and I am running simple wage regressions and decomposing the gender wage …
Subscribe to:
Post Comments (Atom)
0 Response to Creating a large Dummy Variable table
Post a Comment