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
Fuzzy RD PlotI am using the following code for my Fuzzy RDD analysis: Y=outcome variable R=Running variable rela…
identifying random slope by groupHi all, I have a multilevel logistic model (using melogit in Stata 15.1) written as: Code: melog…
ebalfit: New command for entropy balancingA new command for entropy balancing is now available from SSC. Type Code: . ssc install ebalfit to…
Omitted dummy variable because of collinearityDear community I am running a panel data with fixed effects. The model I'm applying is a partial ad…
Collapsing two variables that occur multiple timesHi StataList, I'm attempting to collapse two variables, "from_gstin" and "to_gstin", into a form wh…
Subscribe to:
Post Comments (Atom)
0 Response to Creating a large Dummy Variable table
Post a Comment