SAS has powerful features for reading data out of text files (such as CSV, TSV, datalines, and various other formats), but while reading text, you may find your data set is missing rows and the log has this non-intuitive error message (well, “not…
Tag: quirks
SAS: “The query requires remerging summary statistics back with the original data”
by Heuristic Andrew • • Comments Off on SAS: “The query requires remerging summary statistics back with the original data”
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 sq…