The script demonstrates the use of PROC PRINT to display data (complete or selected) from the SASHELP.CARS dataset. It also uses PROC SQL to create a new table (WORK.query) by filtering and ordering data from SASHELP.CARS. PROC DATASETS is employed to extract metadata from this new table into WORK.details, which is then displayed by PROC PRINT. Descriptive statistics are calculated on the 'Weight' variable of the SASHELP.CARS dataset using PROC MEANS. Finally, PROC SGPLOT is used to generate a bar chart visualizing population by region from SASHELP.DEMOGRAPHICS, with ODS Graphics options for output.
Data Analysis
Type : SASHELP
Primary source data comes from SASHELP libraries, specifically SASHELP.CARS and SASHELP.DEMOGRAPHICS. Intermediate work tables (WORK.query, WORK.details) are created and used throughout the script from this source data.
1 Code Block
PROC PRINT
Explanation : Displays the entire SASHELP.CARS dataset in the log or default output, providing a quick overview of the raw data.
Copied!
proc print data=sashelp.cars;
run;
1
PROC PRINTDATA=sashelp.cars;
2
RUN;
2 Code Block
PROC PRINT
Explanation : Displays a specific selection of variables (Make, Model, Type, etc.) from the SASHELP.CARS dataset. The 'by Make' clause organizes the output by manufacturer, allowing observations to be grouped for better readability.
Copied!
proc print data=sashelp.cars;
by Make;
var Make Model Type DriveTrain EngineSize Cylinders Horsepower MPG_City MPG_Highway;
run;
1
PROC PRINTDATA=sashelp.cars;
2
BY Make;
3
var Make Model Type DriveTrain EngineSize Cylinders Horsepower MPG_City MPG_Highway;
4
RUN;
3 Code Block
PROC SQL Data
Explanation : Creates a new temporary SAS table named 'WORK.query' using an SQL query. This query selects several columns from the SASHELP.CARS dataset, filters cars with horsepower greater than or equal to 400, and sorts the results by descending horsepower to identify the most powerful vehicles.
Copied!
PROC SQL;
CREATE TABLE WORK.query AS
SELECT Make , Model , 'Type'n , Origin , DriveTrain , EngineSize , Cylinders , Horsepower , MPG_City , MPG_Highway , Weight , Wheelbase FROM SASHELP.CARS WHERE Horsepower >=400 ORDER BY Horsepower DESCENDING;
RUN;
QUIT;
1
PROC SQL;
2
CREATE TABLE WORK.query AS
3
SELECT Make , Model , 'Type'n , Origin , DriveTrain , EngineSize , Cylinders , Horsepower , MPG_City , MPG_Highway , Weight , Wheelbase FROM SASHELP.CARS WHERE Horsepower >=400 ORDER BY Horsepower DESCENDING;
4
RUN;
5
QUIT;
4 Code Block
PROC DATASETS Data
Explanation : Uses PROC DATASETS to generate a detailed content report (metadata) for the previously created 'WORK.query' dataset. The result is saved into a new SAS table, 'WORK.details', rather than being displayed directly in the log. The NOLIST and NODETAILS options suppress procedure output to focus solely on creating the metadata table.
Explanation : Displays the content of the 'WORK.details' table, which contains the metadata (variable names, types, lengths, formats, etc.) of the 'WORK.query' dataset. This allows for examining the structure of the intermediate table.
Copied!
PROC PRINT DATA=WORK.details;
RUN;
1
PROC PRINTDATA=WORK.details;
2
RUN;
6 Code Block
PROC MEANS
Explanation : Calculates descriptive statistics (mean, standard deviation, minimum, maximum, number of observations) for the 'Weight' variable of the SASHELP.CARS dataset. The 'chartype' option is used for the data type of the analysis variable, and 'vardef=df' specifies that the divisor for standard deviation and variance should be based on degrees of freedom.
Copied!
proc means data=SASHELP.CARS chartype mean std min max n vardef=df;
var Weight;
run;
1
2
PROC MEANS
3
DATA=SASHELP.CARS chartype mean std min max n vardef=df;
4
var Weight;
5
RUN;
6
7 Code Block
PROC SGPLOT
Explanation : Generates a bar chart visualizing 'Population by Region' from the SASHELP.DEMOGRAPHICS dataset. ODS Graphics options are first reset and configured. The bar chart uses the 'region' variable for categories and 'pop' (population) as the response variable, displaying the average population by region. Specific fill and style attributes are applied for better presentation. Finally, ODS Graphics options and the title are reset after the procedure to prevent them from affecting subsequent outputs.
Copied!
ods graphics / reset imagemap;
/*--SGPLOT proc statement--*/
proc sgplot data=SASHELP.DEMOGRAPHICS;
/*--TITLE and FOOTNOTE--*/
title 'Population by Region';
/*--Bar chart settings--*/
vbar region / response=pop fillattrs=(color=CX0a66f1) stat=Mean dataskin=Crisp
name='Bar';
/*--Response Axis--*/
yaxis grid;
run;
ods graphics / reset;
title;
1
ods graphics / reset imagemap;
2
3
/*--SGPLOT proc statement--*/
4
PROC SGPLOTDATA=SASHELP.DEMOGRAPHICS;
5
/*--TITLE and FOOTNOTE--*/
6
title 'Population by Region';
7
8
/*--Bar chart settings--*/
9
vbar region / response=pop fillattrs=(color=CX0a66f1) stat=Mean dataskin=Crisp
10
name='Bar';
11
12
/*--Response Axis--*/
13
yaxis grid;
14
RUN;
15
16
ods graphics / reset;
17
title;
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.
Copyright Info : Getting Started with SAS Studio; 10/28/2015; http://support.sas.com/training/tutorial/studio/get-started.html
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.