Hi there,
I am trying to import 75 csv files each containing daily company data for 18 months, when I run the script I get an error message saying "using required". Any help would be appreciated, here is the script:
. global MY_PATH "C:\Users\pmauder\Work Folders\Documents"
. local files : dir "$MY_PATH\csv" files "*.csv"
. cd "$MY_PATH\csv"
C:\Users\patrick\Work Folders\Documents\csv
. foreach file in `files' {
2. import delimited `file', clear
3. gen security_id = upper(substr("`file'",1,3))
4. gen date_new = date(date, "YMD")
5. replace date_new = date(date,"DMY") if date_new==.
6. replace date_new = date(date,"MDY") if date_new==.
7. format date_new %td
8. drop date
9. rename date_new date
10. recast float px_open
11. recast float px_high
12. recast float px_low
13. recast float px_last
14. rename px_open open
15. rename px_high high
16. rename px_low low
17. rename px_last close
18. keep security_id date open high low close
19. drop if date < date("20160601","YMD")
20. save temp, replace
21. use "$MY_PATH\csv\security_returns_file", clear
22. append using temp
23. save, replace
24. }
using required
r(100);
Thanks,
Patrick
Stata/MP 14.2
I am trying to import 75 csv files each containing daily company data for 18 months, when I run the script I get an error message saying "using required". Any help would be appreciated, here is the script:
. global MY_PATH "C:\Users\pmauder\Work Folders\Documents"
. local files : dir "$MY_PATH\csv" files "*.csv"
. cd "$MY_PATH\csv"
C:\Users\patrick\Work Folders\Documents\csv
. foreach file in `files' {
2. import delimited `file', clear
3. gen security_id = upper(substr("`file'",1,3))
4. gen date_new = date(date, "YMD")
5. replace date_new = date(date,"DMY") if date_new==.
6. replace date_new = date(date,"MDY") if date_new==.
7. format date_new %td
8. drop date
9. rename date_new date
10. recast float px_open
11. recast float px_high
12. recast float px_low
13. recast float px_last
14. rename px_open open
15. rename px_high high
16. rename px_low low
17. rename px_last close
18. keep security_id date open high low close
19. drop if date < date("20160601","YMD")
20. save temp, replace
21. use "$MY_PATH\csv\security_returns_file", clear
22. append using temp
23. save, replace
24. }
using required
r(100);
Thanks,
Patrick
Stata/MP 14.2
Comment