I was attempting to use the query builder to get a two column summary table that showed the first column as the Age Group for my observations, and the second column being the number of times each age group shows up in the data. Here was the code the query builder created: PROC SQL; CREATE TABLE WORK.QUERY_FOR_CUMULATIVE_W_AGEGROUP AS SELECT t1.AgeGroup, (Count(t1.AgeGroup)) AS COUNT_of_AgeGroup FROM WORK.CUMULATIVE_W_AGEGROUP t1 GROUP BY t1.AgeGroup; QUIT; But when I run this code, the counts aren't correct. I can't figure out what it is trying to count, but they add up to 1,000. I have over 2 million rows, and I checked the table it calls, and every row has an entry, so I'm not sure why the count is off. I was able to get at the information using the summary table tools, but this technique is going to be important for me to use in other calculations. Any thoughts on what's causing it not to work as expected?
... View more