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 = tableva

4 Terminology The terminology in SQL is slightly different than in standard SAS, but the meaning is the same. SAS SQL dataset = table

  Corps, Advanced, Advanced subqueries in proc sql, Subqueries