I have interviewed heads of households and asked their fathers' names. In some cases the father is alive and has also been interviewed. In some cases he is not. I need to identify whether the father of a certain interviewee has also been interviewed.
I would need something like:
gen Father_Interviewed=find("Father") into name
For instance: find("Metlick Elly") into name.
I know that I could use the command strpos to identify whether a specific string is included in a string variable:
gen Father_MetlickElly_Interviewed = strpos(name,"Metlick Elly")
But I need a function that inputs the father's name automatically.
Thank you very much!
(Incidentally, in the above use of strpos, for some unexplicable reasons the new var is generated only for some names of the new variables but not others).
gianluca
+------------------------------------+
| name Father |
|------------------------------------|
14. | Kepas Metlick Metlick Elly |
36. | Daniel Raoh SAM JARAH |
40. | Metlick Elly Old Elly |
67. | Torohin Pilus THOMAS HAMUN BAREA |
72. | Joseph Raoh Daniel Raoh |
|------------------------------------|
73. | Philimon Hona Daniel Raoh |
74. | Wilfred Hotei Daniel Raoh |
75. | Biloli Raoh Daniel Raoh |
76. | Goldie Ragu Daniel Raoh |
92. | Simon Torohin Torohin Pilus |
+------------------------------------+
.
Related Posts with Searching for variable string content into another string variable
Is there a STATA command to create clusters which are homogenous between them? (inter-cluster homogeneity)I'm currently facing an issue in Stata. So, I kindly ask you, if you can help me. The problem is: I…
Please help! Quadratic Curves Inverting WRONGLY!Dear all, I use Stata16 and I humbly seek help. I have 2 cases where the parabolic curves are inver…
How to drop date row from datasetI had a dataset which didn't contain month or year columns (I imported monthly spss file with no dat…
Foreach invalid syntaxI am new to stata and keep getting 'invalid syntax' for the following commad: foreach diagnosis bre…
How to do a Pareto ChartHi, I need to do a Pareto chart in his original form, not in the modified version implemented with p…
Subscribe to:
Post Comments (Atom)
0 Response to Searching for variable string content into another string variable
Post a Comment