Content

use census2c,clear
summarize pop*

list state pop in 1/5
list state pop medage if medage >= 32

encode state, generate(stateid)
describe state stateid
list state stateid in 1/5

// sort pop
// generate byte sizecat = group(3)

decode stateid, generate(statename)
list stateid statename in 1/5

generate size=irecode(pop, 1000, 4000, 8000, 20000)
label define popsize 0 "<1m" 1 "1-4m" 2 "4-8m" 3 ">8m"
label values size popsize
tabstat pop, stat(mean min max) by(size)

// tabstat pop, stat(mean min max) by(sizecat)
// list state pop if sizecat==1, sep(0)

generate byte newengland = inlist(state, "Connecticut", "Maine", ///
"Massachusetts", "New Hampshire", "Rhode Island", "Vermont")
sort medage
list state medage pop if newengland, sep(0)

list state medage pop if inrange(pop, 5000, 9999), sep(0)

generate medagebrack = recode(medage, 29, 30, 31, 32, 33)
tabulate medagebrack

generate medagebracknr = irecode(medage, 29, 30, 31, 32, 33)
tabulate medagebracknr

xtile medagequart = medage, nq(4)
tabstat medage, stat(n mean min max) by(medagequart)

// undocumented egen avgpop = mean(pop), by(size)
bysort size: egen avgpop = mean(pop)
generate popratio = 100 * pop / avgpop
format popratio %7.2f
list state pop avgpop popratio if size == 0, sep(0)

// tabulate size, generate(popsize)
// egen countcat = rcount(popsize*), cond(@==1)
// summarize countcat