Proc SQL, the Data Step Killer

Proc SQL •SQL is the de facto standard query language, widely used (beyond SAS even!) for retrieving and summarizing data •Proc SQL can summarize results in the same step as performing row level calculations without Proc SQL, summarizing requires a separate proc summary step, and often a pre-sort •Proc SQL can sort its results in the same ...

  Language, Standards, Data, Step, Corps, Proc sql, Query, Data step, Standard query language