Utility Procedures

The following table groups utility procedures according to task.

Utility Procedures by Task

Tasks	Procedure	Description
Supply information	COMPARE	Compares the contents of two SAS data sets.
	CONTENTS	Describes the contents of a SAS library or specific library members.
	JAVAINFO	Conveys diagnostic information about the Java environment that SAS is using.
	OPTIONS	Lists the current values of all SAS system options.
	SCAPROC	Implements the SAS Code Analyzer, which captures information about input, output, and the use of macro symbols from a SAS job while it is running.
	SQL	Supplies information through dictionary tables on an individual SAS data set as well as all SAS files active in the current SAS session. Dictionary tables can also provide information about macros, titles, indexes, external files, or SAS system options.
Manage SAS system options	OPTIONS	Lists the current values of all SAS system options.
	OPTLOAD	Reads SAS system option settings that are stored in the SAS registry or a SAS data set.
	OPTSAVE	Zaves SAS system option settings to the SAS registry or a SAS data set.
Affect printing and Output Delivery System output	DOCUMENT 2	Manipulates procedure output that is stored in ODS documents.
	FONTREG	Adds system fonts to the SAS registry.
	FORMAT	Creates user-defined formats to display and print data.
	PRINTTO	Routes procedure output to a file, a SAS catalog entry, or a printer; can also redirect the SAS log to a file.
	PRTDEF	Creates printer definitions.
	PRTEXP	Exports printer definition attributes to a SAS data set.
	TEMPLATE2	Customizes ODS output.
Create, browse, and edit data	FCMP	Enables creation, testing, and storage of SAS functions and subroutines before they are used in other SAS procedures.
	FSLIST	Browses external files such as files that contain SAS source lines or SAS procedure output.
	INFOMAPS6	Creates or updates a SAS Information Map.
	SQL	Creates SAS data sets using Structured Query Language and SAS features.
Transform data	DBCSTAB4	Produces conversion tables for the double-byte character sets that SAS supports.
	FORMAT	Creates user-defined informats to read data and user-defined formats to display data.
	SORT	Sorts SAS data sets by one or more variables.
	SQL	Sorts SAS data sets by one or more variables.
	TRANSPOSE	Transforms SAS data sets so that observations become variables and variables become observations.
	TRANTAB4	Creates, edits, and displays customized translation tables.
	XSL	Transforms an XML document into another format, such as HTML, text, or another XML document type.
Manage SAS files	APPEND	Appends one SAS data set to the end of another.
	AUTHLIB	Manages metadata-bound libraries.
	BMDP1	Invokes a BMDP program to analyze data in a SAS data set.
	CATALOG	Manages SAS catalog entries.
	CIMPORT	Restores a transport sequential file that PROC CPORT creates (usually in another operating environment) to its original form as a SAS catalog, a SAS data set, or a SAS library.
	CONVERT1	Converts BMDP system files, OSIRIS system files, and SPSS portable files to SAS data sets.
	COPY	Copies a SAS library or specific members of the library.
	CPORT	Converts a SAS catalog, a SAS data set, or a SAS library to a transport sequential file that PROC CIMPORT can restore (usually in another operating environment) to its original form.
	CV2VIEW3	Converts SAS/ACCESS view descriptors to PROC SQL views.
	DATASETS	Manages SAS files.
	EXPORT5	Reads data from a SAS data set and writes them to an external data source.
	IMPORT5	Reads data from an external data source and writes them to a SAS data set.
	MIGRATE	Migrates members in a SAS library forward to the most current release of SAS.
	PDS1	Lists, deletes, and renames the members of a partitioned data set.
	PDSCOPY1	Copies partitioned data sets from disk to tape, disk to disk, tape to tape, or tape to disk.
	PROTO	Enables registration, in batch mode, of external functions that are written in the C or C++ programming languages.
	REGISTRY	Imports registry information to the USER portion of the SAS registry.
	RELEASE1	Releases unused space at the end of a disk data set under the z/OS environment.
	SOURCE1	Provides an easy way to back up and process source library data sets.
	SQL	Concatenates SAS data sets.
	TAPECOPY1	Copies an entire tape volume or files from one or more tape volumes to one output tape volume.
	TAPELABEL1	Lists the label information of an IBM standard-labeled tape volume in the z/OS environment.
Control windows	PMENU	Creates customized menus for SAS applications.
Miscellaneous	DISPLAY	Executes SAS/AF applications.
	GROOVY	Enables SAS code to execute Groovy code on the Java Virtual Machine (JVM).
	HADOOP	Enables SAS to run Apache Hadoop code against Hadoop data.
	PWENCODE	Encodes passwords for use in SAS programs.
Manage metadata in a SAS Metadata Repository	METADATA7	Sends a method call, in the form of an XML string, to a SAS Metadata Server.
	METALIB7	Updates metadata to match the tables in a library.
	METAOPERATE7	Performs administrative tasks on a metadata server.
1See the SAS documentation for your operating environment for a description of these procedures.
2For a description of this procedure, see the SAS Output Delivery System: User's Guide.
3For a description of this procedure, see the SAS/ACCESS for Relational Databases: Reference.
4For a description of this procedure, see the SAS National Language Support (NLS): Reference Guide.
5For a description of this procedure, see the SAS/ACCESS Interface to PC Files: Reference.
6For a description of this procedure, see the Base SAS Guide to Information Maps.
7For a description of this procedure, see the SAS Language Interfaces to Metadata.