Hi there, I have a similar issue to aggregate my data file. I tried your code, but not apply to my data. I wonder if you can help me out as well. This is my data: COHORT_YEAR FG_Status Needy_Status Time2Degree LocalRace Gender count 2008 N N Not graduated American Indian or Alaska Nat F 1 2009 N N Within5Years American Indian or Alaska Nat M 1 2008 N Y 4YorLess American Indian or Alaska Nat F 1 2010 N Y 4YorLess American Indian or Alaska Nat M 1 2008 N Y 4YorLess American Indian or Alaska Nat F 1 2012 N Y 4YorLess American Indian or Alaska Nat M 1 2008 N Y 4YorLess American Indian or Alaska Nat F 1 2008 N Y 4YorLess American Indian or Alaska Nat M 1 I have 15000 cases and I need to sum/aggregate the Headcount variable given all the 6 categorical variables, which means the output data keeps the categorical variables, and can be used in Excel pivot tables. As I am learning SAS not for long and tried many ways, but none of them works for me. Hope that you can help me out. Thanks in advance. Xiaowen Qin
... View more