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
Random group generationDear Statalists, I would like to generate 67 random groups for 271 observations. I know the below c…
Issues with string variable that takes numeric values ('1', '2', ...)I read in a dataset that includes many columns of categorical variables denoted by '1', '2', ... 1)…
weak instrument problemHi, So im replicating a paper and they have used 3 main food prices as their instrumental variable. …
How to produce a predicted graph between dependent and independent variables, keeping all other variables constant?How to produce a predicted graph between a dependent and an independent variable (both continuous va…
Fixed & Random Effects with noisy ESG (sustainability) dataDear readers & contributers! I am completely new here, a master (Msc. Sustainable Finance) stud…
Subscribe to:
Post Comments (Atom)
0 Response to Creating a large Dummy Variable table
Post a Comment