| Publisher | SAS Institute | ||
|---|---|---|---|
| Format | 69.8KB PDF | Date added | 28 Feb 2006 |
| Topics | Knowledge and Data Management, Database Management | ||
| Downloads | 36 | ||
Structured Query Language (PROC SQL) is a database language found in the base-SAS software. It enables access to data stored in SAS data sets or tables using a powerful assortment of statements, clauses, options, functions, and other language features. This paper presents core concepts of this powerful language as well as its many applications, and is intended for SAS users who desire an overview of the capabilities of this exciting procedure. The paper explores the construction of simple SQL queries, ordering and grouping data, the application of case logic for data reclassification, the creation and use of views, and the construction of simple inner and outer joins.
Did you find this white paper useful?
23 out of 50 users found this white paper useful
Related white papers
The Journey Along an Information-Led Transformation
A shift is underway from simple automation to business optimization, and information is at the center of it. Information, when aligned with your business strategy, holds the key to driving profitable...
The new information agenda:Do you have one?
The lack of trusted information — information that is accurate, timely and relevant— is on the minds of CEOs and senior executives around the world. a paradigm shift from siloed...
Best Practices for Translating Customer Satisfaction into Revenue
Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a...
Support Strategies: Customer Experience Management
Customer experience is the most powerful tool available today for distinguishing your company from competitors ? each contact with the customer offers an opportunity for strengthening your relationships by delivering...
3 Strategies for Reducing IT Support Costs
As companies brace for more bumps in the economic downturn, many organisations are indiscriminately cutting costs. To ensure a seamless transition into the post-recession market, however, slashing and burning is...
Forrester Strategies for Assessing IT Business Satisfaction
If you aren't assessing customer satisfaction you are overlooking a potential goldmine. This valuable data is crucial to creating a successful IT strategy. But where do you start? This new...
Realising the benefits of going green
Cross over to greener communications with improved data accuracy. Many organisations have processes in place to improve the quality of their contact data to address business drivers, such as cost reduction...
