Transcription of Advanced Subqueries In PROC SQL - Welcome to …
{{id}} {{{paragraph}}}
Example: tourism industry
Advanced Subqueries In PROC SQL - Welcome to …
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 ANDREW S 24 MN8 BENJAMIN S 3
4 Terminology The terminology in SQL is slightly different than in standard SAS, but the meaning is the same. SAS SQL dataset = table
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
Language, SQL language, SQL Data Manipulation Language, SQL Facts SQL stands for Structured Query, SQL Facts SQL stands for Structured Query Language SQL, Language SQL, Without PROC SQL and, WITHOUT PROC SQL AND THE MACRO LANGUAGE, Manipulating Data with PROC SQL, MERGING vs. JOINING: Comparing the DATA Step, SAS SQL, 1 Stored Procedures in PL/SQL, ORACLE: A HOW-TO GUIDE FOR PL/SQL USERS