Hi, I have a variable which has been coded differently in two datasets. (old one for year 2000 and new one for year 2005 )
Old codes are { 2 4 5 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 3 28 29 31 6 32 17 33 30 }
New codes are { 28 18 10 24 6 2 1 29 32 23 27 14 17 13 21 3 8 11 33 16 9 19 35 12 4 26 7 30 31 15 34 25}
So, for example, the variable (lets call it state) was taking a value 2 earlier but in the new dataset that value corresponds to 28...... similarly 4 earlier and 18 now and so on
both the datasets have been appended with a variable called year taking value 2000 for old dataset and 2005 for new dataset.
How do I write a loop to convert the old codes for variable state to new one for the year 2000 so that the variable state can be made compatible across years ?
Related Posts with Loops to make variables compatible
Drop certain observation if certain criteria meets a condition (Panel data)Hello! I have a panel data which consists from the year 2010 to 2019 I want drop all the observatio…
save spssSomehow savespss is broken, random extra empty string variables are added to the file produced, like…
How to export CSV with multiine text dataI have a CSV file in which some of the columns contain multiline text data. See below. Sample file a…
Question Stata!!Hello, Do you have any idea of how can I create a variable that is equal to the nº of years a perso…
Quadrivariate probit with endogenous dummy variable in the covariatesI am trying to identify the role played by marijuana in the consumption of hard drugs (cocaine, meth…
Subscribe to:
Post Comments (Atom)
0 Response to Loops to make variables compatible
Post a Comment