| Publisher | SAS Institute | ||
|---|---|---|---|
| Format | 69.8KB PDF | Date added | 28 Feb 2006 |
| Topics | Knowledge and Data Management, Database Management | ||
| Downloads | 35 | ||
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
IBM System x Enterprise Servers in the New Enterprise Data centre
Virtualization changes everything! Once you start to virtualize your servers and storage, you will find that you can enjoy a higher degree of server utilization and simpler, more comprehensive server management....
Systems Integration
Many compaines realise the market has changed, the competition is stronger, pressure is on and costs are increasing causing IT structures to change. Every company has it's own indivdual challenges...
Improving the Accuracy of Spend Analysis through Data Quality
Organisations can spend as much as 60 percent of revenue to acquire the goods and services necessary to conduct business. Procurement professionals are being asked to reduce the organisation's overall...
The ROI of Data Governance: Seven Ways Your Data Governance Program Can Help Save You Money
In difficult economic climates, responsible leaders look for opportunities to contain costs. Data governance programs are well positioned to assist in these efforts. This white paper from Gwen Thomas of...
Maximize the Business Value of Datacenters
"Combining the strengths of the quadcore Intel Xeon processor, the IBM eX4 technology, and VMware Infrastructure software, organizations can virtualize x86 servers to transform enterprise-class datacenters, making them more efficient, cost-effective,...
Enabling sustainable compliance management across the organization.
From industry regualtions to data privacy laws and government mandate, meeting compliances has become a permanent citerion for doing business. This white paper discusses the growing tide of data security...
Escaping PCI purgatory. Compliance roadblocks and stories of real-world successes
By now, any companies driving high volumes of credit card transactions that are not compliant with the payment card industry (PCI) data security standards (DSS) faces steep penalties. This white...
