Hello, I'm sorry if the question is phrased weird but I am trying to create a new dataset using line data by grouping by two variables. An example of my current dataset: data WORK.STUDENTS; infile datalines delimiter=','; input studentid schoolname $ grade gender $ poverty ; datalines; 1,WMS,6,F,Y 2,WMS,5,F,N 3,WMS,5,M,Y 4,EH,11,M,N 5,EH,12,F,N 6,EH,12,M,N 7,EH,12,F,N 8,SE,3,M,N 9,SE,3,F,N 10,SE,3,M,Y ; run; Instead of line counts, I would like the final dataset to include school headcounts for each grade, broken down by gender and poverty status. How can I do this?
... View more