Transcription of Advanced Subqueries In PROC SQL
{{id}} {{{paragraph}}}
Example: air traffic controller
Advanced Subqueries In PROC SQL
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 WI3 SARAH S 6 MN4 PAT H 4 IL5 JOHN H 7 WI6 WILLIAM H 11 MN7
3 Review of PROC SQL Basics • Introduction / Features • The SELECT Statement • Writing reports using SQL • Creating a SAS dataset • Joining Tables
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
Introduction to Using PROC SQL, Removing Duplicates Using SAS, Using PROC, PROC, Using the Magical Keyword 'INTO:' in, Using the Magical Keyword "INTO:" in PROC SQL, Proc SQL, Using the COMPUTE Block in PROC REPORT, Become Really Productive, Data Normalization for Dummies Using SAS, A Primer for SAS Programmers, Structured Query Language