insheet using employment_by_sector_1985_2016.csv, clear delimit("|")


keep if country=="Germany"

keep if unit=="Persons"
keep transact value year country

ren value ger
drop country

reshape wide ger, i(year) j(transact) string

save germany, replace