DOCUMENTATION
  • Software
    • Software
    • SAS Viya
    • Industries
    • Solutions
    • Products
  • Learn
    • Learn
    • Training
    • Certification
    • Academics
    • Books
    • Video Tutorials
  • Support
    • Support
    • Communities
    • Documentation
    • Developers
    • Support & Services
    • User Groups
  • About Us
    • About Us
    • Why SAS?
    • Company
    • Careers
    • Newsroom
    • Events
    • Contact Us
  • Explore
    • Explore
    • Try & Buy
    • Why SAS?
    • Customer Stories
    • Partners
    • Consulting
  • Software
  • SAS Viya
  • Industries
  • Solutions
  • Products
  • Learn
  • Training
  • Certification
  • Academics
  • Books
  • Video Tutorials
  • Support
  • Communities
  • Documentation
  • Developers
  • Support & Services
  • User Groups
  • About Us
  • Why SAS?
  • Company
  • Careers
  • Newsroom
  • Events
  • Contact Us
  • Explore
  • Try & Buy
  • Why SAS?
  • Customer Stories
  • Partners
  • Consulting
  • Contact Us
Sign In

Create Profile

My SAS

Get access to My SAS, trials, communities and more.

SAS Sites

sas.com
Support
Blogs
Communities
Developer
Curiosity
Videos

Documentation

Learn
Brand
PartnerNet
Merchandise
SAS® Help Center
SAS® 9.4 and SAS® Viya® 3.5 Programming Documentation
SAS 9.4 / Viya 3.5
|PDF 
Feedback
 
  • Welcome to SAS Programming Documentation for SAS® 9.4 and SAS® Viya® 3.5
  • What's New
  • Syntax Quick Links
  • SAS Viya Programming
  • Data Access
  • SAS Analytics 15.4
  • Base SAS Procedures
    • Base SAS Procedures Guide
    • Base SAS Procedures Guide: Statistical Procedures
    • Base SAS Procedures Guide: High-Performance Procedures
    • SAS SQL Procedure User’s Guide
      • Syntax Conventions for the SAS Language
      • Whatʼs New
      • Using the SQL Procedure
        • Introduction to the SQL Procedure
        • Retrieving Data from a Single Table
        • Retrieving Data from Multiple Tables
        • Creating and Updating Tables and Views
        • Programming with the SQL Procedure
        • Practical Problem-Solving with PROC SQL
      • SQL Procedure Reference
      • Appendixes
    • Reporting Procedure Styles Tip Sheet
    • Video: How to Write JSON Output from SAS
  • DATA Step Programming
  • SAS Code Debugging
  • Global Statements
  • System Options
  • SAS Component Objects
  • DS2 Programming
  • FedSQL Programming
  • Macro Language Reference
  • Output and Graphics
  • Operating Environments
  • Moving and Accessing SAS Files
  • In-Database Technologies
  • Metadata
  • SAS Interface to Application Response Measurement (ARM)
  • Security
  • SAS Servers
  • SAS Data Quality
  • Learning SAS Programming
  • Accessibility for Base
  • SAS Visual Analytics
  • SAS Studio
  • SAS Enterprise Guide
  • SAS 9.4 Administration
  • SAS Viya: Administration
  • Other Resources
SAS SQL Procedure User’s Guide
 

Retrieving Data from a Single Table

Overview of the SELECT Statement
Selecting Columns in a Table
Creating New Columns
Sorting Data
Retrieving Rows That Satisfy a Condition
Summarizing Data
Grouping Data
Filtering Grouped Data
Validating a Query
Last updated: September 10, 2026
Privacy Statement Terms of Use 
Copyright © SAS Institute Inc. All Rights Reserved