double looping using forvalue

[Melat Kassa]

I wanted to import spss files into stata. The format of the file is month_date_raw_data.sav. For example "1_2020_raw_data.sav" I tried to write a loop to call in each month and year but I keep getting an error r(601). Why isn't this loop working?

forvalues i= 2020/2021 {
   forvalues j=1/12 {
  import spss using "C:\Users\bf\files\spss\`j'_`i'_raw_data.sav" , case(lower) clear
    
  *Add year and month variable 
   gen year= `j'
   gen month=`i'
   tempfile part_`i'`j'
   save `part_`i''`j'
}
 }

[Justin Niakamal]

You have an extra '

Should work if you substitute in

save `part_`i'`j''

[Melat Kassa]

Thanks but that's not where my code breaks. It gives me this error:

file C:\Users\bf\files\spss`j'_2020_raw_data.sav not found

The file 1_2020_raw_data.sav exists and if I switch the i and j position, I get the same error. It doesn't seem to recognize the first loop.

[Nick Cox]

You switch year and month from outside the loop to inside.