Statements Syntax Listed Alphabetically

Statements

A B C D E F G I K L M N O P R S T U W X

Name
Syntax and Description
ABORT <ABEND | RETURN> < n >;
Stops executing the current DATA step, SAS job, or SAS session.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
ABORT <ABEND | RETURN> < n > ;
Stops executing the current DATA step, SAS job, or SAS session.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
ABORT < ABEND | RETURN > < n > ;
Stops the execution of the current DATA step, SAS job, or SAS session.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
ABORT < ABEND | CANCEL <FILE> | RETURN > < n > <NOLIST>;
Stops executing the current DATA step, SAS job, or SAS session.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
ABORT;
Stops execution of a script immediately and signals an error condition.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
ACCESS=READONLY
Determines the access level of the data source.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
array-name { subscript }
Describes the elements in an array to be processed.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
ARRAY array-name { subscript } <$> < length >
< array-elements > <(initial-value-list)> ;
Defines the elements of an array.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
variable=expression;
Evaluates an expression and stores the result in a variable.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
ATTRIB variable-list-1 attribute-list-1 <...variable-list-n attribute-list-n > ;
Associates a format, informat, label, or length with one or more variables.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
ATTRIB variable-list-1 attribute-list-1< variable-list-n attribute-list-n > ;
Associates a format, informat, label, and length with one or more variables.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
ATTRIB variable-list-1 attribute-list-1 <...variable-list-n attribute-list-n > ;
Associates a format, informat, label, length, or any combination of these attributes, with one or more variables.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
ATTRIB variable-list(s) attribute-list(s) ;
Associates a format, informat, label, and length with one or more variables.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
AXIS <1...99> < options > ;
Controls the location, values, and appearance of the axes in plots and charts.
Product: SAS/GRAPH
Document: SAS/GRAPH 9.3: Reference
BY <DESCENDING> variable-1
<...<DESCENDING> variable-n >
<NOTSORTED> ;
Processes data and orders output according to the BY group.
Product: SAS/GRAPH
Document: SAS/GRAPH 9.3: Reference
BY <DESCENDING> variable-1 <... <DESCENDING> variable-n > <NOTSORTED> ;
Creates a separate graph for each BY group.
Product: Base SAS
Document: SAS 9.3 ODS Graphics: Procedures Guide
BY <DESCENDING> variable-1
< ... <DESCENDING> variable-n > <NOTSORTED> <GROUPFORMAT> ;
Controls the operation of a SET, MERGE, MODIFY, or UPDATE statement in the DATA step and sets up special grouping variables.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
BYSORT=YES | NO
Specifies for the SPD Engine to perform an automatic sort when it encounters a BY statement.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
CALL routine(parameter-1 <, ... parameter-n > );
Invokes a SAS CALL routine.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
CALL label;
Invokes a routine.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
Indicates that data lines follow.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
Specifies that data lines follow.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
Specifies that data lines that contain semicolons follow.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
CATNAME < libref. > catref
< (libref-1.catalog-1 <(ACCESS=READONLY)>
<…libref-n.catalog–n <(ACCESS=READONLY)> >)>;
CATNAME < libref. > catref CLEAR | _ALL_ CLEAR ;
CATNAME < libref. > catref LIST | _ALL_ LIST ;
Logically combines two or more catalogs into one by associating them with a catref (a shortcut name); clears one or all catrefs; lists the concatenated catalogs in one concatenation or in all concatenations.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
CHECKPOINT EXECUTE_ALWAYS;
Indicates to execute the DATA step or PROC step that immediately follows without considering the checkpoint-restart data.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
* message ;
or
/*message*/
Specifies the purpose of the statement or program.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
CONNECT TO data-source-name
CONNECT TO option(s)
Establishes a connection with the data source.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
CONNECT TO dbms-name <AS alias > <(
< database-connection-arguments > < connect-statement-arguments > )>
;
Establishes a connection with the DBMS
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
CONNECTION TO dbms-name | alias | (dbms-query)
Retrieves and uses DBMS data in a PROC SQL query or view
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
CONTINUE;
Stops processing the current DO-loop iteration and resumes processing the next iteration.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
DATA < data-set-name-1 <(data-set-options-1)> >
< ... data-set-name-n <(data-set-options-n)> >
</ <DEBUG> <NESTING> <STACK = stack-size > > <NOLIST>;
DATA _NULL_ </ <DEBUG> <NESTING> <STACK = stack-size > > <NOLIST>;
DATA view-name < data-set-name-1 <(data-set-options-1)> >
< ... data-set-name-n <(data-set-options-n)> > /
VIEW=view-name <(< password-option > <SOURCE=source-option > )>
<NESTING> <NOLIST>;
DATA data-set-name / PGM=program-name <(< password-option > <SOURCE=source-option > )>
<NESTING> <NOLIST>;
DATA VIEW=view-name <(password-option)> <NOLIST>;
DESCRIBE;
DATA PGM=program-name <(password-option)> <NOLIST>;
< DESCRIBE;>
< REDIRECT INPUT | OUTPUT old-name-1 = new-name-1 <… old-name-n = new-name-n > ;>
< EXECUTE;>
Begins a DATA step and provides names for any output SAS data sets, views, or programs.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
DATALINES;
Specifies that data lines follow.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
DATALINES4;
Indicates that data lines that contain semicolons follow.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
DATAPATH=('path1' 'path2'...)
Specifies a list of paths in which to store data partitions (.dpf) for an SPD Engine data set.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
DECLARE APPENDER appender-object ("appender-name",
"FileRefAppender", "FILEREF =fileref" <, PATTERN: "pattern">
<, THRESHOLD: "threshold"> );
Declares an appender object; creates an instance of an appender object and initializes data for an appender object.
Product: Base SAS
Document: SAS 9.3 Logging: Configuration and Programming Reference
DECLARE object object-reference;
DECLARE object object-reference <(argument_tag-1: value-1, ... argument_tag-n: value-n )>;
Declares a hash or hash iterator object; creates an instance of and initializes data for a hash or hash iterator object.
Product: Base SAS
Document: SAS 9.3 Component Objects: Reference
DECLARE JAVAOBJ object-reference;
DECLARE JAVAOBJ object-reference ("java-class", < argument-1, ... argument-n > );
Declares a Java object; creates an instance of and initializes data for a Java object.
Product: Base SAS
Document: SAS 9.3 Component Objects: Reference
DECLARE LOGGER logger-object ("logger-name" <, ADDITIVITY: TRUE | FALSE>
<, LEVEL: "level">
<, APPENDERREF:" appender-name"<…, APPENDERREF: "appender-name"> > );
Declares a logger object; creates an instance of a logger object and initializes data for a logger object.
Product: Base SAS
Document: SAS 9.3 Logging: Configuration and Programming Reference
DELETE;
Stops processing the current observation.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
DESCRIBE;
Retrieves source code from a stored compiled DATA step program or a DATA step view.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
DISCONNECT FROM < data-source-name > < alias >
Ends the connection to the data source.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
DISCONNECT FROM dbms-name | alias
Terminates the connection to the DBMS
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DISPLAY window < .group > <NOINPUT> <BLANK> <BELL > <DELETE>;
Displays a window that is created with the WINDOW statement.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
DM < window > 'command(s)' < window > <CONTINUE> ;
Submits SAS Program Editor, Log, Procedure Output or text editor commands as SAS statements.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
DO index-variable=specification-1 <, ... specification-n > ;
... more SAS statements ...
END;
Executes statements between the DO and END statements repetitively, based on the value of an index variable.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
DO;
... more SAS statements ...
END;
Specifies a group of statements to be executed as a unit.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
DO UNTIL (expression);
... more SAS statements ...
END;
Executes statements in a DO loop repetitively until a condition is true.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
DO WHILE (expression);
... more SAS statements ...
END;
Executes statements in a DO-loop repetitively while a condition is true.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
DROP variable-list;
Excludes variables from output SAS data sets.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
DSNEXST 'physical-filename ';
Checks to see whether the specified physical file exists and is available.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
ECHO ON | OFF;
Controls the display of characters that are sent from the server while a WAITFOR statement executes.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
END;
Ends a DO group or SELECT group processing.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
ENDOBS= n
Specifies the end observation number in a user-defined range of observations to be processed.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
ENDRSUBMIT <CANCEL> ;
Marks the end of a block of statements that a client session submits to a server session for execution.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
ENDSAS;
Terminates a SAS job or session after the current DATA or PROC step executes.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
ERROR < message >;
Sets _ERROR_ to 1. A message written to the SAS log is optional.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
EXECUTE (data-source-specific-SQL-statement(s))
BY
< data-source-name > < alias >
Sends data source-specific, non-query SQL statements to the data source.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
EXECUTE (dbms-specific-sql-statement) BY dbms-name | alias ;
Sends DBMS-specific, non-query SQL statements to the DBMS
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
EXECUTE;
Executes a stored compiled DATA step program.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
FILE PRINT ODS <=(ODS-suboption(s))> < options > ;
Creates an ODS output object by binding the data component to the table definition (template). As an option, the FILE Statement lists the variables to include in the ODS output, and it specifies options that control the way that the variables are formatted.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
FILE file-specification <ENCODING='encoding-value' > < options > < host-options > ;
Specifies the current output file for PUT statements.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
FILE file-specification <ENCODING='encoding-value'> < option-list > < host-option-list > ;
Specifies the current output file for PUT statements.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
FILE file-specification < type > <ENCODING=encoding-value > < options > ;
FILE LOG | PRINT < options > ;
Specifies the current output file for PUT statements.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FILE file-specification < device-type > < options > < operating-environment-options >;
Specifies the current output file for PUT statements.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
FILENAME 'filespec' < access-method > < operating-environment-options >
Associates a SAS fileref with an external file.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
FILENAME fileref CATALOG 'catalog' < catalog-options >;
Enables you to reference a SAS catalog as an external file.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
FILENAME fileref EMAIL <'address' > < email-options >;
Enables you to send electronic mail programmatically from SAS using the SMTP (Simple Mail Transfer Protocol) e-mail interface.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
FILENAME fileref FTP 'external-file' < ftp-options >;
Enables you to access remote files by using the FTP protocol.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
FILENAME fileref JMS <"destination-name" > < access-method-options >
Assigns a fileref that enables you to access a JMS destination by using the JMS access method to send and receive messages of the type TextMessage.
Product: SAS Integration Technologies
Document: Application Messaging with SAS 9.3
FILENAME fileref SFTP 'external-file' < sftp-options >;
Enables you to access remote files by using the SFTP protocol.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
FILENAME fileref SOCKET ' hostname:portno '
< tcpip-options >;
FILENAME fileref SOCKET ':portno' SERVER
< tcpip-options >;
Enables you to read from or write to a TCP/IP socket.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
FILENAME fileref URL 'external-file' < url-options >;
Enables you to access remote files by using the URL access method.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
FILENAME filref WEBDAV 'external-file' < webdav-options >;
Enables you to access remote files by using the WebDAV protocol.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
FILENAME fileref < device-type > 'external-file' <ENCODING='encoding-value'>
<'host-options'> <LOCKINTERNAL= AUTO | SHARED> ;
FILENAME fileref device-type <'external-file'> <ENCODING='encoding-value'>
<'host-options'> <LOCKINTERNAL= AUTO | SHARED> ;
FILENAME fileref ('pathname-1' ... 'pathname-n') <ENCODING='encoding-value'>
<'host-options'> <LOCKINTERNAL= AUTO | SHARED> ;
FILENAME fileref directory-name <ENCODING='encoding-value'>
<LOCKINTERNAL= AUTO | SHARED> ;
FILENAME fileref < access-method > 'external-file' access-information;
FILENAME fileref CLEAR | _ALL_ CLEAR;
FILENAME fileref LIST | _ALL_ LIST;
Associates a SAS fileref with an external file or output device; disassociates a fileref and external file; lists attributes of external files.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
FILENAME fileref < device-type > 'external-file' <ENCODING='encoding-value'> < host-option-list > ;
FILENAME fileref device-type <'external-file'> <ENCODING=encoding-value > < host-option-list > ;
FILENAME fileref < device-type > ('directory-1'<,…directory-n'> ) <ENCODING=encoding-value
>
< host-option-list > ;
Associates a SAS fileref with an external file or a logical file device.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
FILENAME fileref < device-type > 'physical-filename' < host-options > ;
FILENAME fileref < device-type > ('physical–filename–1'... 'physical-filename-n') < host-options > ;
FILENAME fileref | _ALL_ CLEAR ;
FILENAME fileref | _ALL_ LIST ;
Associates a SAS fileref with an external file.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FILENAME fileref < device-type > 'external-file' <ENCODING='encoding-value'>
< options > < operating-environment-options >;
FILENAME fileref < device-type > < options > < operating-environment-options >;
FILENAME fileref CLEAR | _ALL_ CLEAR ;
FILENAME fileref LIST | _ALL_ LIST ;
Associates a SAS fileref with an external file or an output device, disassociates a fileref and external file, or lists attributes of external files.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
FILENAME fileref CLIPBRD <BUFFER=paste-buffer-name >;
Enables you to read text data from and write text data to the clipboard on the host computer.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
FOOTNOTE < n > <'text'|"text"> ;
Writes up to 10 lines of text at the bottom of the procedure or DATA step output.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
FOOTNOTE < n > <'text' | “text”> ;
Prints up to ten lines of text at the bottom of the procedure output.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
FOOTNOTE < n > < 'text' | "text" > ;
Prints up to ten lines at the bottom of the procedure output.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FOOTNOTE <1...10> < text-argument(s) > ;
Writes up to 10 lines of text at the bottom of the graph.
Product: SAS/GRAPH
Document: SAS/GRAPH 9.3: Reference
FOOTNOTE <1...10> < text-options > <"text-string–1"> ... < text-options > <"text-string-n"> ;
Writes up to 10 lines of text at the bottom of the graph.
Product: Base SAS
Document: SAS 9.3 ODS Graphics: Procedures Guide
FOOTNOTE < n > < ods-format-options > <'text' | “text” >;
Writes up to 10 lines of text at the bottom of the procedure or DATA step output.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
Associates SAS formats or user-defined formats with variables.
Product: Base SAS
Document: SAS 9.3 ODS Graphics: Procedures Guide
FORMAT variable-1 < ... variable-n > < format > <DEFAULT=default-format >;
FORMAT variable-1 < ... variable-n > format <DEFAULT=default-format >;
FORMAT variable-1 < ... variable-n > format variable-1 < ... variable-n > format;
Associates formats with variables.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
GO TO label;
Directs program execution immediately to the statement label that is specified and, if followed by a RETURN statement, returns execution to the beginning of the DATA step.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
GOPTIONS < options-list > ;
Temporarily sets default values for many graphics attributes and device parameters used by SAS/GRAPH procedures.
Product: SAS/GRAPH
Document: SAS/GRAPH 9.3: Reference
GOTO label;
Redirects execution of a script to the specified script statement.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
IDXBY=YES | NO
Specifies whether to use indexes when processing BY statements in the SPD Engine.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
IF expression;
Continues processing only those observations that meet the condition of the specified expression.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
IF expression THEN statement;
< ELSE statement;>
Executes a SAS statement for observations that meet specific conditions.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
IF condition GOTO label;
IF NOT condition GOTO label;
Checks conditions of labeled script statements before they execute.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
%INCLUDE source-1 < ...source-n > </<SOURCE2> <S2=length >
<ENCODING='encoding-value'> < host-options > >
;
Brings a SAS programming statement, data lines, or both into a current SAS program.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
%INCLUDE source </<ENCODING='encoding-value'> < host-options > > ;
Includes and executes SAS statements and data lines.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
%INCLUDE source-1 < . . . source-n >
</<SOURCE2> <S2=length > <S2V=column > <JCLEXCL>
<ENCODING='encoding-value' > < host-options > >
;
Includes SAS statements and data lines.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
%INCLUDE source(s)
</<SOURCE2> <S2=length > < operating-environment-options > >;
Brings a SAS programming statement, data lines, or both, into a current SAS program.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
INDEXPATH=('path1' )< 'path2'... >
Specifies a path or list of paths in which to store the two types of index component files (.hbx and .idx) associated with an SPD Engine data set.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
INFILE file-specification <ENCODING='encoding-value'> < options > < host-options > ;
Identifies an external file to read with an INPUT statement.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
INFILE file-specification <ENCODING='encoding-value'> < options > < host-options > ;
Specifies an external file to read with an INPUT statement.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
INFILE file-specification < type > <ENCODING=encoding-value > < options > ;
INFILE DATALINES | CARDS < options > ;
Specifies an external file to read with an INPUT statement.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
INFILE file-specification < device-type > < options > < operating-environment-options >;
INFILE DBMS-specifications;
Specifies an external file to read with an INPUT statement.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
INFORMAT variable-1 < …variable-n > < informat >;
INFORMAT < variable-1 > < … variable-n > <DEFAULT=default-informat >;
INFORMAT variable-1 < …variable-n > informat <DEFAULT=default-informat >;
Associates informats with variables.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
INPUT variable <$> start-column <- end-column >
<.decimals > < @ | @@ > ;
Reads input values from specified columns and assigns them to the corresponding SAS variables.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
INPUT < pointer-control > variable informat. < @ | @@ >;
INPUT < pointer-control > (variable-list) (informat-list)
< @ | @@ >;
INPUT < pointer-control > (variable-list) (< n*> informat.)
< @ | @@ >;
Reads input values with specified informats and assigns them to the corresponding SAS variables.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
INPUT < pointer-control > variable <$> <&> < @ | @@ >;
INPUT < pointer-control > variable < : | & | ~ >
< informat. > < @ | @@ >;
Scans the input data record for input values and assigns them to the corresponding SAS variables.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
INPUT < pointer-control > variable= <$> < @ | @@ >;
INPUT < pointer-control > variable= informat. < @ | @@ >;
INPUT variable= <$> start-column <-end-column >
<.decimals > < @ | @@ >;
Reads data values that appear after a variable name that is followed by an equal sign and assigns them to corresponding SAS variables.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
INPUT < specification(s) > < @ | @@ >;
Describes the arrangement of values in the input data record and assigns input values to the corresponding SAS variables.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
INPUT <NODISPLAY> 'prompt';
Displays a prompt to the user that requests a response for the server.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
KEEP variable-list;
Specifies the variables to include in output SAS data sets.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
KILLTASK _ALL_ |task1...taskn ;
For asynchronous tasks, forces one or more active tasks or server sessions to terminate immediately.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
Associates descriptive labels with variables.
Product: Base SAS
Document: SAS 9.3 ODS Graphics: Procedures Guide
LABEL variable-1=label-1 ... < variable-n=label-n >;
LABEL variable-1=' ' ... < variable-n=' ' >;
Assigns descriptive labels to variables.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
label: statement;
Identifies a statement that is referred to by another statement.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
LEAVE;
Stops processing the current loop and resumes with the next statement in the sequence.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
LEGEND <1...99> < options > ;
Controls the location and appearance of legends on two-dimensional plots, contour plots, maps, and charts.
Product: SAS/GRAPH
Document: SAS/GRAPH 9.3: Reference
LENGTH < variable-1 > < ...variable-n > <$> length <DEFAULT=n >;
Specifies the number of bytes for storing variables.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
LENGTH < variable-1 > <…variable-n > <$> < length > <DEFAULT=n > ;
Specifies the number of bytes SAS uses to store numeric variables.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
LENGTH variables <$> length . . . <DEFAULT=n > ;
Specifies how many bytes SAS uses to store a variable's value.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
LENGTH variable-specification(s) <DEFAULT=n >;
Specifies the number of bytes for storing variables.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
provides additional control over the way that SAS processes PC files data.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
LIBNAME libref JMPpath< FMTLIB=libref.format-catalog >;
Associates a libref with a JMP data table and enables you to read and write JMP data tables.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
LIBNAME libref JMPpath< FMTLIB=libref.format-catalog >;
Associates a libref with a JMP data table and enables you to read and write JMP data tables.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
LIBNAME libref < engine > 'SAS-library' < options > WEBDAV USER="user-ID "
PASSWORD="user-password " WEBDAV options;
LIBNAME libref CLEAR | _ALL_ CLEAR ;
LIBNAME libref LIST | _ALL_ LIST ;
Associates a libref with a SAS library and enables access to a WebDAV (Web-based Distributed Authoring And Versioning) server.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
LIBNAME libref engine-name
< SAS/ACCESS-connection-options >
< SAS/ACCESS-LIBNAME-options > ;
LIBNAME libref CLEAR | _ALL_ CLEAR ;
LIBNAME libref LIST | _ALL_ LIST ;
Associates a SAS libref with a DBMS database, schema, server, or a group of tables and views.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
LIBNAME < libref > engine-name < physical-path and filename >
<SAS/ACCESS engine-connection-options>
<SAS/ACCESS LIBNAME-options> ;
LIBNAME libref CLEAR| _ALL_;
LIBNAME libref LIST| _ALL_;
Associates a SAS libref with a workbook or database.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
LIBNAME libref SASEDOC 'path' <sasedoc-engine-option> < options > ;
Uses the SASEDOC engine to associate a SAS libref (library reference) with one or more ODS output objects that are stored in an ODS document.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
LIBNAME libref SASESOCK “port-specifier <TIMEOUT=time-in-seconds > ;
Associates a libref with a TCP/IP pipe (instead of a physical disk device) for processing input and output. The SASESOCK engine is required for SAS/CONNECT applications that implement MP CONNECT with piping.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
LIBNAME libref < engine > 'SAS-library' < options > < engine/host-options > ;
LIBNAME libref < engine > ('library-1'<,...'library-n'> ) < options > ;
LIBNAME libref ('library-1'|libref-1,...,'library-n'|libref-n);
LIBNAME libref CLEAR | _ALL _ CLEAR;
LIBNAME libref LIST | _ALL _ LIST;
Associates or disassociates a SAS library with a libref (a shortcut name); clears one or all librefs; lists the characteristics of a SAS library; concatenates SAS libraries; implicitly concatenates SAS catalogs; turns off file locking.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
LIBNAME libref < engine > '('SAS-data-library-1' <,…'SAS-data-library-n'> ) ' <MEMLIB> ,
<FILELOCKWAIT> ;
LIBNAME libref _ALL_ LIST;
LIBNAME libref _ALL_ CLEAR;
Associates a libref with a SAS library and lists file attributes for a SAS library.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
LIBNAME libref < engine > <'< file-system-prefix > physical-filename'> < engine/host-options > ;
LIBNAME libref < engine > <(library-specification, ..., library-specification-n)>
< engine/host-options > ;
LIBNAME libref | _ALL_ CLEAR ;
LIBNAME libref | _ALL_ LIST ;
Assigns a SAS libref and an engine to a SAS library.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
LIBNAME libref < engine >
< 'SAS-library'> SERVER=server-ID < options >
< engine/operating environment-options > ;
Associates a libref (a shortcut name) with a SAS library that is located on the server for client access.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
LIBNAME libref INFOMAPS MAPPATH="location" < options >
Associates a SAS libref with information maps.
Product: Base SAS
Document: Base SAS 9.3 Guide to Information Maps
LIBNAME libref < engine > 'SAS-library'
< options > < engine/host-options >;
LIBNAME libref CLEAR | _ALL_ CLEAR ;
LIBNAME libref LIST | _ALL_ LIST ;
LIBNAME libref < engine > (library-specification-1 < ... library-specification-n >)
< options >;
Associates or disassociates a SAS library with a libref (a shortcut name), clears one or all librefs, lists the characteristics of a SAS library, concatenates SAS libraries, or concatenates SAS catalogs.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
LIBNAME libref < engine > < 'SAS-data-library'> SERVER=< server-node.>
server-name | _ _ port-number
< options > ;
In a client session, associates a libref (a shortcut name) with a SAS library that is located on the server for client access. In a server session, predefines a server library that clients are permitted to access.
Product: SAS/SHARE
Document: SAS/SHARE 9.3 User's Guide
LINK label;
Directs program execution immediately to the statement label that is specified and, if followed by a RETURN statement, returns execution to the statement that follows the LINK statement.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
LIST;
Writes to the SAS log the input data record for the observation that is being processed.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
%LIST < n <:m | − m > >;
Displays lines that are entered in the current session.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
LISTTASK <_ALL_|task > ;
Lists all active connections or tasks and identifies the execution status of each connection or task.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
LOCK libref <.member-name <.member-type | .entry-name.entry-type > >
< LIST | QUERY | SHOW | CLEAR >;
Acquires and releases an exclusive lock on an existing SAS file.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
LOCK
libref <.member-name <.member-type > | <.member-name.entry-name.entry-type > < LIST | CLEAR > > ;
Places an exclusive lock on a specified data object.
Product: SAS/SHARE
Document: SAS/SHARE 9.3 User's Guide
LOG 'message';
Sends a message to the client SAS log.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
LOSTCARD;
Resynchronizes the input data when SAS encounters a missing or invalid record in data that has multiple records per observation.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
MERGE SAS-data-set-1 <(data-set-options)>
SAS-data-set-2 <(data-set-options) >
< ... SAS-data-set-n <(data-set-options)> >
<END=variable >;
Joins observations from two or more SAS data sets into a single observation.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
METAPATH=('path1' )< 'path2'... >
Specifies a list of overflow paths in which to store metadata (.mdf) component files for an SPD Engine data set.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
Valid data types that are supported by Jet provider.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
MISSING character(s);
Assigns characters in your input data to represent special missing values for numeric data.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
MODIFY master-data-set <(data-set-options)> transaction-data-set <(data-set-options)>
<NOBS=variable > <END=variable >
<UPDATEMODE=MISSINGCHECK | NOMISSINGCHECK >;
BY by-variable;
MODIFY master-data-set <(data-set-options)> KEY=index </ UNIQUE> <NOBS=variable >
<END=variable >;
MODIFY master-data-set <(data-set-options)> <NOBS=variable > POINT=variable ;
MODIFY master-data-set <(data-set-options)> <NOBS=variable > <END=variable >;
Replaces, deletes, and appends observations in an existing SAS data set in place but does not create an additional copy.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
NOTE < text-arguments(s) > ;
Writes lines of text in the output.
Product: SAS/GRAPH
Document: SAS/GRAPH 9.3: Reference
NOTIFY 'message';
Sends a message in a window to the client session.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
;
or
;;;;
Signals the end of data lines or acts as a placeholder.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
ODS _ALL_ CLOSE;
Closes all open ODS output destinations.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS CHTML <(<ID=> identifier)> < action > ;
ODS CHTML <(<ID=> identifier)> < option(s) > ;
Opens, manages, or closes the CHTML destination, which produces a compact, minimal HTML that does not use style information.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS CSVALL < (<ID=> identifier)> < action > ;
ODS CSVALL <(<ID=> identifier)> < option(s) > ;
Opens, manages, or closes the CSVALL destination, which produces HTML output containing columns of data values that are separated by commas, and produces tabular output with titles, notes, and bylines.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS DECIMAL_ALIGN;
ODS NO_DECIMAL_ALIGN;
Controls the justification of numeric columns when no justification is specified.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS DOCBOOK < (<ID=> identifier)> < action > ;
ODS DOCBOOK <(<ID=> identifier)> < option(s) > ;
Opens, manages, or closes the DOCBOOK destination, which produces XML output that conforms to the DocBook DTD by OASIS.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS DOCUMENT action;
ODS DOCUMENT
< NAME= < libref. > member-name <(access–option)> >
< DIR=(< PATH=path <(access-option)> < LABEL=“label”> > )>
< CATALOG=permanent-catalog | _NULL_> ;
Opens, manages, or closes the DOCUMENT destination, which produces a hierarchy of output objects that enables you to produce multiple ODS output formats without rerunning a PROC or DATA step.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS ESCAPECHAR= 'escape-character';
Defines a representative character to be used in output strings.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS < ODS-destination > EXCLUDE exclusion(s) | ALL | NONE ;
Specifies output objects to exclude from ODS destinations.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
Specifies the settings for your graphics output.
Product: Base SAS
Document: SAS 9.3 ODS Graphics: Procedures Guide
ODS GRAPHICS < OFF | ON > </ option(s) > ;
Enables or disables ODS Graphics processing and sets graphics environment options. This statement affects ODS template-based (ODS Graphics) graphics only. The ODS GRAPHICS statement does not affect device-based graphics (SAS/GRAPH).
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS HTML <(<ID=> identifier)> < action > ;
ODS HTML <(<ID=> identifier)> < option(s) > ;
Opens, manages, or closes the HTML destination, which produces HTML 4.0 output that contains embedded style sheets.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS HTML <(<ID=> identifier)> < action > ;
ODS HTML <(<ID=> identifier)> < option(s) > ;
Opens or closes the HTML destination.
Product: SAS/GRAPH
Document: SAS/GRAPH 9.3: Reference
ODS HTML3 <(<ID=> identifier)> < action > ;
ODS HTML3 <(<ID=> identifier)> < option(s) > ;
Opens, manages, or closes the HTML3 destination, which produces HTML 3.2 formatted output.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS HTMLCSS < (<ID=> identifier)> < action > ;
ODS HTMLCSS <(<ID=> identifier)> < option(s) > ;
Opens, manages, or closes the HTMLCSS destination, which produces HTML output with cascading style sheets.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS IMODE < (<ID=> identifier)> < action > ;
ODS IMODE <(<ID=> identifier)>) < option(s) > ;
Opens, manages, or closes the IMODE destination, which produces HTML output as a column of output separated by lines.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS LISTING < action > ;
ODS LISTING <DATAPANEL=number | DATA | PAGE > <FILE=file-specification > ;
Opens, manages, or closes the LISTING destination.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS MARKUP <(<ID=> identifier)> < action > ;
ODS MARKUP <(<ID=> identifier)> < option(s) > <TAGSET=tagset-name > < action > ;
Opens, manages, or closes the MARKUP destination, which produces SAS output that is formatted using one of many different markup languages.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS NO_DECIMAL_ALIGN;
Right-justifies numeric columns when no justification is specified.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS OUTPUT action;
ODS OUTPUT data-set-definition(s);
Produces a SAS data set from an output object and manages the selection and exclusion lists for the OUTPUT destination.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS PACKAGE (< name > ) OPEN < options > ;
ODS PACKAGE (< name > ) PUBLISH
transport PROPERTIES(transport-property-1="value-1" ...transport-property-n ="value-n");
ODS PACKAGE (< name > ) ADD FILE=file-specification | DATA=member-specification
MIMETYPE="string" <PATH=path-specification > < options > ;
ODS PACKAGE (< name > ) CLOSE <CLEAR> ;
The ODS PACKAGE statement opens, adds to, publishes, or closes one SAS Output Delivery System (ODS) package object.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
PATH < (APPEND) | (PREPEND) | (REMOVE) > location(s);
PATH path-argument;
Specifies locations to write to or read from when creating or using PROC TEMPLATE definitions and the order in which to search for them.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS PCL <(<ID=> identifier)> < action > ;
ODS PCL <(<ID=> identifier)> < option(s) > ;
Opens, manages, or closes the PCL destination, which produces printable output for PCL (HP LaserJet) files.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS PDF <(<ID=> identifier)> < action > ;
ODS PDF <(<ID=> identifier)> < option(s) > ;
Opens, manages, or closes the PDF destination, which produces PDF output, a form of output that is read by Adobe Acrobat and other applications.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS PHTML action;
ODS PHTML < option(s) > ;
Opens, manages, or closes the PHTML destination, which produces simple HTML output that uses twelve style elements and no class attributes for the presentation. Class attributes are used only for the justification.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS PRINTER <(<ID=> identifier)> < action > ;
ODS PRINTER <(<ID=> identifier)> < option(s) > ;
Opens, manages, or closes the PRINTER destination, which produces printable output.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS PROCLABEL 'string';
ODS PROCLABEL= 'string';
Enables you to change a procedure label.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS PROCTITLE;
ODS NOPROCTITLE;
Determines whether to write the title that identifies the procedure that produces the results in the output.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS PS <(<ID=> identifier)> < action > ;
ODS PS <(<ID=> identifier)> < option(s) > ;
Opens, manages, or closes the PS destination, which produces PostScript (PS) output.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS RESULTS ON | OFF ;
ODS RESULTS= ON | OFF ;
Tracks ODS output in the window.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS RTF <(<ID=> identifier)> action;
ODS RTF <(<ID=> identifier)> < option(s) > ;
Opens, manages, or closes the RTF destination, which produces output written in Rich Text Format for use with Microsoft Word 2002.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS < ODS-destination > SELECT selection(s) | ALL | NONE ;
Specifies output objects for ODS destinations.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS < ODS-destination > SHOW;
Writes the specified selection or exclusion list to the SAS log.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS directory.tagset-name file-specification < option(s) > ;
ODS directory.tagset-name file-specification action;
Opens, manages, or closes the specified tagset destination.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS TAGSETS.RTF <(<ID=> identifier)> action;
ODS TAGSETS.RTF <(<ID=> identifier)> < option(s) > ;
Opens, manages, or closes the RTF destination, which produces measured output that is written in Rich Text Format for use with Microsoft Word 2002.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS TEXT= 'text-string'
Inserts text into your ODS output.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS TRACE ON </option(s) > ;
ODS TRACE OFF;
Writes to the SAS log a record of each output object that is created, or suppresses the writing of this record.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS USEGOPT | NOUSEGOPT;
Determines whether ODS uses traditional SAS/GRAPH option settings.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS VERIFY < ON | OFF | ERROR | WARN > ;
Prints or suppresses a message indicating that a style definition or a table definition being used is not supplied by SAS.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
ODS WML < (<ID=> identifier)> action;
ODS WML < (<ID=> identifier)> < option(s) > ;
Opens, manages, or closes the WML destination, which uses the Wireless Application Protocol (WAP) to produce a Wireless Markup Language (WML) DTD with a simple list for a table of contents.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
OPTIONS options-1 <. . . option-n > ;
Changes the value of one or more SAS system options.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
OPTIONS option(s);
Specifies or changes the value of one or more SAS system options.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
OUTPUT < data-set-name(s) >;
Writes the current observation to a SAS data set.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
PAGE;
Skips to a new page in the SAS log.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
PARTSIZE= n | nM | nG | nT
Specifies the maximum size (in megabytes, gigabytes, or terabytes) that the data component partitions can be. The value is specified when the SPD Engine data set is created. This size is a fixed size. This specification applies only to the data component files.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
PATTERN <1...255> <COLOR=pattern-color |_style_ >
<IMAGE= fileref | external-file” >
<IMAGESTYLE= TILE | FIT>
<REPEAT=number-of-times >
<VALUE=bar/block-pattern | map/plot-pattern | pie/star-pattern > ;
Defines the characteristics of patterns used in graphs.
Product: SAS/GRAPH
Document: SAS/GRAPH 9.3: Reference
PUT < specification > <_ODS_> <@|@@> ;
Writes data values to a special buffer from which they can be written to the data component and then formatted by ODS.
Product: Base SAS
Document: SAS 9.3 Output Delivery System: User's Guide
PUT variable start-column <– end-column >
<.decimal–places > < @ | @@ >;
Writes variable values in the specified columns in the output line.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
PUT < pointer-control > variable format. < @ | @@ >;
PUT < pointer-control > (variable-list) (format-list)
< @ | @@ >;
Writes variable values with the specified format in the output line.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
PUT < pointer-control > variable < @ | @@ >;
PUT < pointer-control > < n*> 'character-string'
< @ | @@ >;
PUT < pointer-control > variable < : | ~ > format. < @ | @@ >;
Writes variable values and the specified character strings in the output line.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
PUT < pointer-control > variable= < format. > < @ | @@ >;
PUT variable= start-column <-end-column >
< .decimal-places > < @ | @@ >;
Writes variable values after the variable name and an equal sign.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
PUT < specification(s) > <_ODS_> < @ | @@ >;
Writes lines to the SAS log, to the SAS output window, or to an external location that is specified in the most recent FILE statement.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
PUTLOG 'message';
Writes a message to the SAS log.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
RDISPLAY < <CONNECTREMOTE=> server-ID > ;
Creates a Log window to display the lines from the log and an Output window to list the output generated from the execution of the statements within an asynchronous RSUBMIT block.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
REDIRECT INPUT | OUTPUT old-name-1 = new-name-1 < ... old-name-n = new-name-n >;
Points to different input or output SAS data sets when you execute a stored program.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
REMOVE < data-set-name(s) >;
Deletes an observation from a SAS data set.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
RENAME old-name-1=new-name-1 ... < old-name-n=new-name-n >;
Specifies new names for variables in output SAS data sets.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
REPLACE < data-set-name-1 > < ... data-set-name-n >;
Replaces an observation in the same location.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
RESETLINE;
Restarts the program line numbers in the SAS log to 1.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
RETAIN <element-list(s) < initial-value(s) | (initial-value-1) | (initial-value-list-1) >
< ... element-list-n < initial-value-n | (initial-value-n ) | (initial-value-list-n)> >> ;
Causes a variable that is created by an INPUT or assignment statement to retain its value from one iteration of the DATA step to the next.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
RETURN;
Stops executing statements at the current point in the DATA step and returns to a predetermined point in the step.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
RETURN;
Signals the end of a routine.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
RGET < <CONNECTREMOTE=> server-ID > ;
Retrieves the log and output that are created by an asynchronous RSUBMIT and merges them into the Log and Output windows of the client session.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide

