I am trying to run the codes of two separate do files, combining them into the same do files. Each do file is taking data from different file directories. If I can get both codes to once, I will then combine data and variables before running a regression

The codes for the two do files I am trying to combine are:

clear all
cd "G:\Shared drives\SE475 Capstone, Dennis Evans\State Data - Last 5 Years"
foreach num of numlist 1 / 51 {
import delimited `num'.csv, clear
rename v1 week
rename v2 interest
gen state = `num'
save S`num'.dta, replace
}


use S1.dta, clear
foreach num of numlist 2 / 51 {
append using S`num'.dta
}

save search_data.dta, replace


use search_data.dta

gen weekly_date = date(week, "MDY")
format weekly_date %td

drop week

collapse interest, by(state weekly_date)

sort weekly_date state

rename state statenum

browse

------------------------------------------------

clear all
cd "G:\Shared drives\SE475 Capstone, Dennis Evans\COVID Infection Rate Data"
foreach num of numlist 1 / 51 {
import delimited `num'.csv, clear
gen statenum = `num'
save Covid`num'.dta, replace
}


use Covid1.dta, clear
foreach num of numlist 2 / 51 {
append using Covid`num'.dta
}

gen weekly_date = date(date, "MDY")
format weekly_date %td


qui gen dow = dow(weekly_date)
qui gen week_no = wofd( weekly_date)
qui gen temp = date if dow == 0
by week_no, sort: egen week_var = mode(temp)


collapse totalcaserateper100k, by(week_var statenum)

gen weekly_date = date(week_var, "MDY")
format weekly_date %td
sort weekly_date statenum
drop week_var

order weekly_date, before(totalcaserateper100k)

save covid_data.dta, replace

*use covid_data.dta

*xtset statenum weekly_date

browse