Dear all,
I have a long occupational dataset with several rows of observations for each person representing different jobs they have worked over their lifetime. Each person is identified with a unique ID number.
I have start year and finish year variables for each job, but I need to create start month and finish month variables to get a more specific exposure duration.
I have decided that depending on the start and finish years of each consecutive job, the start month will be assigned as either June/January, and the finish month assigned as July/December.
The rules are as follows:
- If the finish year of the previous job is the same as the start year of the subsequent job, the stop/start months for those jobs will be assigned as June/July.
- If the finish year of the previous job is the year before the start year of the next job, the stop/start months for those jobs will be assigned as December/January.
I am trying to write some code in STATA.
I have tried to create a loop to make the code run through each unique ID number, and then run through each individual row for that ID number. However, it currently doesn´t work and I am not sure how to write the "if" command to assign the correct start/finish months from the multiple rows of data.
Any help would be greatly appreciated!
Related Posts with Stata Loops
Merge two files but the variables are related to each other and not uniquely identifiedDear Statalist, I would like to merge two files. My data is about the posts and comments of an onli…
Regression on whether change in a variable is affected by another variable over timeI have data sets for 6 years that have two categorial variables. One of the is race and one of them …
xtnbreg or nbreg/xtgee?Hi, I am trying to run a negative binomial population-average model in Stata 14. However, I am not s…
How to measure percentage certain observations in STATA?Let's say I have two categorical variables, one is colour and one is a number 1-10. How do I display…
Combining marginsplot with ifHi everyone, I was wondering if marginsplot can be combined with if statement to obtain marginsplot …
Subscribe to:
Post Comments (Atom)
0 Response to Stata Loops
Post a Comment