Describes the basics of using PROC SQL, including retrieving data from single and multiple tables; selecting specific data from tables; subsetting, ordering, and summarizing data; updating tables; combining tables to create new tables and useful reports; performing queries on database management system (DBMS) tables; using PROC SQL with the SAS macro facility; and debugging and optimizing PROC SQL code.
Explains how to design reports with PROC REPORT based on your output from the SQL Query Window. Covers basic query concepts, how to perform queries on single and multiple tables, how to use advanced SQL Query Window features, and how to customize the SQL Query Window environment....
Explains the steps for moving SAS files across operating environments. Strategies include the Cross-Environment Data Access feature of directory-based operating environments, the CPORT and CIMPORT procedures, the XPORT engine with the DATA step or COPY procedure, and the XML engine with the DATA step or the COPY procedure....