Advanced Subqueries In PROC SQL

← Back to document page

1Advanced Subqueries In PROC SQLSteve First2997 Yarmouth Greenway Drive, Madison, WI 53711Phone: (608) 278-9964 Web: SQL;SELECT STATE,AVG(SALES) AS AVGSALESFROM USSALESGROUP BY STATEHAVING AVG(SALES) >(SELECT AVG(SALES)FROM USSALES);QUIT;STATE AVGSALES ---------------IL MI Subqueries In PROC SQLThis paper was written by Systems Seminar Consultants, specializes in SAS software and offers: SAS Training Services Consulting Services SAS Support Plans Newsletter Subscriptions to The Missing Semicolon COPYRIGHT 2009 Systems Seminar Consultants, ,storedinaretrievalsystem,ortransmitted, inanyformorbyanymeans,electronic,mechani cal,photocopying,orotherwise, , of proc sql Basics Introduction / Features The SELECT Statement Writing reports using SQL Creating a SAS dataset Joining Tables4TerminologyThe terminology in SQL is slightly different than in standard SAS, but the meaning is the dataset = tablevariable = columnobservation = rowName Division Years Sales Expense State1 CHRIS H 2 WI2 MARK H 5 WI3 SARAH S 6 MN4 PAT H 4 IL5 JOHN H 7 WI6 WILLIAM H 11 MN7 AND

3 Review of PROC SQL Basics • Introduction / Features • The SELECT Statement • Writing reports using SQL • Creating a SAS dataset • Joining Tables

  Using, Corps, Advanced, Proc sql, Advanced subqueries in proc sql, Subqueries, Using sql