Dear all,

I am working with several csv. file each having a size between 700 MB to 2 GIG. I need to do some commands on each file and save them separately, otherwise the size would we even more huge and Stata crashes on my laptop, then I cannot see any results. So I look to append these results but I want to only save them in a single dta file. Here's is my code:
Code:
    global path "E:/Comtradet1"
    cd "$path"    
    foreach file of local datafiles {
        import delimited "`file'" , clear
        
       some commands
        
        save "$path/`file'.dta", replace

    }
I'm not sure if my save command has the correct format. I could not get any result from running the code above because Stata keeps adding observations and loading stuff and then stops responding. I tried this only with one csv file in my directory so that I can check the code and see if it works and I hoped it would be fast. But there's something that slows it down and I can't figure what. I even checked if the data is only imported and that alone also cannot be done. Please tell me if I wrote the code properly.
Additionally, since this is also a problem of large data I would appreciate your suggestions about how to handle such a situation. The code works when I don't use a loop and simply import one csv file and do the commands on it and save it. But that's just too manual. I look for more automation and that's why I tried the loop above.

Looking forward to your solutions,
Shadi