How to import multiple csv file using loop

[Wenhan Yan]

So I am having following datasets, and want to import them in a loop, and then save because their name is in sequnce, and for each dataset contain same variables:
1990 marriage records.csv
1991 marriage records.csv
...
2018 marriage records.csv

May I ask what is wrong with following code:

clear all
 
*change directory to orginal data folder
cd "..."

for each num of numlist 1990/2017{

    import "`num' marriage records.csv"

    *change directoty to save data folder
   cd "..."

   save nc`num'
   clear

}

[Ali Atia]

Should be:

import delimited "`num' marriage records.csv"

Also, you will encounter trouble after the first iteration because you don't change back to the import directory. You should either add a cd "..." to return to the original data directory at the start of the loop or reference the file by its full path, as in "C:/.../`num' marriage records.csv" (assuming you use Windows).

[Wenhan Yan]

Should be:

import delimited "`num' marriage records.csv"

Also, you will encounter trouble after the first iteration because you don't change back to the import directory. You should either add a cd "..." to return to the original data directory at the start of the loop or reference the file by its full path, as in "C:/.../`num' marriage records.csv" (assuming you use Windows).

Thank you, but I am still having trouble with it, the error said

is not a valid command name.

Here is my revised code:

clear all

foreach num,of numlist 1990/1995{
    
    clear

    

    cd "...original..."
    
    

    import delimited "`num' marriage records.csv"

    

    cd"...save..."
    




}

[Ali Atia]

Seems like you have some invisible characters in the code which are causing issues (as well as a misplaced comma in your loop). Try copy-pasting this exactly, changing the relevant paths:

clear all
foreach num of numlist 1990/1995{
    clear
    cd "original"
    import delimited "`num' marriage records.csv"
    cd "save"
    save nc`num'
}