Hello, Using this example, could someone help me figure out how to calculate and add back the sum of 'count' by child and year. In other words, how do we add a column to the table where the sum of 'count' is calculated and repeated for every row with the same combination of 'child' and 'year' values. I'm a new SAS user so please keep it simple! data child; infile datalines dsd truncover; input child:32. year:32. Age:32. count:32. wage:32.; datalines; 0 2017 25 100 12.5 0 2017 30 20 20.4 0 2017 38 60 15 0 2018 22 40 12.5 0 2018 28 80 10.5 0 2017 37 10 15 1 2017 40 40 12.5 1 2017 28 80 10.5 1 2017 35 10 15 1 2018 44 40 12.5 1 2018 22 50 10.5 1 2018 37 10 15 ;
... View more
