Base SAS(R) 9.2 Procedures Guide
- What's New in SAS 9.2 Base Procedures
Concepts
Procedures- The APPEND Procedure
- The CALENDAR Procedure
- Overview: CALENDAR Procedure
- Syntax: CALENDAR Procedure
- 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 CATALOG Procedure
- The CHART Procedure
- The 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
- 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
- Concepts: FCMP Procedure
- 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
- User-defined Functions
- Examples: FCMP Procedure
- The FONTREG Procedure
- The FORMAT Procedure
- Overview: FORMAT Procedure
- Syntax: FORMAT Procedure
- 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
- See Also
- The FORMS Procedure
- The FREQ Procedure
- The FSLIST Procedure
- The IMPORT Procedure
- The INFOMAPS Procedure
- The JAVAINFO Procedure
- The MEANS Procedure
- Overview: MEANS Procedure
- Syntax: MEANS Procedure
- 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 MIGRATE Procedure
- Overview: MIGRATE Procedure
- Syntax: MIGRATE Procedure
- Concepts: MIGRATE Procedure
- Migrating a Library with Validation Tools
- Using the SLIBREF= Option
- Examples
- Migrating from SAS 8 or Later without SLIBREF= across Computers
- Migrating from SAS 8 or Later with SLIBREF= across Computers
- Migrating from SAS 8 or Later without SLIBREF= on the Same Computer
- Migrating from SAS 8 or Later with SLIBREF= on the Same Computer
- Migrating SAS 6 Libraries to SAS 9
- Additional Steps for Unsupported Catalogs
- Alternatives to PROC MIGRATE
- The 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
- The PRINT Procedure
- Overview: PRINT Procedure
- Syntax: PRINT Procedure
- 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
- The PROTO Procedure
- The PRTDEF Procedure
- The PRTEXP Procedure
- The PWENCODE Procedure
- The RANK Procedure
- The REGISTRY Procedure
- The REPORT Procedure
- Overview: REPORT Procedure
- Concepts: REPORT Procedure
- Syntax: REPORT Procedure
- REPORT Procedure Windows
- 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
- The SOAP Procedure
- The 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
- Concepts: SQL Procedure
- 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
- The SUMMARY Procedure
- The TABULATE Procedure
- Overview: TABULATE Procedure
- Terminology: TABULATE Procedure
- Syntax: TABULATE Procedure
- 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
- References
- The TEMPLATE Procedure
- The TIMEPLOT Procedure
- The 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
- ICU License
- Recommended Reading
Index here
| Product | Release |
|---|---|
| Base SAS | 9.2 |
- Type
- Usage and Reference
- Copyright Date
- March 2008
- Last Updated
- 15Apr2008
 |
|
| Previous Page | | | Next Page |
| Base SAS 9.2 Procedures Guide |
Fundamental Concepts for Using Base SAS Procedures
![[continuerule]](../../../../common/61925/HTML/default/images/contrul.gif){kind=small}
Language Concepts
Procedure Concepts
Output Delivery System
|
|
| Previous Page | | | Next Page | | | Top of Page |
Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.