Base SAS(R) 9.2 Procedures Guide
- What's New in SAS 9.2 Base Procedures
Concepts- Choosing the Right Procedure
- Functional Categories of Base SAS Procedures
- Report-Writing Procedures
- Statistical Procedures
- Base Procedures That Are Enhanced for In-Database Processing
- Utility Procedures
- Brief Descriptions of Base SAS Procedures
- Fundamental Concepts for Using Base SAS Procedures
- Statements with the Same Function in Multiple Procedures
- Procedures
- The APPEND Procedure
- The CALENDAR Procedure
- Overview: CALENDAR Procedure
- Syntax: CALENDAR Procedure
- PROC CALENDAR Statement
- BY Statement
- CALID Statement
- DUR Statement
- FIN Statement
- HOLIDUR Statement
- HOLIFIN Statement
- HOLISTART Statement
- HOLIVAR Statement
- MEAN Statement
- OUTDUR Statement
- OUTFIN Statement
- OUTSTART Statement
- START Statement
- SUM Statement
- VAR Statement
- Concepts: CALENDAR Procedure
- Results: CALENDAR Procedure
- Examples: CALENDAR Procedure
- Schedule Calendar with Holidays: 5-Day Default
- Schedule Calendar Containing Multiple Calendars
- Multiple Schedule Calendars with Atypical Work Shifts (Separated Output)
- Multiple Schedule Calendars with Atypical Work Shifts (Combined and Mixed Output)
- Schedule Calendar, Blank or with Holidays
- Calculating a Schedule Based on Completion of Predecessor Tasks
- Summary Calendar with MEAN Values By Observation
- Multiple Summary Calendars with Atypical Work Shifts (Separated Output)
- The CALLRFC Procedure
- The CATALOG Procedure
- Overview: CATALOG Procedure
- Syntax: CATALOG Procedure
- PROC CATALOG Statement
- CHANGE Statement
- CONTENTS Statement
- COPY Statement
- DELETE Statement
- EXCHANGE Statement
- EXCLUDE Statement
- MODIFY Statement
- SAVE Statement
- SELECT Statement
- Concepts: CATALOG Procedure
- Results: CATALOG Procedure
- Examples: CATALOG Procedure
- The CHART Procedure
- Overview: CHART Procedure
- Syntax: CHART Procedure
- PROC CHART Statement
- BLOCK Statement
- BY Statement
- HBAR Statement
- PIE Statement
- STAR Statement
- VBAR Statement
- Customizing All Types of Charts
- Concepts: CHART Procedure
- Results: CHART Procedure
- Examples: CHART Procedure
- Producing a Simple Frequency Count
- Producing a Percentage Bar Chart
- Subdividing the Bars into Categories
- Producing Side-by-Side Bar Charts
- Producing a Horizontal Bar Chart for a Subset of the Data
- Producing Block Charts for BY Groups
- References
- The CIMPORT Procedure
- Overview: CIMPORT Procedure
- Syntax: CIMPORT Procedure
- CIMPORT Problems: Importing Transport Files
- Examples: CIMPORT Procedure
- The COMPARE Procedure
- Overview: COMPARE Procedure
- Syntax: COMPARE Procedure
- Concepts: COMPARE Procedure
- Results: COMPARE Procedure
- Examples: COMPARE Procedure
- Producing a Complete Report of the Differences
- Comparing Variables in Different Data Sets
- Comparing a Variable Multiple Times
- Comparing Variables That Are in the Same Data Set
- Comparing Observations with an ID Variable
- Comparing Values of Observations Using an Output Data Set (OUT=)
- Creating an Output Data Set of Statistics (OUTSTATS=)
- The CONTENTS Procedure
- The COPY Procedure
- The CORR Procedure
- The CPORT Procedure
- Overview: CPORT Procedure
- Syntax: CPORT Procedure
- READ= Data Set Option in the PROC CPORT Statement
- Results: CPORT Procedure
- Examples: CPORT Procedure
- The CV2VIEW Procedure
- The DATASETS Procedure
- Overview: DATASETS Procedure
- Syntax: DATASETS Procedure
- PROC DATASETS Statement
- AGE Statement
- APPEND Statement
- ATTRIB Statement
- AUDIT Statement
- CHANGE Statement
- CONTENTS Statement
- COPY Statement
- DELETE Statement
- EXCHANGE Statement
- EXCLUDE Statement
- FORMAT Statement
- IC CREATE Statement
- IC DELETE Statement
- IC REACTIVATE Statement
- INDEX CENTILES Statement
- INDEX CREATE Statement
- INDEX DELETE Statement
- INFORMAT Statement
- LABEL Statement
- MODIFY Statement
- REBUILD Statement
- RENAME Statement
- REPAIR Statement
- SAVE Statement
- SELECT Statement
- Concepts: DATASETS Procedure
- Results: DATASETS Procedure
- Examples: DATASETS Procedure
- The DBCSTAB Procedure
- The DISPLAY Procedure
- The DOCUMENT Procedure
- The EXPLODE Procedure
- The EXPORT Procedure
- The FCMP Procedure
- Overview: FCMP Procedure
- Syntax: FCMP Procedure
- PROC FCMP Statement
- ABORT Statement
- ARRAY Statement
- ATTRIB Statement
- FUNCTION Statement
- LABEL Statement
- STRUCT Statement
- SUBROUTINE Statement
- OUTARGS Statement
- Concepts: FCMP Procedure
- PROC FCMP and DATA Step Differences
- Working with Arrays
- Reading Arrays and Writing Arrays to a Data Set
- Using Macros with PROC FCMP Routines
- Variable Scope in PROC FCMP Routines
- Recursion
- Directory Transversal
- Identifying the Location of Compiled Functions and Subroutines: The CMPLIB= System Option
- Special Functions and CALL Routines: Overview
- Special Functions and CALL Routines: Matrix CALL Routines
- Special Functions and CALL Routines: C Helper Functions and CALL Routines
- Special Functions and CALL Routines: Other Functions
- Functions for Calling SAS Code from Within Functions
- The FCmp Function Editor
- Examples: FCMP Procedure
- The FONTREG Procedure
- Overview: FONTREG Procedure
- Syntax: FONTREG Procedure
- PROC FONTREG Statement
- FONTFILE Statement
- FONTPATH Statement
- REMOVE Statement
- TRUETYPE Statement
- TYPE1 Statement
- Concepts: FONTREG Procedure
- Examples: FONTREG Procedure
- Adding a Single Font File
- Adding All Font Files from Multiple Directories
- Replacing Existing TrueType Font Files from a Directory
- See Also
- The FORMAT Procedure
- Overview: FORMAT Procedure
- Syntax: FORMAT Procedure
- PROC FORMAT Statement
- EXCLUDE Statement
- INVALUE Statement
- PICTURE Statement
- SELECT Statement
- VALUE Statement
- Informat and Format Options
- Specifying Values or Ranges
- Concepts: FORMAT Procedure
- Results: FORMAT Procedure
- Examples: FORMAT Procedure
- Creating a Picture Format
- Creating a Format for Character Values
- Writing a Format for Dates Using a Standard SAS Format
- Converting Raw Character Data to Numeric Values
- Creating a Format from a Data Set
- Printing the Description of Informats and Formats
- Retrieving a Permanent Format
- Writing Ranges for Character Strings
- Filling a Picture Format
- Creating a Format in a non-English Language
- See Also
- The FORMS Procedure
- The FREQ Procedure
- The FSLIST Procedure
- The HTTP Procedure
- Overview: HTTP Procedure
- Syntax: HTTP Procedure
- Using Hypertext Transfer Protocol Secure (HTTPS)
- Examples: HTTP Procedure
- The IMPORT Procedure
- The INFOMAPS Procedure
- The JAVAINFO Procedure
- The MEANS Procedure
- Overview: MEANS Procedure
- Syntax: MEANS Procedure
- PROC MEANS Statement
- BY Statement
- CLASS Statement
- FREQ Statement
- ID Statement
- OUTPUT Statement
- TYPES Statement
- VAR Statement
- WAYS Statement
- WEIGHT Statement
- Concepts: MEANS Procedure
- Statistical Computations: MEANS Procedure
- Results: MEANS Procedure
- Examples: MEANS Procedure
- Computing Specific Descriptive Statistics
- Computing Descriptive Statistics with Class Variables
- Using the BY Statement with Class Variables
- Using a CLASSDATA= Data Set with Class Variables
- Using Multilabel Value Formats with Class Variables
- Using Preloaded Formats with Class Variables
- Computing a Confidence Limit for the Mean
- Computing Output Statistics
- Computing Different Output Statistics for Several Variables
- Computing Output Statistics with Missing Class Variable Values
- Identifying an Extreme Value with the Output Statistics
- Identifying the Top Three Extreme Values with the Output Statistics
- References
- The METADATA Procedure
- The METALIB Procedure
- The METAOPERATE Procedure
- The MIGRATE Procedure
- Overview: MIGRATE Procedure
- Syntax: MIGRATE Procedure
- Concepts: MIGRATE Procedure
- Migrating a Library with Validation Tools
- Using the SLIBREF= Option
- Examples
- The OPTIONS Procedure
- Overview: OPTIONS Procedure
- Syntax: OPTIONS Procedure
- Results: OPTIONS Procedure
- Examples: OPTIONS Procedure
- The OPTLOAD Procedure
- The OPTSAVE Procedure
- The PLOT Procedure
- Overview: PLOT Procedure
- Syntax: PLOT Procedure
- Concepts: PLOT Procedure
- Results: PLOT Procedure
- Examples: PLOT Procedure
- Specifying a Plotting Symbol
- Controlling the Horizontal Axis and Adding a Reference Line
- Overlaying Two Plots
- Producing Multiple Plots per Page
- Plotting Data on a Logarithmic Scale
- Plotting Date Values on an Axis
- Producing a Contour Plot
- Plotting BY Groups
- Adding Labels to a Plot
- Excluding Observations That Have Missing Values
- Adjusting Labels on a Plot with the PLACEMENT= Option
- Adjusting Labeling on a Plot with a Macro
- Changing a Default Penalty
- The PMENU Procedure
- Overview: PMENU Procedure
- Syntax: PMENU Procedure
- PROC PMENU Statement
- CHECKBOX Statement
- DIALOG Statement
- ITEM Statement
- MENU Statement
- RADIOBOX Statement
- RBUTTON Statement
- SELECTION Statement
- SEPARATOR Statement
- SUBMENU Statement
- TEXT Statement
- Concepts: PMENU Procedure
- Examples: PMENU Procedure
- The PRINT Procedure
- Overview: PRINT Procedure
- Syntax: PRINT Procedure
- PROC PRINT Statement
- BY Statement
- ID Statement
- PAGEBY Statement
- SUM Statement
- SUMBY Statement
- VAR Statement
- Results: Print Procedure
- Examples: PRINT Procedure
- Selecting Variables to Print
- Customizing Text in Column Headings
- Creating Separate Sections of a Report for Groups of Observations
- Summing Numeric Variables with One BY Group
- Summing Numeric Variables with Multiple BY Variables
- Limiting the Number of Sums in a Report
- Controlling the Layout of a Report with Many Variables
- Creating a Customized Layout with BY Groups and ID Variables
- Printing All the Data Sets in a SAS Library
- The PRINTTO Procedure
- Overview: PRINTTO Procedure
- Syntax: PRINTTO Procedure
- Concepts: PRINTTO Procedure
- Examples: PRINTTO Procedure
- The PROTO Procedure
- Overview: PROTO Procedure
- Syntax: PROTO Procedure
- Concepts: PROTO Procedure
- C Helper Functions and CALL Routines
- Results: PROTO Procedure
- Examples: PROTO Procedure
- The PRTDEF Procedure
- Overview: PRTDEF Procedure
- Syntax: PRTDEF Procedure
- Input Data Set: PRTDEF Procedure
- Examples: PRTDEF Procedure
- Defining Multiple Printer Definitions
- Creating a Ghostview Printer in SASUSER to Preview PostScript Printer Output in SASUSER
- Creating a Single Printer Definition That Is Available to All Users
- Adding, Modifying, and Deleting Printer Definitions
- Deleting a Single Printer Definition
- See Also
- The PRTEXP Procedure
- Overview: PRTEXP Procedure
- Syntax: PRTEXP Procedure
- Concepts: PRTEXP Procedure
- Examples: PRTEXP Procedure
- See Also
- The PWENCODE Procedure
- Overview: PWENCODE Procedure
- Syntax: PWENCODE Procedure
- Concepts: PWENCODE Procedure
- Examples: PWENCODE Procedure
- The RANK Procedure
- Overview: RANK Procedure
- Syntax: RANK Procedure
- Concepts: RANK Procedure
- Results: RANK Procedure
- Examples: RANK Procedure
- Ranking Values of Multiple Variables
- Ranking Values within BY Groups
- Partitioning Observations into Groups Based on Ranks
- References
- The REGISTRY Procedure
- Overview: REGISTRY Procedure
- Syntax: REGISTRY Procedure
- Creating Registry Files with the REGISTRY Procedure
- Examples: REGISTRY Procedure
- Importing a File to the Registry
- Listing and Exporting the Registry
- Comparing the Registry to an External File
- Comparing Registry Files
- Specifying an Entire Key Sequence with the STARTAT= Option
- Displaying a List of Fonts
- See Also
- The REPORT Procedure
- Overview: REPORT Procedure
- Concepts: REPORT Procedure
- Syntax: REPORT Procedure
- PROC REPORT Statement
- BREAK Statement
- BY Statement
- CALL DEFINE Statement
- COLUMN Statement
- COMPUTE Statement
- DEFINE Statement
- ENDCOMP Statement
- FREQ Statement
- LINE Statement
- RBREAK Statement
- WEIGHT Statement
- REPORT Procedure Windows
- BREAK
- COMPUTE
- COMPUTED VAR
- DATA COLUMNS
- DATA SELECTION
- DEFINITION
- DISPLAY PAGE
- EXPLORE
- FORMATS
- LOAD REPORT
- MESSAGES
- PROFILE
- PROMPTER
- REPORT
- ROPTIONS
- SAVE DATA SET
- SAVE DEFINITION
- SOURCE
- STATISTICS
- WHERE
- WHERE ALSO
- How PROC REPORT Builds a Report
- Examples: REPORT Procedure
- Selecting Variables for a Report
- Ordering the Rows in a Report
- Using Aliases to Obtain Multiple Statistics for the Same Variable
- Consolidating Multiple Observations into One Row of a Report
- Creating a Column for Each Value of a Variable
- Displaying Multiple Statistics for One Variable
- Storing and Reusing a Report Definition
- Condensing a Report into Multiple Panels
- Writing a Customized Summary on Each Page
- Calculating Percentages
- How PROC REPORT Handles Missing Values
- Creating and Processing an Output Data Set
- Storing Computed Variables as Part of a Data Set
- Using a Format to Create Groups
- Specifying Style Elements for ODS Output in the PROC REPORT Statement
- Specifying Style Elements for ODS Output in Multiple Statements
- The SCAPROC Procedure
- Overview: SCAPROC Procedure
- Syntax: SCAPROC Procedure
- Results: SCAPROC Procedure
- Examples: SCAPROC Procedure
- The SOAP Procedure
- Overview: SOAP Procedure
- Syntax: SOAP Procedure
- Concepts: SOAP Procedure
- WS-Security: Client Configuration
- Using PROC SOAP with Secure Socket Layer (SSL)
- Calling SAS Web Services
- Examples: SOAP Procedure
- The SORT Procedure
- Overview: SORT Procedure
- Syntax: SORT Procedure
- Concepts: SORT Procedure
- Integrity Constraints: SORT Procedure
- Results: SORT Procedure
- Examples: SORT Procedure
- The SQL Procedure
- Overview: SQL Procedure
- Syntax: SQL Procedure
- PROC SQL Statement
- ALTER TABLE Statement
- CONNECT Statement
- CREATE INDEX Statement
- CREATE TABLE Statement
- CREATE VIEW Statement
- DELETE Statement
- DESCRIBE Statement
- DISCONNECT Statement
- DROP Statement
- EXECUTE Statement
- INSERT Statement
- RESET Statement
- SELECT Statement
- UPDATE Statement
- VALIDATE Statement
- SQL Procedure Component Dictionary
- BETWEEN condition
- BTRIM function
- CALCULATED
- CASE expression
- COALESCE Function
- column-definition
- column-modifier
- column-name
- CONNECTION TO
- CONTAINS condition
- EXISTS condition
- IN condition
- IS condition
- joined-table
- LIKE condition
- LOWER function
- query-expression
- sql-expression
- SUBSTRING function
- summary-function
- table-expression
- UPPER function
- PROC SQL and the ANSI Standard
- Examples: SQL Procedure
- Creating a Table and Inserting Data into It
- Creating a Table from a Query's Result
- Updating Data in a PROC SQL Table
- Joining Two Tables
- Combining Two Tables
- Reporting from DICTIONARY Tables
- Performing an Outer Join
- Creating a View from a Query's Result
- Joining Three Tables
- Querying an In-Line View
- Retrieving Values with the SOUNDS-LIKE Operator
- Joining Two Tables and Calculating a New Value
- Producing All the Possible Combinations of the Values in a Column
- Matching Case Rows and Control Rows
- Counting Missing Values with a SAS Macro
- The STANDARD Procedure
- Overview: STANDARD Procedure
- Syntax: STANDARD Procedure
- Results: STANDARD Procedure
- Statistical Computations: STANDARD Procedure
- Examples: STANDARD Procedure
- The SUMMARY Procedure
- The TABULATE Procedure
- Overview: TABULATE Procedure
- Terminology: TABULATE Procedure
- Syntax: TABULATE Procedure
- PROC TABULATE Statement
- BY Statement
- CLASS Statement
- CLASSLEV Statement
- FREQ Statement
- KEYLABEL Statement
- KEYWORD Statement
- TABLE Statement
- VAR Statement
- WEIGHT Statement
- Concepts: TABULATE Procedure
- Results: TABULATE Procedure
- Examples: TABULATE Procedure
- Creating a Basic Two-Dimensional Table
- Specifying Class Variable Combinations to Appear in a Table
- Using Preloaded Formats with Class Variables
- Using Multilabel Formats
- Customizing Row and Column Headings
- Summarizing Information with the Universal Class Variable ALL
- Eliminating Row Headings
- Indenting Row Headings and Eliminating Horizontal Separators
- Creating Multipage Tables
- Reporting on Multiple-Response Survey Data
- Reporting on Multiple-Choice Survey Data
- Calculating Various Percentage Statistics
- Using Denominator Definitions to Display Basic Frequency Counts and Percentages
- Specifying Style Elements for ODS Output
- Style Precedence
- References
- The TEMPLATE Procedure
- The TIMEPLOT Procedure
- Overview: TIMEPLOT Procedure
- Syntax: TIMEPLOT Procedure
- Results: TIMEPLOT Procedure
- Examples: TIMEPLOT Procedure
- The TRANSPOSE Procedure
- Overview: TRANSPOSE Procedure
- Syntax: TRANSPOSE Procedure
- Results: TRANSPOSE Procedure
- Examples: TRANSPOSE Procedure
- The TRANTAB Procedure
- The UNIVARIATE Procedure
- Appendixes
- SAS Elementary Statistics Procedures
- Operating Environment-Specific Procedures
- Raw Data and DATA Steps
- Overview
- CENSUS
- CHARITY
- CONTROL Library
- CUSTOMER_RESPONSE
- DJIA
- EDUCATION
- EMPDATA
- ENERGY
- EXP Library
- EXPREV
- GROC
- MATCH_11
- PROCLIB.DELAY
- PROCLIB.EMP95
- PROCLIB.EMP96
- PROCLIB.INTERNAT
- PROCLIB.LAKES
- PROCLIB.MARCH
- PROCLIB.PAYLIST2
- PROCLIB.PAYROLL
- PROCLIB.PAYROLL2
- PROCLIB.SCHEDULE
- PROCLIB.STAFF
- PROCLIB.SUPERV
- RADIO
- SALES
- ICU License
- Recommended Reading
Index here
| Product | Release |
|---|---|
| Base SAS | 9.2 |
- Type
- Usage and Reference
- Copyright Date
- February 2009
- Last Updated
- 03Nov2009
 |
