import delimited and loop

[abdelilah arredouani]

Dear Statalisters,
i am trying to import 40 csv files into one dta file using import delimted and foreachloop. Each file has 2 variables, and they are the same variable for the 40 files. i run the code below, but it only imports one file. thanks in advance for your help

cd "/Users/aarredouani/Desktop/aa"
local list : dir "/Users/aarredouani/Desktop/aa" files "*.csv"
foreach f of local list {
import delimited "`f'"
save "`f'.dta", replace
append using "`f'.dta"

}

stata 15.1 mac

[Ali Atia]

Try adding the -clear- option to the import delimited command.

[abdelilah arredouani]

Many thanks but it not work

[Ali Atia]

cd "/Users/aarredouani/Desktop/aa"
local list : dir "/Users/aarredouani/Desktop/aa" files "*.csv"
foreach f of local list {
    import delimited "`f'", clear
    save "`f'.dta", replace
    local append `append' "`f'.dta"
}
clear
append using `append'