Hi,
I have a data set of a household survey with hhcode denoting the household code and migrant denoting a dummy variable 1 if the household has received remittance and 0 otherwise
I want all the migrant values to be 1 for similar hhcode corresponding code.
hhcode migrant
1102100101 1
1102100101 0
1102100101 0
1102100102 0
1102100102 0
1102100102 0
1102100102 0
1102100102 0
1102100102 0
1102100103 1
1102100103 0
1102100103 0
1102100103 0
1102100103 0
1102100104 0
1102100104 0
I want the data to be this way:
hhcode migrant
1102100101 1
1102100101 1
1102100101 1
1102100102 0
1102100102 0
1102100102 0
1102100102 0
1102100102 0
1102100102 0
1102100103 1
1102100103 1
1102100103 1
1102100103 1
1102100103 1
1102100104 0
1102100104 0
Related Posts with Expanding an observation to various rows
Trouble adding statistic to esttab latex tableHello all. I am trying to add additional statistics to a latex table using the user-written command …
Citing a methodological strategy found in a Statalist thread?Dear Statalist users, A few months ago I came across a discussion of a methodological strategy in o…
graph fixed aspect rationHi, When I add a left-title (l1title) to my graph, the plot stretches in. Are there any options to p…
reshape of nested dataDear all, I tried to reshape the following nested data into long-year wide-series: Code: * Exampl…
Stata Regression Help Using Fixed Effects and Cluster of Standard ErrorsHi all, I am looking to create a regression to determine the relationship between large increases i…
Subscribe to:
Post Comments (Atom)
0 Response to Expanding an observation to various rows
Post a Comment