I am trying to use -zipuse- to use and append a number of files that are inside some zip folders contained in a specific directory. Each zip folder contains one .dta file and the name of the .dta files that are inside the zip folders are a random list of digits and characters (e.g. aa48229snfjka.dta). Before giving further details, I'd like to specify that I am using Stata 13 on Windows 10, and that both Stata and the operating system are up to date.
The code I have been trying to use is the following:
Code:
local sourcedir "C:/DocumentiRV/ERIM/research/writing/ownership characteristics and tax inversions/2020/data/shareholder information" local fls : dir "`sourcedir'" files "*people.zip", respectcase local flsC : dir "`sourcedir'" files "*companies.zip", respectcase tempfile people companies save `people', emptyok save `companies', emptyok foreach f of local fls { zipuse "`sourcedir'/`f'", clear append `people' save `people', replace } foreach fC of local flsC { zipuse "`sourcedir'/`fC'", clear drop annualreportdate rowtype duplicates drop append `companies' save `companies', replace } merge m:1 directorid using `people', nogen zipsave "`sourcedir'/BoardEx All"
Code:
----------------------------------------------------------------------- end zipuse._ok2use --- - tempfile tmpdat - if "`dtafile'" == "" { = if "" == "" { - shell unzip -p "`zipfile'" > `tmpdat' = shell unzip -p "C:/DocumentiRV/ERIM/research/writing/ownership characteristics and tax inversi > ons/2020/data/shareholder information/BoardEx Europe people.zip" > C:\Users\RICCAR~1\AppData\Loc > al\Temp\ST_02000003.tmp - } - else { shell unzip -p "`zipfile'" "`dtafile'" > `tmpdat' } - use `initlist' `usind' `tmpdat', clear `options' = use C:\Users\RICCAR~1\AppData\Local\Temp\ST_02000003.tmp, clear file C:\Users\RICCAR~1\AppData\Local\Temp\ST_02000003.tmp not Stata format if "`dtafile'" == "" { global S_FN = "`zipfile'" } else { global S_FN = "`dtafile'" } } --------------------------------------------------------------------------------- end zipuse ---
Code:
shell which zip
I hope someone can offer advice or a workaround to avoid using zipuse altogether.
0 Response to -zipuse- unable to recognize .dta files inside zip folders
Post a Comment