* Example of Merging State-Level Excel File to ACS Large Dataset
* Note: you will need to change the folder names

import excel "C:\Users\rfairlie\temp\teaching\e128\w2022\socdistancebystate.xlsx", sheet("Sheet1") firstrow clear
save "C:\Users\rfairlie\temp\teaching\e128\w2022\socdistancebystate.dta", replace

use "C:\Users\rfairlie\temp\teaching\e128\w2022\cpslarge.dta", clear
sort state
merge m:1 state using "C:\Users\rfairlie\temp\teaching\e128\w2022\socdistancebystate.dta"