SAS: “The query requires remerging summary statistics back with the original data”

This post was kindly contributed by Heuristic Andrew » sas - go there to comment and to read the full post.

Coming from a background writing SQL code directly for “real” RDBMS (Microsoft SQL Server, MySQL, and SQLite), I was initially confused when SAS would give me the following ‘note’ for a simple summary PROC SQL query: 429 proc sql; 430 create table undel_monthly as 431 select 432 year(date) as year, 433 month(date) as month, 434 […]

This post was kindly contributed by Heuristic Andrew » sas - go there to comment and to read the full post.