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!
proc sql;
select Name, Age, Height, Weight
from sashelp.class;
quit;
1
PROC SQL;
2
select Name, Age, Height, Weight
3
from sashelp.class;
4
QUIT;
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.
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. WeAreCAS is an independent community site and is not affiliated with SAS Institute Inc.
This site uses technical and analytical cookies to improve your experience.
Read more.