• Contents
  • About
  • Title Page
  • What's New in Base SAS 9.3 Procedures
  • About This Book
  • Concepts
    • Choosing the Right Procedure
      • Functional Categories of Base SAS Procedures
      • Report-Writing Procedures
      • Statistical Procedures
      • Utility Procedures
      • Brief Descriptions of Base SAS Procedures
    • Fundamental Concepts for Using Base SAS Procedures
      • Language Concepts
      • Procedure Concepts
      • Output Delivery System
    • Statements with the Same Function in Multiple Procedures
      • Statements with the Same Function in Multiple Procedures
      • Statements
    • In-Database Processing of Base Procedures
      • Base Procedures That Are Enhanced for In-Database Processing
    • Base SAS Procedures Documented in Other Publications
      • Base SAS Procedures Documented in Other Publications
  • Procedures
    • APPEND Procedure
      • Syntax: APPEND Procedure
      • Overview: APPEND Procedure
      • Using APPEND Procedure
      • Examples: APPEND Procedure
        • Example 1: Concatenating Two SAS Data Sets
        • Example 2: Getting Sort Indicator Information
    • AUTHLIB Procedure
      • Syntax: AUTHLIB Procedure
        • PROC AUTHLIB
        • CREATE
        • MODIFY
        • REMOVE
        • (Preproduction) REPAIR
        • REPORT
        • TABLES
      • Overview: AUTHLIB Procedure
      • Concepts: AUTHLIB Procedure
      • Results: AUTHLIB Procedure
      • Examples: AUTHLIB Procedure
        • Example 1: Binding a Physical Library That Contains Unprotected Data Sets
        • Example 2: Binding a Physical Library That Contains Password-Protected Data Sets
        • Example 3: Securing a Library When Existing Data Sets Are Protected with the Same Passwords
        • Example 4: Securing a Library When Existing Data Sets Are Protected with Different Passwords
        • Example 5: Changing Passwords on Data Sets
        • Example 6: Changing Metadata-Bound Library Passwords
        • Example 7: Using the REMOVE Statement
        • Example 8: Using the REPORT Statement
        • Example 9: Using the TABLES Statement
    • CALENDAR Procedure
      • Syntax: CALENDAR Procedure
        • PROC CALENDAR
        • BY
        • CALID
        • DUR
        • FIN
        • HOLIDUR
        • HOLIFIN
        • HOLISTART
        • HOLIVAR
        • MEAN
        • OUTDUR
        • OUTFIN
        • OUTSTART
        • START
        • SUM
        • VAR
      • Overview: CALENDAR Procedure
      • Concepts: CALENDAR Procedure
      • Results: CALENDAR Procedure
      • Examples: CALENDAR Procedure
        • Example 1: Schedule Calendar with Holidays: 5-Day Default
        • Example 2: Schedule Calendar Containing Multiple Calendars
        • Example 3: Multiple Schedule Calendars with Atypical Work Shifts (Separated Output)
        • Example 4: Multiple Schedule Calendars with Atypical Work Shifts (Combined and Mixed Output)
        • Example 5: Schedule Calendar, Blank or with Holidays
        • Example 6: Calculating a Schedule Based on Completion of Predecessor Tasks
        • Example 7: Summary Calendar with MEAN Values by Observation
        • Example 8: Multiple Summary Calendars with Atypical Work Shifts (Separated Output)
    • CATALOG Procedure
      • Syntax: CATALOG Procedure
        • PROC CATALOG
        • CHANGE
        • CONTENTS
        • COPY
        • DELETE
        • EXCHANGE
        • EXCLUDE
        • MODIFY
        • SAVE
        • SELECT
      • Overview: CATALOG Procedure
      • Concepts
      • Results: CATALOG Procedure
      • Examples: CATALOG Procedure
        • Example 1: Copying, Deleting, and Moving Catalog Entries from Multiple Catalogs
        • Example 2: Displaying Contents, Changing Names, and Changing a Description
        • Example 3: Using the FORCE Option with the KILL Option
    • CHART Procedure
      • Syntax: CHART Procedure
        • PROC CHART
        • BLOCK
        • BY
        • HBAR
        • PIE
        • STAR
        • VBAR
      • Overview: CHART Procedure
      • Concepts: CHART Procedure
      • Results: CHART Procedure
      • Examples: CHART Procedure
        • Example 1: Producing a Simple Frequency Count
        • Example 2: Producing a Percentage Bar Chart
        • Example 3: Subdividing the Bars into Categories
        • Example 4: Producing Side-by-Side Bar Charts
        • Example 5: Producing a Horizontal Bar Chart for a Subset of the Data
        • Example 6: Producing Block Charts for BY Groups
      • References
    • CIMPORT Procedure
      • Syntax: CIMPORT Procedure
        • PROC CIMPORT
        • EXCLUDE
        • SELECT
      • Overview: CIMPORT Procedure
      • CIMPORT Problems: Importing Transport Files
      • Examples: CIMPORT Procedure
        • Example 1: Importing an Entire Library
        • Example 2: Importing Individual Catalog Entries
        • Example 3: Importing a Single Indexed SAS Data Set
    • COMPARE Procedure
      • Syntax: COMPARE Procedure
        • PROC COMPARE
        • BY
        • ID
        • VAR
        • WITH
      • Overview: COMPARE Procedure
      • Concepts: COMPARE Procedure
      • Results: COMPARE Procedure
      • Examples: COMPARE Procedure
        • Example 1: Producing a Complete Report of the Differences
        • Example 2: Comparing Variables in Different Data Sets
        • Example 3: Comparing a Variable Multiple Times
        • Example 4: Comparing Variables That Are in the Same Data Set
        • Example 5: Comparing Observations with an ID Variable
        • Example 6: Comparing Values of Observations Using an Output Data Set (OUT=)
        • Example 7: Creating an Output Data Set of Statistics (OUTSTATS=)
    • CONTENTS Procedure
      • Syntax: CONTENTS Procedure
      • Overview: CONTENTS Procedure
      • Concepts
      • Examples: CONTENTS Procedure
        • Example 1: Using PROC CONTENTS to Extract Only Attributes from Data Sets
        • Example 2: Using the ORDER= Option with the CONTENTS Statement
        • Example 3: Describing a SAS Data Set
    • COPY Procedure
      • Syntax: COPY Procedure
      • Overview: COPY Procedure
      • Concepts
      • Examples: COPY Procedure
        • Example 1: Copying SAS Data Sets between Hosts
        • Example 2: Converting SAS Data Sets Encodings
        • Example 3: Using PROC COPY to Migrate from a 32-bit to a 64-bit Machine
    • CPORT Procedure
      • Syntax: CPORT Procedure
        • PROC CPORT
        • EXCLUDE
        • SELECT
        • TRANTAB
      • Overview: CPORT Procedure
      • READ= Data Set Option in the PROC CPORT Statement
      • CPORT Problems: Creating Transport Files
      • Examples: CPORT Procedure
        • Example 1: Exporting Multiple Catalogs
        • Example 2: Exporting Individual Catalog Entries
        • Example 3: Exporting a Single SAS Data Set
        • Example 4: Applying a Translation Table
        • Example 5: Exporting Entries Based on Modification Date
    • DATASETS Procedure
      • Syntax: DATASETS Procedure
        • PROC DATASETS
        • AGE
        • APPEND
        • ATTRIB
        • AUDIT
        • CHANGE
        • CONTENTS
        • COPY
        • DELETE
        • EXCHANGE
        • EXCLUDE
        • FORMAT
        • IC CREATE
        • IC DELETE
        • IC REACTIVATE
        • INDEX CENTILES
        • INDEX CREATE
        • INDEX DELETE
        • INFORMAT
        • LABEL
        • MODIFY
        • REBUILD
        • RENAME
        • REPAIR
        • SAVE
        • SELECT
      • Overview: DATASETS Procedure
      • Concepts
      • Results: DATASETS Procedure
      • Examples: DATASETS Procedure
        • Example 1: Removing All Labels and Formats in a Data Set
        • Example 2: Manipulating SAS Files
        • Example 3: Saving SAS Files from Deletion
        • Example 4: Modifying SAS Data Sets
        • Example 5: Describing a SAS Data Set
        • Example 6: Concatenating Two SAS Data Sets
        • Example 7: Aging SAS Data Sets
        • Example 8: ODS Output
        • Example 9: Getting Sort Indicator Information
        • Example 10: Using the ORDER= Option with the CONTENTS Statement
        • Example 11: Initiating an Audit File
    • DISPLAY Procedure
      • Syntax: DISPLAY Procedure
        • PROC DISPLAY
      • Overview: DISPLAY Procedure
      • Example: Executing a SAS/AF Application
    • EXPORT Procedure
      • Syntax: EXPORT Procedure
        • PROC EXPORT
        • DBENCODING
        • DELIMITER
        • FMTLIB
        • META
      • Overview: Export Procedure
      • Examples: EXPORT Procedure
        • Example 1: Exporting to a Delimited External Data Source
        • Example 2: Exporting a Subset of Observations to a CSV File
    • FCMP Procedure
      • Syntax: FCMP Procedure
        • PROC FCMP
        • ABORT
        • ARRAY
        • ATTRIB
        • DELETEFUNC
        • DELETESUBR
        • FUNCTION
        • LABEL
        • LISTFUNC
        • LISTSUBR
        • OUTARGS
        • STRUCT
        • SUBROUTINE
      • Overview: FCMP Procedure
      • Concepts: FCMP Procedure
      • PROC FCMP and DATA Step Differences
      • Working with Arrays
      • 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
      • PROC FCMP and DATA Step Component Objects
      • Examples: FCMP Procedure
        • Example 1: Creating a Function and Calling the Function from a DATA Step
        • Example 2: Creating a CALL Routine and a Function
        • Example 3: Using Numeric Data in the FUNCTION Statement
        • Example 4: Using Character Data in the FUNCTION Statement
        • Example 5: Using Variable Arguments with an Array
        • Example 6: Using the SUBROUTINE Statement with a CALL Statement
        • Example 7: Using GTL with User-Defined Functions
        • Example 8: Standardizing Each Row of a Data Set
    • FCMP Special Functions and Call Routines
      • Overview of Special Functions and CALL Routines
      • Functions and CALL Routines by Category
      • CALL ADDMATRIX Routine
      • CALL CHOL Routine
      • CALL DET Routine
      • CALL DYNAMIC_ARRAY Routine
      • CALL ELEMMULT Routine
      • CALL EXPMATRIX Routine
      • CALL FILLMATRIX Routine
      • CALL IDENTITY Routine
      • CALL INV Routine
      • CALL MULT Routine
      • CALL POWER Routine
      • CALL SETNULL Routine
      • CALL STRUCTINDEX Routine
      • CALL SUBTRACTMATRIX Routine
      • CALL TRANSPOSE Routine
      • CALL ZEROMATRIX Routine
      • INVCDF Function
      • ISNULL Function
      • LIMMOMENT Function
      • READ_ARRAY Function
      • RUN_MACRO Function
      • RUN_SASFILE Function
      • SOLVE Function
      • WRITE_ARRAY
    • FCmp Function Editor
      • Introduction to the FCmp Function Editor
      • Open the FCmp Function Editor
      • Working with Existing Functions
      • Creating a New Function
      • Displaying New Libraries in the FCmp Function Editor
      • Viewing the Log Window, Function Browser, and Data Explorer
      • Using Functions in Your DATA Step Program
    • FONTREG Procedure
      • Syntax: FONTREG Procedure
        • PROC FONTREG
        • FONTFILE
        • FONTPATH
        • REMOVE
        • TRUETYPE
        • TYPE1
      • Overview: FONTREG Procedure
      • Concepts: FONTREG Procedure
      • Examples: FONTREG Procedure
        • Example 1: Adding a Single Font File
        • Example 2: Adding All Font Files from Multiple Directories
        • Example 3: Replacing Existing TrueType Font Files from a Directory
    • FORMAT Procedure
      • Syntax: FORMAT Procedure
        • PROC FORMAT
        • EXCLUDE
        • INVALUE
        • PICTURE
        • SELECT
        • VALUE
      • Overview: FORMAT Procedure
      • Concepts: FORMAT Procedure
      • Specifying Values or Ranges
      • Using a Function to Format Values
      • Viewing a Format Definition Using SAS Explorer
      • Results: FORMAT Procedure
      • Examples: FORMAT Procedure
        • Example 1: Create the Example Data Set
        • Example 2: Creating a Picture Format
        • Example 3: Creating a Format for Character Values
        • Example 4: Writing a Format for Dates Using a Standard SAS Format
        • Example 5: Converting Raw Character Data to Numeric Values
        • Example 6: Creating a Format from a Data Set
        • Example 7: Printing the Description of Informats and Formats
        • Example 8: Retrieving a Permanent Format
        • Example 9: Writing Ranges for Character Strings
        • Example 10: Filling a Picture Format
        • Example 11: Creating a Format in a non-English Language
        • Example 12: Creating a Function to Use as a Format
        • Example 13: Creating a Format for Trafficlighting
        • Example 14: Using a Format to Create a Drill-down Table
    • FSLIST Procedure
      • Syntax: FSLIST Procedure
        • PROC FSLIST
      • Overview: FSLIST Procedure
      • FSLIST Command
      • Using the FSLIST Window
    • GROOVY Procedure
      • Syntax: GROOVY Procedure
        • PROC GROOVY
      • Overview: GROOVY Procedure
      • ADD Command
      • EVALUATE Command
      • EXECUTE Command
      • SUBMIT Command
      • ENDSUBMIT Command
      • CLEAR Command
      • Special Variables
      • Example: Define Classes
    • HADOOP Procedure
      • Syntax: HADOOP Procedure
        • PROC HADOOP
        • HDFS
        • MAPREDUCE
        • PIG
      • Overview: HADOOP Procedure
      • Concepts: HADOOP Procedure
      • Examples: HADOOP Procedure
        • Example 1: Submitting HDFS Commands
        • Example 2: Submitting a MapReduce Program
        • Example 3: Submitting Pig Language Code
    • HTTP Procedure
      • Syntax: HTTP Procedure
        • PROC HTTP
      • Overview: HTTP Procedure
      • Using Hypertext Transfer Protocol Secure (HTTPS)
      • Using Encodings with PROC HTTP
      • Examples: HTTP Procedure
        • Example 1: A Simple POST Request
        • Example 2: A POST Through a Proxy
        • Example 3: A POST Through a Proxy That Requires Authentication
        • Example 4: A POST That Captures the Response Headers
    • IMPORT Procedure
      • Syntax: IMPORT Procedure
        • PROC IMPORT
        • DATAROW
        • DBENCODING
        • DELIMITER
        • FMTLIB
        • GETNAMES
        • GUESSINGROWS
        • META
      • Overview: IMPORT Procedure
      • Examples: IMPORT Procedure
        • Example 1: Importing a Delimited File
        • Example 2: Importing a Specific Delimited File Using a Fileref
        • Example 3: Importing a Tab-Delimited File
        • Example 4: Importing a Comma-Delimited File with a CSV Extension
    • JAVAINFO Procedure
      • Syntax: JAVAINFO Procedure
        • PROC JAVAINFO
      • Overview: JAVAINFO Procedure
    • MEANS Procedure
      • Syntax: MEANS Procedure
        • PROC MEANS
        • BY
        • CLASS
        • FREQ
        • ID
        • OUTPUT
        • TYPES
        • VAR
        • WAYS
        • WEIGHT
      • Overview: MEANS Procedure
      • Concepts: MEANS Procedure
      • Statistical Computations: MEANS Procedure
      • Results: MEANS Procedure
      • Examples: MEANS Procedure
        • Example 1: Computing Specific Descriptive Statistics
        • Example 2: Computing Descriptive Statistics with Class Variables
        • Example 3: Using the BY Statement with Class Variables
        • Example 4: Using a CLASSDATA= Data Set with Class Variables
        • Example 5: Using Multilabel Value Formats with Class Variables
        • Example 6: Using Preloaded Formats with Class Variables
        • Example 7: Computing a Confidence Limit for the Mean
        • Example 8: Computing Output Statistics
        • Example 9: Computing Different Output Statistics for Several Variables
        • Example 10: Computing Output Statistics with Missing Class Variable Values
        • Example 11: Identifying an Extreme Value with the Output Statistics
        • Example 12: Identifying the Top Three Extreme Values with the Output Statistics
        • Example 13: Using the STACKODSOUTPUT option to control data
      • References
    • MIGRATE Procedure
      • Syntax: MIGRATE Procedure
        • PROC MIGRATE
      • Overview: MIGRATE Procedure
      • Considerations for Each Member Type
      • Migrating a Data File with Audit Trails, Generations, Indexes, or Integrity Constraints
      • Migrating a SAS Data Set with NODUPKEY Sort Indicator
      • Migrating a SAS 6 Library
      • Migrating a Data Set that Contains Non-English Characters
      • Migrating Files with Short Extensions on PC Operating Environments
      • Migrating a Library with Validation Tools
      • Using the SLIBREF= Option
      • Examples: MIGRATE Procedure
        • Example 1: Migrating across Computers
        • Example 2: Migrating with Incompatible Catalogs across Computers
        • Example 3: Migrating on the Same Computer
        • Example 4: Migrating with Incompatible Catalogs on the Same Computer
        • Example 5: Migrating from a SAS®9 Release with Incompatible Catalogs
        • Example 6: Additional Steps for Unsupported Catalogs
        • Example 7: Alternatives to PROC MIGRATE
    • OPTIONS Procedure
      • Syntax: OPTIONS Procedure
        • PROC OPTIONS
      • Overview: OPTIONS Procedure
      • Displaying a List of System Options
      • Displaying Information about One or More Options
      • Displaying Information about System Option Groups
      • Displaying Restricted Options
      • Results: OPTIONS Procedure
      • Examples: OPTIONS Procedure
        • Example 1: Producing the Short Form of the Options Listing
        • Example 2: Displaying the Setting of a Single Option
        • Example 3: Displaying Expanded Path Environment Variables
        • Example 4: List the Options That Can Be Specified by the INSERT and APPEND Options
    • OPTLOAD Procedure
      • Syntax: OPTLOAD Procedure
        • PROC OPTLOAD
      • Overview: OPTLOAD Procedure
      • Example: Load a Data Set of Saved System Options
    • OPTSAVE Procedure
      • Syntax: OPTSAVE Procedure
        • PROC OPTSAVE
      • Overview: OPTSAVE Procedure
      • Determining If a Single Option Can Be Saved
      • Creating a List of Options That Can Be Saved
      • Example: Saving System Options in a Data Set
    • PLOT Procedure
      • Syntax: PLOT Procedure
        • PROC PLOT
        • BY
        • PLOT
      • Overview: PLOT Procedure
      • Concepts: PLOT Procedure
      • Results: PLOT Procedure
      • Examples: PLOT Procedure
        • Example 1: Specifying a Plotting Symbol
        • Example 2: Controlling the Horizontal Axis and Adding a Reference Line
        • Example 3: Overlaying Two Plots
        • Example 4: Producing Multiple Plots per Page
        • Example 5: Plotting Data on a Logarithmic Scale
        • Example 6: Plotting Date Values on an Axis
        • Example 7: Producing a Contour Plot
        • Example 8: Plotting BY Groups
        • Example 9: Adding Labels to a Plot
        • Example 10: Excluding Observations That Have Missing Values
        • Example 11: Adjusting Labels on a Plot with the PLACEMENT= Option
        • Example 12: Adjusting Labeling on a Plot with a Macro
        • Example 13: Changing a Default Penalty
    • PMENU Procedure
      • Syntax: PMENU Procedure
        • PROC PMENU
        • CHECKBOX
        • DIALOG
        • ITEM
        • MENU
        • RADIOBOX
        • RBUTTON
        • SELECTION
        • SEPARATOR
        • SUBMENU
        • TEXT
      • Overview: PMENU Procedure
      • Concepts: PMENU Procedure
      • Examples: PMENU Procedure
        • Example 1: Building a Menu Bar for an FSEDIT Application
        • Example 2: Collecting User Input in a Dialog Box
        • Example 3: Creating a Dialog Box to Search Multiple Variables
        • Example 4: Creating Menus for a DATA Step Window Application
        • Example 5: Associating Menus with a FRAME Application
    • PRINT Procedure
      • Syntax: PRINT Procedure
        • PROC PRINT
        • BY
        • ID
        • PAGEBY
        • SUM
        • SUMBY
        • VAR
      • Overview: PRINT Procedure
      • Concepts: PRINT Procedure
      • Error Processing in the PRINT Procedure Output
      • Examples: PRINT Procedure
        • Example 1: Selecting Variables to Print
        • Example 2: Customizing Text in Column Headings
        • Example 3: Creating Separate Sections of a Report for Groups of Observations
        • Example 4: Summing Numeric Variables with One BY Group
        • Example 5: Summing Numeric Variables with Multiple BY Variables
        • Example 6: Limiting the Number of Sums in a Report
        • Example 7: Controlling the Layout of a Report with Many Variables
        • Example 8: Creating a Customized Layout with BY Groups and ID Variables
        • Example 9: Printing All the Data Sets in a SAS Library
    • PRINTTO Procedure
      • Syntax: PRINTTO Procedure
        • PROC PRINTTO
      • Overview: PRINTTO Procedure
      • Setting Page Numbers Using SAS System Options
      • Routing SAS Log or Procedure Output Directly to a Printer
      • Examples: PRINTTO Procedure
        • Example 1: Routing to External Files
        • Example 2: Routing to SAS Catalog Entries
        • Example 3: Using Procedure Output as an Input File
        • Example 4: Routing to a Printer
    • PROTO Procedure
      • Syntax: PROTO Procedure
        • PROC PROTO
        • LINK
        • MAPMISS
      • Overview: PROTO Procedure
      • Concepts: PROTO Procedure
      • Basic C Language Types
      • Working with Character Variables
      • Working with Numeric Variables
      • Working with Missing Values
      • Function Names
      • Interfacing with External C Functions
      • Scope of Packages in PROC PROTO
      • C Helper Functions and CALL Routines
      • Results: PROTO Procedure
      • Example: Splitter Function Example
    • PRTDEF Procedure
      • Syntax: PRTDEF Procedure
        • PROC PRTDEF
      • Overview: PRTDEF Procedure
      • Input Data Set: PRTDEF Procedure
      • Examples: PRTDEF Procedure
        • Example 1: Defining Multiple Printer Definitions
        • Example 2: Creating a Ghostview Printer in SASUSER to Preview PostScript Printer Output in SASUSER
        • Example 3: Creating a Single Printer Definition That Is Available to All Users
        • Example 4: Adding, Modifying, and Deleting Printer Definitions
        • Example 5: Deleting a Single Printer Definition
    • PRTEXP Procedure
      • Syntax: PRTEXP Procedure
        • PROC PRTEXP
        • EXCLUDE
        • SELECT
      • Overview: PRTEXP Procedure
      • Concepts: PRTEXP Procedure
      • Examples: PRTEXP Procedure
        • Example 1: Writing Attributes to the SAS Log
        • Example 2: Writing Attributes to a SAS Data Set
    • PWENCODE Procedure
      • Syntax: PWENCODE Procedure
        • PROC PWENCODE
      • Overview: PWENCODE Procedure
      • Concepts: PWENCODE Procedure
      • Examples: PWENCODE Procedure
        • Example 1: Encoding a Password
        • Example 2: Using an Encoded Password in a SAS Program
        • Example 3: Saving an Encoded Password to the Paste Buffer
        • Example 4: Specifying an Encoding Method for a Password
    • QDEVICE Procedure
      • Syntax: QDEVICE Procedure
        • PROC QDEVICE
        • DEVICE
        • PRINTER
        • VAR
      • Overview: QDEVICE Procedure
      • Concepts: QDEVICE Procedure
      • Variables Common to All Reports
      • Creating a GENERAL Report
      • Creating a FONT Report
      • Creating a DEVOPTION Report
      • Creating a LINESTYLE Report
      • Creating a RECTANGLE Report
      • Creating a SYMBOL Report
      • Character Variable Lengths in Report Output Data Sets
      • Examples: QDEVICE Procedure
        • Example 1: Generate a Report for the Default Display Device
        • Example 2: Generate a General Report for All Devices
        • Example 3: Generate a Report for SAS/GRAPH Device Drivers and Universal Printers
        • Example 4: Generate a Report for the Default Printer
        • Example 5: Generate a Font Report
        • Example 6: Generate A Device Option Report
    • RANK Procedure
      • Syntax: RANK Procedure
        • PROC RANK
        • BY
        • RANKS
        • VAR
      • Overview: RANK Procedure
      • Concepts: RANK Procedure
      • Results: RANK Procedure
      • Examples: RANK Procedure
        • Example 1: Ranking Values of Multiple Variables
        • Example 2: Ranking Values within BY Groups
        • Example 3: Partitioning Observations into Groups Based on Ranks
      • References
    • REGISTRY Procedure
      • Syntax: REGISTRY Procedure
        • PROC REGISTRY
      • Overview: REGISTRY Procedure
      • Creating Registry Files with the REGISTRY Procedure
      • Examples: REGISTRY Procedure
        • Example 1: Importing a File to the Registry
        • Example 2: Listing and Exporting the Registry
        • Example 3: Comparing the Registry to an External File
        • Example 4: Comparing Registry Files
        • Example 5: Specifying an Entire Key Sequence with the STARTAT= Option
        • Example 6: Displaying a List of Fonts
    • REPORT Procedure
      • Syntax: REPORT Procedure
        • PROC REPORT
        • BREAK
        • BY
        • CALL DEFINE
        • COLUMN
        • COMPUTE
        • DEFINE
        • ENDCOMP
        • FREQ
        • LINE
        • RBREAK
        • WEIGHT
      • Overview: REPORT Procedure
      • Concepts: REPORT Procedure
      • In-Database Processing for PROC REPORT
      • How PROC REPORT Builds a Report
      • Examples: REPORT Procedure
        • Example 1: Selecting Variables for a Report
        • Example 2: Ordering the Rows in a Report
        • Example 3: Using Aliases to Obtain Multiple Statistics for the Same Variable
        • Example 4: Consolidating Multiple Observations into One Row of a Report
        • Example 5: Creating a Column for Each Value of a Variable
        • Example 6: Displaying Multiple Statistics for One Variable
        • Example 7: Storing and Reusing a Report Definition
        • Example 8: Condensing a Report into Multiple Panels
        • Example 9: Writing a Customized Summary on Each Page
        • Example 10: Calculating Percentages
        • Example 11: How PROC REPORT Handles Missing Values
        • Example 12: Creating and Processing an Output Data Set
        • Example 13: Storing Computed Variables as Part of a Data Set
        • Example 14: Using a Format to Create Groups
        • Example 15: Specifying Style Elements for ODS Output in the PROC REPORT Statement
        • Example 16: Specifying Style Elements for ODS Output in Multiple Statements
        • Example 17: Using Multilabel Formats
        • Example 18: Using the WIDTH= and CELLWIDTH= Style Attributes with PROC REPORT
    • REPORT Procedure Windows
      • Overview of 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
    • SCAPROC Procedure
      • Syntax: SCAPROC Procedure
        • PROC SCAPROC
        • RECORD
        • WRITE
      • Overview: SCAPROC Procedure
      • Results
      • Examples: SCAPROC Procedure
        • Example 1: Specifying a Record File
        • Example 2: Specifying the Grid Job Generator
    • SOAP Procedure
      • Syntax: SOAP Procedure
        • PROC SOAP
      • Overview: SOAP Procedure
      • Concepts: SOAP Procedure
      • Using PROC SOAP with Secure Socket Layer (SSL)
      • Methods of Calling SAS Registered Web Services
      • Calling a SAS Secured Service without Providing Credentials
      • Specifying an Output Log File
      • Examples: SOAP Procedure
        • Example 1: Using PROC SOAP with a SOAPEnvelope Element
        • Example 2: Using PROC SOAP without a SOAPEnvelope Element
        • Example 3: Calling a Web Service by Using a Proxy
        • Example 4: Calling a SAS Registered Web Service Using the Service Registry Service
        • Example 5: Calling a SAS Registered Web Service Using the SAS Environments File
        • Example 6: Changing the Default Timeout for Web Service Calls
    • SORT Procedure
      • Syntax: SORT Procedure
        • PROC SORT
        • BY
        • KEY
      • Overview: SORT Procedure
      • Concepts: SORT Procedure
      • In-Database Processing: PROC SORT
      • Integrity Constraints: SORT Procedure
      • Results: SORT Procedure
      • Examples: SORT Procedure
        • Example 1: Sorting by the Values of Multiple Variables
        • Example 2: Sorting in Descending Order
        • Example 3: Maintaining the Relative Order of Observations in Each BY Group
        • Example 4: Retaining the First Observation of Each BY Group
    • STANDARD Procedure
      • Syntax: STANDARD Procedure
        • PROC STANDARD
        • BY
        • FREQ
        • VAR
        • WEIGHT
      • Overview: STANDARD Procedure
      • Statistical Computations: STANDARD Procedure
      • Results: STANDARD Procedure
      • Examples: STANDARD Procedure
        • Example 1: Standardizing to a Given Mean and Standard Deviation
        • Example 2: Standardizing BY Groups and Replacing Missing Values
    • SUMMARY Procedure
      • Syntax: SUMMARY Procedure
        • PROC SUMMARY
        • VAR
      • Overview: SUMMARY Procedure
    • TABULATE Procedure
      • Syntax: TABULATE Procedure
        • PROC TABULATE
        • BY
        • CLASS
        • CLASSLEV
        • FREQ
        • KEYLABEL
        • KEYWORD
        • TABLE
        • VAR
        • WEIGHT
      • Overview: TABULATE Procedure
      • Concepts: TABULATE Procedure
      • In-Database Processing for PROC TABULATE
      • Results: TABULATE Procedure
      • Examples: TABULATE Procedure
        • Example 1: Creating a Basic Two-Dimensional Table
        • Example 2: Specifying Class Variable Combinations to Appear in a Table
        • Example 3: Using Preloaded Formats with Class Variables
        • Example 4: Using Multilabel Formats
        • Example 5: Customizing Row and Column Headings
        • Example 6: Summarizing Information with the Universal Class Variable ALL
        • Example 7: Eliminating Row Headings
        • Example 8: Indenting Row Headings and Eliminating Horizontal Separators
        • Example 9: Creating Multipage Tables
        • Example 10: Reporting on Multiple-Response Survey Data
        • Example 11: Reporting on Multiple-Choice Survey Data
        • Example 12: Calculating Various Percentage Statistics
        • Example 13: Using Denominator Definitions to Display Basic Frequency Counts and Percentages
        • Example 14: Specifying Style Elements for ODS Output
        • Example 15: Style Precedence
        • Example 16: NOCELLMERGE Option
      • References
    • TIMEPLOT Procedure
      • Syntax: TIMEPLOT Procedure
        • PROC TIMEPLOT
        • BY
        • CLASS
        • ID
        • PLOT
      • Overview: TIMEPLOT Procedure
      • Results: TIMEPLOT Procedure
      • Examples: TIMEPLOT Procedure
        • Example 1: Plotting a Single Variable
        • Example 2: Customizing an Axis and a Plotting Symbol
        • Example 3: Using a Variable for a Plotting Symbol
        • Example 4: Superimposing Two Plots
        • Example 5: Showing Multiple Observations on One Line of a Plot
    • TRANSPOSE Procedure
      • Syntax: TRANSPOSE Procedure
        • PROC TRANSPOSE
        • BY
        • COPY
        • ID
        • IDLABEL
        • VAR
      • Overview: TRANSPOSE Procedure
      • Results: TRANSPOSE Procedure
      • Examples: TRANSPOSE Procedure
        • Example 1: Performing a Simple Transposition
        • Example 2: Naming Transposed Variables
        • Example 3: Labeling Transposed Variables
        • Example 4: Transposing BY Groups
        • Example 5: Naming Transposed Variables When the ID Variable Has Duplicate Values
        • Example 6: Transposing Data for Statistical Analysis
    • XSL Procedure
      • Syntax: XSL Procedure
        • PROC XSL
      • Overview: XSL Procedure
      • Example: Transforming an XML Document into Another XML Document
  • Appendixes
    • SAS Elementary Statistics Procedures
      • Overview of SAS Elementary Statistics Procedures
      • Keywords and Formulas
      • Statistical Background
      • References
    • Descriptions of Operating Environment-Specific Procedures
    • Raw Data and DATA Steps
      • Overview of Raw Data and DATA Steps
      • CARSURVEY
      • 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.STAFF2
      • PROCLIB.SUPERV
      • RADIO
      • SALES
    • ICU License - ICU 1.8.1 and later
  • Recommended Reading


ProductRelease
Base SAS9.3_M2
Type
Usage and Reference
Copyright Date
August 2012
Last Updated
25Jan2016