*New dataset, limited to 2019 and "all age groups"; Data est.estimates19; Set est.estimates (drop=state county stname); Where year=12 and AGEGRP=0; Total=sum(tot_male, tot_female); *Total population; white=sum(wa_male, wa_female); *White; black=sum(ba_male, ba_female); *Black; natam=sum(IA_MALE, IA_FEMALE); *Native American/Alaskan Native; asian=sum(AA_MALE, AA_FEMALE); *Asian; island=sum(NA_MALE, NA_FEMALE); *Native Hawaiian/Pacific Islander; multi=sum(TOM_MALE, TOM_FEMALE); *Multi/other; hispanic=sum(H_male, H_female); *Hispanic Ethnicity = 391,382; Non_hispanic=sum(NH_MALE, NH_FEMALE); *Non-Hispanic Ethnicity = 6,437,792; Run; I'm getting population estimates for county from a US Census datasets; I've had to sum the data together (male+female) to get totals for race/ethnicity. I need to group these individual summed variables to get something that looks like this (numbers just for example): Ultimately, my goal is to be able to output this an Excel file and be able to filter by Category (race/ethnicity) or by CAT_detail as needed. County Category CAT_Detail Population Sunnyville Race White 5,602,223 Sunnyville Ethnicity Non-Hispanic 7,56,010 Sunnyville Race Black 1,501,011 Sunnyville Race Native American/Alaskan Native 21,011 Sunnyville Ethnicty Hispanic 1,002,001
... View more