Published on :
Reporting SASHELP

Simple extraction via PROC SQL

This code is also available in: Deutsch Español Français
This script uses the SQL procedure to query the SASHELP.CLASS sample system table. It projects the Name, Age, Height, and Weight columns to the active Output Delivery System (ODS) destination. No output table is created.
Data Analysis

Type : SASHELP


Uses the standard SASHELP.CLASS table available by default.

1 Code Block
PROC SQL
Explanation :
Executes a standard SELECT query to display the Name, Age, Height, and Weight variables.
Copied!
1PROC SQL;
2 select Name, Age, Height, Weight
3 from sashelp.class;
4QUIT;
This material is provided "as is" by We Are Cas. There are no warranties, expressed or implied, as to merchantability or fitness for a particular purpose regarding the materials or code contained herein. We Are Cas is not responsible for errors in this material as it now exists or will exist, nor does We Are Cas provide technical support for it.