Appending multiple files with a loop

[Alessandro Fusari]

I need to append multiple files. This is what I have:

foreach i in ENTRATE USCITE {
2. use tempfile entrate_o_uscite
3. forvalues y=2010/2022 {
4. append "$base\data\\`i'_`y'.dta"
5. collapse (sum) IMP_`i'_ATT, by(x)
6. }
7. save "$base\SIOPE\intermediate\\`i'.dta", replace
8. }

The result is:

invalid 'entrate_o_uscite'

How do I fix this?

[Andrew Musau]

If you save a tempfile

tempfile entrate_o_uscite
save `entrate_o_uscite'

you refer to it subsequently as

use `entrate_o_uscite', clear

[Jared Greathouse]

I use some variant of this code to accomplish this, whenever I have to do this