Loop & macro for replace

[Ofelia Restrepo]

Hi!

I am just learning about loops, and I am trying to create a loop for this code:

replace FinalConcept_Q200_1r1c1=FinalConcept_Q1_1r1c1 if study_type==0
replace FinalConcept_Q200_1r1c2=FinalConcept_Q1_1r1c2 if study_type==0

replace FinalConcept_Q200_1r2c1=FinalConcept_Q1_1r2c1 if study_type==0
replace FinalConcept_Q200_1r2c2=FinalConcept_Q1_1r2c2 if study_type==0

replace FinalConcept_Q200_1r3c1=FinalConcept_Q1_1r3c1 if study_type==0
replace FinalConcept_Q200_1r3c2=FinalConcept_Q1_1r3c2 if study_type==0

replace FinalConcept_Q200_1r4c1=FinalConcept_Q1_1r4c1 if study_type==0
replace FinalConcept_Q200_1r4c2=FinalConcept_Q1_1r4c2 if study_type==0

replace FinalConcept_Q200_1r5c1=FinalConcept_Q1_1r5c1 if study_type==0
replace FinalConcept_Q200_1r5c2=FinalConcept_Q1_1r5c2 if study_type==0

replace FinalConcept_Q200_1r6c1=FinalConcept_Q1_1r6c1 if study_type==0
replace FinalConcept_Q200_1r6c2=FinalConcept_Q1_1r6c2 if study_type==0

I'm trying the following, but it's not working:

global listQ2001 FinalConcept_Q200_1r1c1 FinalConcept_Q200_1r1c2 FinalConcept_Q200_1r2c1 FinalConcept_Q200_1r2c2 FinalConcept_Q200_1r3c1 FinalConcept_Q200_1r3c2 FinalConcept_Q200_1r4c1 FinalConcept_Q200_1r4c2 FinalConcept_Q200_1r5c1 FinalConcept_Q200_1r5c2 FinalConcept_Q200_1r6c1 FinalConcept_Q200_1r6c2 FinalConcept_Q200_1r7c1 FinalConcept_Q200_1r7c2

foreach FinalConcept_Q200_1r of varlist $listQ2001 {
replace `FinalConcept_Q200_1r' = FinalConcept_Q1_1r if study_type==0
}

I think my problem has more to do with the macro definition.

I would appreciate your help very much!

Best,

Ofelia

[Joro Kolev]

Try

foreach var of varlist FinalConcept_Q200_1r1c1 FinalConcept_Q200_1r1c2 FinalConcept_Q200_1r2c1 FinalConcept_Q200_1r2c2 FinalConcept_Q200_1r3c1 FinalConcept_Q200_1r3c2 FinalConcept_Q200_1r4c1 FinalConcept_Q200_1r4c2 FinalConcept_Q200_1r5c1 FinalConcept_Q200_1r5c2 FinalConcept_Q200_1r6c1 FinalConcept_Q200_1r6c2 FinalConcept_Q200_1r7c1 FinalConcept_Q200_1r7c2 {
replace `var' = FinalConcept_Q1_1r if study_type==0
}

[Hemanshu Kumar]

Maybe this:

forvalues i = 1/7 {
    forvalues j = 1/2 { 
        replace FinalConcept_Q_200_1r`i'c`j' = FinalConcept_Q1_1r`i'c`j' if study_type == 0
    }
}