* do-file for Supplementary Exercise 1.10 of IPS7e
version 18 /* works also with versions 13-17 */

import delimited "R:\Chapter 1\ex01_010.csv"
summarize count
* gives the mean only, multiply by n to get the sum
display 2049833*6
* note: some additional roundoff from using the mean!
* alternatively, use total command
total count, cformat(%9.0f)

graph bar count, over(ethnicity, label(angle(90)))
graph pie count, over(ethnicity) angle(90)