I am an sql user trying to learn SAS and would appreciate it if anyone would help me with this query.
The following code I expected only to bring back the unique dates and there counts.... but running this in SAS returned a record for every observation with the year and count.
proc sql;
select year(change_date),count(*)
from customer_table
group by year(change_date);
quit;
Example result:
Year Count
2009 10000
2009 10000
2009 10000
2009 10000
...
...
What would be the correct way to write this query?
Cheers.
... View more
