Hello,
I have a large number of datasets that have very long filenames but each have a unique string within the filename (in this instance "country"). The files are not mine so I cannot change the names of the files, but would like to read in all the files into Stata based on a part of the filename, for example a file name could be:
"file 1 project 102 temporary data sweden individualpatientdata.dta"
or
"file 8 project 103 temporary data norway individualpatientdata.dta"
Now, could I use the string part that is based on country to read in the dataset? Obviously, the following wouldn't work:
.use "$data/*sweden*.dta , clear
.use "$data/*norway*.dta , clear
but that is essentially what I would like to do. All the files sit on separate drive (F) so I could store the file names in a local like this,
.local myfiles: dir "F:/" files "*.dta"
but then I do not know how to continue.
Any help would be much appreciated!
Thanks,
Raoul
I have a large number of datasets that have very long filenames but each have a unique string within the filename (in this instance "country"). The files are not mine so I cannot change the names of the files, but would like to read in all the files into Stata based on a part of the filename, for example a file name could be:
"file 1 project 102 temporary data sweden individualpatientdata.dta"
or
"file 8 project 103 temporary data norway individualpatientdata.dta"
Now, could I use the string part that is based on country to read in the dataset? Obviously, the following wouldn't work:
.use "$data/*sweden*.dta , clear
.use "$data/*norway*.dta , clear
but that is essentially what I would like to do. All the files sit on separate drive (F) so I could store the file names in a local like this,
.local myfiles: dir "F:/" files "*.dta"
but then I do not know how to continue.
Any help would be much appreciated!
Thanks,
Raoul
Comment