This paper will describe the transition from the small, simple data sets of college to the more complex world of government data sets with billions and billions of bytes (pronounce ala Carl Sagan). Simple tricks in the DATA step and some PROC’s will be seen to translate into juicy treats in PROC SQL. PROC SQL topics will include the basics of SELECT, the use of DISTINCT, the WHERE clause, the ORDER BY clause, the GROUP BY clause, and JOIN’s. PROC SQL topics will be introduced from the standpoint of non-PROC SQL tools including the DATA Step, MERGE, PROC SORT, PROC PRINT, and PROC MEANS. Seeing how basic forms of PROC SQL statements map to other aspects of SAS will offer beginning SAS users a quick, alternate path to understanding SQL. Resources for learning SQL will be addressed, and some considerations of working with large data sets will be touched on.
Paper:
conference:
Paper Type:
Paper
