insheet using res.csv
sum
sum, detail
tabstat greenres, statistics(p25 median p75)
tabstat redres, statistics(p25 median p75)
tabstat whiteres, statistics(p25 median p75)
tabstat pinkres, statistics(p25 median p75)
gen greenloss = 0
gen redloss = 0
gen whiteloss = 0
replace greenloss=1 if greenres<1000
replace redloss=1 if redres<1000
replace whiteloss=1 if whiteres<1000
sum greenloss redloss whiteloss