|
| Previous Page | | | Next Page |
| Choosing the Right Procedure |
Base Procedures That Are Enhanced for In-Database Processing
In the second maintenance release for SAS 9.2, Base SAS procedures have been enhanced so they can process data inside the Teradata Enterprise Data Warehouse (EDW). The in-database procedures are used to generate more sophisticated queries that allow the aggregations and analytics to be run inside the database. These in-database procedures all generate SQL queries. You use SAS/ACCESS or SQL as the interface to the Teradata EDW.
The following Base SAS procedures have been enhanced for in-database processing.
| Procedure | Description | |
|---|---|---|
| PROC FREQ in Base SAS Procedures Guide: Statistical Procedures | produces one-way to n-way tables; reports frequency counts; computes test and measures of association and agreement for two-way to n-way cross-tabulation tables; can compute exact tests and asymptotic tests; can create output data sets. | |
|
PROC
MEANS |
computes descriptive statistics; can produce printed output and output data sets. By default, PROC MEANS produces printed output. | |
|
PROC
RANK |
computes ranks for one or more numeric variables across the observations of a SAS data set; can produce some rank scores. | |
|
PROC
SUMMARY |
computes descriptive statistics; can produce a printed report and create an output data set. By default, PROC SUMMARY creates an output data set. | |
For more information, see "In-Database Procedures in Teradata" in SAS/ACCESS for Relational Databases: Reference.
|
|
| Previous Page | | | Next Page | | | Top of Page |
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
