Dear Statalist Users,

I have multiple txt files and I want to convert them into stata files so that I can append the data.

This is the manual way of importing the data and then saving it for stata.

import delimited "C:\Dir\Manu - 00-01.txt", delimiter("|") varnames(2)
rename v1 company
rename v2 product
save manu_00-01

However, I have 20 text files in the form of Manu - 00-01.txt, Manu - 00-02.txt, Manu - 00-03.txt and so on till Manu - 18-19.txt.

I seek you suggestion on writing a loop for the same so that I can append it accordingly

Thank you