Closed BjarteAAGNES closed 2 years ago
version 17
log using NC_survival_entity_table.log , text
clear
local URL https://raw.githubusercontent.com/CancerRegistryOfNorway/NORDCAN/master/specifications/entity_usage_info.csv
insheet using "`URL'", delim(";")
isid entity
assert inlist(survival, "false", "true")
keep if survival == "true"
assert incidenceprevalence == "true"
assert mortality == "true"
drop incidenceprevalence mortality
compress
gen str3 entity_str = string(entity,"%03.0f")
assert !mi(entity_str)
tempfile entity_usage_info
sort entity
save "`entity_usage_info'"
import excel using "C:\Users\baa\Downloads\Entitet [Sykdomstilfelle].xlsx" , clear firstrow
gen str3 entity_str = string(real(value_code), "%03.0f")
keep entity_str description_en
isid entity_str
assert !mi(entity_str)
merge 1:1 entity_str using "`entity_usage_info'" , assert(master match)
list description_en if _merge == 1
drop if _merge == 1
drop _merge
merge 1:1 entity_str using "C:\Users\baa\Downloads\NC_survival_entity_table.dta" , assert(master match)
assert inlist(entity,105, 227, 400) if _merge == 1
drop _merge survival
order entity entity_str description_en
compress
sort entity
isid entity
datasignature set
save "NC_survival_entity_table.dta" , replace
log close