Hello I am trying to loop across multiple variables to replace missing variables at earlier time points in a data set with the value of the variable at the last time point in a long file.
The code I have tried is below:
foreach var of varlist ra_inquire - ra_gpdoc___2) {
replace `var'(n+1) if missing(`var') & record_id == record_id
}
The error message: factor-variable and time-series operators not allowed
Thank you for helping me solve the looping code in this case.....
The code I have tried is below:
foreach var of varlist ra_inquire - ra_gpdoc___2) {
replace `var'(n+1) if missing(`var') & record_id == record_id
}
The error message: factor-variable and time-series operators not allowed
Thank you for helping me solve the looping code in this case.....
Code:
* Example generated by -dataex-. For more info, type help dataex clear input byte(ra_inquire ra_gpdose ra_fxstat ra_gpdoseq___1 ra_gpdoseq___2 ra_gpdoseq___3 ra_gpdoseq___4 ra_gpdoseq___5 ra_gpdoseq___6 ra_gpdoseq___7 ra_gpdoseq___8 ra_gpdoseqoth ra_gpdoc___1 ra_gpdoc___2) . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 1 1 0 1 0 1 0 1 0 . 1 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 1 1 0 0 0 0 1 0 0 . 0 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 1 1 1 1 1 1 1 1 0 . 1 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 1 1 0 0 1 0 1 1 0 . 1 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 1 1 0 1 1 1 0 1 0 . 1 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 1 1 0 0 1 1 1 1 0 . 1 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 1 0 1 0 1 1 0 0 0 . 1 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 1 0 0 0 0 1 0 1 0 . 0 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 1 0 0 0 0 0 1 1 0 . 0 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 0 1 0 0 1 1 0 0 0 . 1 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 1 1 1 1 1 1 1 1 0 . 1 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 1 1 0 1 1 1 1 1 0 . 1 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 1 1 0 1 1 1 1 0 0 . 1 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . end label values ra_inquire ra_inquire_ label def ra_inquire_ 1 "Yes", modify label values ra_gpdose ra_gpdose_ label def ra_gpdose_ 1 "Yes", modify label values ra_fxstat ra_fxstat_ label def ra_fxstat_ 0 "No", modify label def ra_fxstat_ 1 "Yes", modify label values ra_gpdoseq___1 ra_gpdoseq___1_ label def ra_gpdoseq___1_ 0 "Unchecked", modify label def ra_gpdoseq___1_ 1 "Checked", modify label values ra_gpdoseq___2 ra_gpdoseq___2_ label def ra_gpdoseq___2_ 0 "Unchecked", modify label def ra_gpdoseq___2_ 1 "Checked", modify label values ra_gpdoseq___3 ra_gpdoseq___3_ label def ra_gpdoseq___3_ 0 "Unchecked", modify label def ra_gpdoseq___3_ 1 "Checked", modify label values ra_gpdoseq___4 ra_gpdoseq___4_ label def ra_gpdoseq___4_ 0 "Unchecked", modify label def ra_gpdoseq___4_ 1 "Checked", modify label values ra_gpdoseq___5 ra_gpdoseq___5_ label def ra_gpdoseq___5_ 0 "Unchecked", modify label def ra_gpdoseq___5_ 1 "Checked", modify label values ra_gpdoseq___6 ra_gpdoseq___6_ label def ra_gpdoseq___6_ 0 "Unchecked", modify label def ra_gpdoseq___6_ 1 "Checked", modify label values ra_gpdoseq___7 ra_gpdoseq___7_ label def ra_gpdoseq___7_ 0 "Unchecked", modify label def ra_gpdoseq___7_ 1 "Checked", modify label values ra_gpdoseq___8 ra_gpdoseq___8_ label def ra_gpdoseq___8_ 0 "Unchecked", modify label values ra_gpdoc___1 ra_gpdoc___1_ label def ra_gpdoc___1_ 0 "Unchecked", modify label def ra_gpdoc___1_ 1 "Checked", modify label values ra_gpdoc___2 ra_gpdoc___2_ label def ra_gpdoc___2_ 0 "Unchecked", modify label def ra_gpdoc___2_ 1 "Checked", modify
Comment