PROC SQL by Example: Using SQL within SAS

PROC SQL by Example: Using SQL within SAS

Howard Schreier

In PROC SQL by means of instance: utilizing SQL inside SAS, writer Howard Schreier illustrates using PROC SQL within the context of the SAS information step and different SAS strategies (such as type, FREQ, capacity, precis, APPEND, DATASETS, and TRANSPOSE) whose performance overlaps and enhances that of SQL.

utilizing a side-by-side technique, this concise reference consultant comprises many widely defined examples exhibiting an identical information step and SQL code, permitting SAS clients to exploit current SAS talents and information whereas studying approximately SQL. Discussions hide the variations among SQL and the knowledge step in addition to events the place SQL and the information step are used jointly to profit from the strengths of every.

themes addressed comprise operating with joins and merges; utilizing subqueries; figuring out set operators; utilizing the Macro Facility with PROC SQL; holding tables; operating with perspectives; utilizing PROC SQL as a document generator; and extra.

this article is perfect for SAS programmers looking to upload PROC SQL to their SAS toolkits in addition to SQL programmers striving to raised combine the SAS info step and SQL.

Show sample text content

Download sample