CONNECT TO dbms-name <AS alias > <(dbms-argument-1=value ... < dbms-argument-n=value > )> ;
SELECT . . . FROM CONNECTION TO dbms-name | alias (dbms-query);
EXECUTE (SQL-statement) BY dbms-name | alias;
DISCONNECT FROM dbms-name | alias;

CONNECT TO REMOTE <AS alias >
(SERVER=serverid <SAPW=server-access-password >
<DBMS=dbms-name >
<PT2DBPW=passthrough-to-DBMS-password >
<DBMSARG=(dbms-argument-1=value ... < dbms-argument-n=value > )> );
SELECT . . . FROM CONNECTION TO REMOTE | alias (dbms-query);
EXECUTE (SQL-statement) BY REMOTE | alias;
DISCONNECT FROM REMOTE | alias;
Statements used for remote SQL pass-through.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
RSUBMIT < options > ;
ENDRSUBMIT <CANCEL> ;
RDISPLAY <CONNECTREMOTE=> < server-ID;>
RGET <CONNECTREMOTE=> < server-ID > ;
%SYSRPUT macro-variable=value;
%SYSLPUT macro-variable=value </REMOTE=server-ID > ;
WAITFOR <_ANY_ | _ALL_> task1...taskn <TIMEOUT=seconds > ;
LISTTASK <_ALL_ | task > ;
KILLTASK <_ALL_ | task1...taskn > ;
Marks the beginning of a block of statements that a client session submits to a server session for execution.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
RUN <CANCEL>;
Executes the previously entered SAS statements.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
%RUN;
Ends source statements following a %INCLUDE * statement.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
Reduces I/O processing by holding the entire data set in memory.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
SASFILE < libref.> member-name <.member-type > <(password-option(s))>
OPEN | LOAD | CLOSE ;
Opens a SAS data set and allocates enough buffers to hold the entire file in memory.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
SCANFOR pause-specification-1 <... pause-specification-n > ;
Specifies a pause until conditions are met (an alias for WAITFOR).
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
SELECT <(select-expression)> ;
WHEN-1 (when-expression-1 < ..., when-expression-n > ) statement;
< ... WHEN -n (when-expression-1 < ...,when-expression-n > ) statement;>
< OTHERWISE statement;>
END;
Executes one of several statements or groups of statements.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
SET < SAS-data-set(s) <(data-set-options(s) )> >
< options >;
Reads an observation from one or more SAS data sets.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
SIGNOFF < options > ;
Ends the connection between a client session and a server session.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
SIGNON < options >
Initiates a connection between a client session and a server session.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
SKIP < n >;
Creates a blank line in the SAS log.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
PROC SQL < options-list>
CONNECT TO data-source-name AS < alias > <(connect-statement-arguments)> ,
<(database-connection-arguments)>
DISCONNECT FROM < data-source-name > < alias >
EXECUTE (data-source-specific-SQL-statement)
BY
< data-source-name > < alias >
SELECT column-list
FROM
CONNECTION TO data source-name
AS
< alias > < database-connection-arguments;>
Implements the Structured Query Language for SAS.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
STARTOBS= n
Specifies the starting observation number in a user-defined range of observations to be processed.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
STOP;
Stops execution of the current DATA step.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
STOP;
Stops execution of a script under normal conditions.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
variable+expression;
Adds the result of an expression to an accumulator variable.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
SYMBOL <1...255> <COLOR=symbol-color|_style_ >
<MODE=EXCLUDE | INCLUDE>
<REPEAT=number-of-times >
<STEP=distance < units > >
< appearance-options >
< interpolation-option >
<SINGULAR=n > ;
Defines the characteristics of symbols that display the data plotted by a PLOT statement used by PROC GBARLINE, PROC GCONTOUR, and PROC GPLOT.
Product: SAS/GRAPH
Document: SAS/GRAPH 9.3: Reference
LIBNAME libref PCFILES LIBNAME options connection-options
LIBNAME libref CLEAR | _ALL_ CLEAR
LIBNAME libref LIST| _ALL_ LIST;
Associates a SAS libref with a workbook, database, or ODBC data source.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
PROC SQL option(s)
CONNECT TO data-source-name AS alias
( CONNECT statement-arguments
DATABASE connection-arguments
DISCONNECT FROM data-source-name
EXECUTE data source-specific-SQL-statement BY data source-name | alias
SELECT column-list FROM CONNECTION TO data-source-name | alias (data-source-query)
This section contains syntax for the pass-through facility statements and the CONNECTION TO component. You can use the component with the PROC SQL SELECT statement to query data from a data source.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
SYSECHO <"text"> ;
Fires a global statement complete event and passes a text string back to the IOM client.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
%SYSLPUT macro-variable=value </REMOTE=server-ID > ;
%SYSLPUT _ALL_ | _AUTOMATIC_ | _GLOBAL_ | _LOCAL_ | _USER_
</LIKE=‘character-string’ > <REMOTE=server-ID >;
Creates a single macro variable in the server session or copies a specified group of macro variables to the server session.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
%SYSRPUT macro-variable=value;
Assigns a value from the server session to a macro variable in the client session.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
SYSTASK LIST < _ALL_ | taskname > <STATE> ;
Lists asynchronous tasks.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
SYSTASK COMMANDoperating-environment-command<WAIT | NOWAIT>
<TASKNAME=taskname > <MNAME=name-variable > <STATUS=status-variable >
<SHELL<=“shell-command”> > <CLEANUP> ;
SYSTASK LIST <_ALL_ | taskname > <STATE> <STATVAR> ;
SYSTASK KILL taskname < taskname...> ;
Executes asynchronous tasks.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
SYSTASK COMMAND “operating system command<WAIT | NOWAIT> <TASKNAME=taskname
>
<MNAME=name-var > <STATUS=stat-var > <SHELL<=“shell-command”> > ;
SYSTASK LIST <_ALL_ | taskname > <STATE> <STATVAR> ;
SYSTASK KILL taskname < taskname...> ;
Executes, lists, or terminates asynchronous tasks.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
TEMP=YES | NO
Specifies to store the library in a temporary subdirectory of the primary directory.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
TITLE <1...10> < text-options > <"text-string–1"> ... < text-options > <"text-string-n"> ;
FOOTNOTE <1...10> < text-options > <"text-string–1"> ... < text-options > <"text-string-n"> ;
The TITLE and FOOTNOTE statements control the content, appearance, and placement of title and footnote text.
Product: Base SAS
Document: SAS 9.3 ODS Graphics: Procedures Guide
TITLE < n > <'text' | "text"> ;
Specifies title lines for SAS output.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
TITLE < n > <'text' | “text”> ;
Specifies title lines for SAS output.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
TITLE < n > <' text ' " | text "> ;
Specifies title lines for SAS output.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
TITLE < n > < ods-format-options > <'text' | “text”>;
Specifies title lines for SAS output.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
TITLE <1...10> < text-argument(s) > ;
FOOTNOTE <1...10> < text-argument(s) > ;
NOTE < text-arguments(s) > ;
Control the content, appearance, and placement of text.
Product: SAS/GRAPH
Document: SAS/GRAPH 9.3: Reference
TRACE ON | OFF;
Controls the display of script statements in the Log window as they execute.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
TSO < command > ;
Issues a TSO command or invokes a CLIST or a REXX exec during a SAS session.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
TYPE text;
Sends characters to the server as if they were typed at a personal computer.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
UPDATE master-data-set <(data-set-options)> transaction-data-set <(data-set-options)>
<END=variable >
<UPDATEMODE= MISSINGCHECK | NOMISSINGCHECK >;
BY by-variable;
Updates a master file by applying transactions.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
WAITFOR <_ANY | _ALL_> taskname < taskname...> <TIMEOUT=seconds > ;
Suspends execution of the current SAS session until the specified tasks finish executing.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
WAITFOR<_ANY_ | _ALL_> taskname < taskname...> <TIMEOUT=seconds > ;
Suspends execution of the current SAS session until the specified tasks finish executing.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
WAITFOR < _ANY_ | _ALL_ > taskname1 < taskname2 ...tasknameX > <TIMEOUT=seconds > ;
Suspends execution of the current SAS session until the specified tasks finish executing.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
WAITFOR <_ANY_|_ALL_> task ... taskn <TIMEOUT=seconds > ;
Causes the client session to wait for the completion of one or more tasks (asynchronous RSUBMIT statements) that are in progress.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
WAITFOR pause-specification-1 <. . . pause-specification-n > ;
Specifies a pause until specific conditions are met.
Product: SAS/CONNECT
Document: SAS/CONNECT 9.3 User's Guide
Selects observations from SAS data sets that meet a particular condition.
Product: Base SAS
Document: SAS 9.3 ODS Graphics: Procedures Guide
WHERE where-expression-1
< logical-operator where-expression-n >;
Selects observations from SAS data sets that meet a particular condition.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
WINDOW window < window-options > field-definition(s);
WINDOW window < window-options > group-definition(s);
Creates customized windows for your applications.
Product: Base SAS
Document: SAS 9.3 Statements: Reference
X <'operating-system-command'> ;
Issues an operating environment command from within a SAS session.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
X <'command'> ;
Runs an operating system command or a Windows application from within a SAS session.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
X < command > ;
X XEQ: pgmname < parms > ;
X AEQ: pgmname < parms > ;
X WEQ: pgmname < parms > ;
X Ann: pgmname < parms > ;
X Wnn: pgmname < parms > ;
Issues an operating environment command during a SAS session.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
X <'operating-environment-command'>;
Issues an operating-environment command from within a SAS session.
Product: Base SAS
Document: SAS 9.3 Statements: Reference