Transcription of Advanced Subqueries In PROC SQL
{{id}} {{{paragraph}}}
1 Advanced Subqueries In PROC SQLS teve First2997 Yarmouth Greenway Drive, Madison, WI 53711 Phone: (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 Tables4 TerminologyThe 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
1 Advanced Subqueries In PROC SQL Steve First 2997 Yarmouth Greenway Drive, Madison, WI 53711 Phone: (608) 278-9964 • Web: www.sys-seminar.com
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}