Statements Listed Alphabetically
|
Name
|
Syntax and Description
|
|---|---|
|
ABORT;
Stops execution of a script immediately and signals
an error condition.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
ABORT <ABEND | CANCEL <FILE> | RETURN > <n> <NOLIST>;
ABORT <ABEND | RETURN> <n>;
ABORT <ABEND | RETURN | CANCEL | NOLIST> <n>;
ABORT <ABEND | RETURN> <n> ;
Stops executing the current DATA step, SAS job,
or SAS session.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
ABORT <ABEND | RETURN> <n>;
Stops executing the current DATA step, SAS job,
or SAS session.
Product: Base SAS
Document: SAS Companion for UNIX Environments
| |
|
ABORT <ABEND | RETURN | CANCEL | NOLIST> <n>;
Stops executing the current DATA step, SAS job,
or SAS session.
Product: Base SAS
Document: SAS 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 Companion for z/OS
| |
|
ALTER TABLE table [\{OPTIONS SAS-table-option=value [, ...SAS-table-option=value] \}]
ADD
COLUMN [, ...]
| ADD CONSTRAINT
| ALTER [COLUMN] [, ... ]
| DROP COLUMN column [, ...column] [FORCE]
| DROP CONSTRAINT constraint [, ...constraint]
| RENAME
TO table
| RENAME column TO column
;
::=
column data-type [] [ SET DEFAULT value |
DROP DEFAULT ] ::=
CONSTRAINT constraint
{ CHECK (search-condition)
| PRIMARY KEY
| UNIQUE
| NOT NULL } ::=
CONSTRAINT constraint
{ CHECK (search-condition)
| PRIMARY KEY (column [, …column])
| UNIQUE (column [, ...column])
| }
[] ::=
FOREIGN KEY (referencing-column [, ... referencing-column])
REFERENCES referenced-table (referenced-column [, ...referenced-column])
[] ::=
{ [ON
UPDATE [ON DELETE ]] }
| { [ON
DELETE [ON UPDATE ]] } ::=
CASCADE | SET
NULL | SET DEFAULT | RESTRICT | NO
ACTION ::=
{ DEFERRABLE [INITIALLY DEFERRED | INITIALLY
IMMEDIATE] }
| { [INITIALLY DEFERRED | INITIALLY
IMMEDIATE] DEFERRABLE }
|
INITIALLY DEFERRED
| { NOT DEFERRABLE [INITIALLY IMMEDIATE] }
| { [INITIALLY
IMMEDIATE] NOT DEFERRABLE } Adds or drops table columns and modifies column
definitions.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
array-name:= array-name;
array-name:=(constant-list);
Assigns either a temporary array or a constant list
to a temporary array.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
array-name {subscript};
Describes the elements in an array to be processed.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
ARRAY array-name { subscript }
<$ length | length | VARCHAR(length) | VARCHAR(*)> <array-elements> <(initial-value-list)>; Defines the elements of an array.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
variable=expression;
Evaluates an expression and stores the result in
a variable.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
variable=expression;
Evaluates an expression and stores the result in
a variable.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
ATTRIB variable-list(s) attribute-list(s);
ATTRIB variable-list-1 attribute-list-1 <...variable-list-n
attribute-list-n>;
ATTRIB variable-list-1 attribute-list-1…<variable-list-n attribute-list-n>;
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 DATA Step 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 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 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 Companion for z/OS
| |
|
AXIS<1 ...99> <options>;
Controls the location, values, and appearance of
the axes in plots and charts.
Product: SAS/GRAPH
Document: SAS/GRAPH: Reference
| |
|
BEGIN ASYNC OPERATION
Marks the beginning of a block of statements intended
for asynchronous, parallel execution.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
BEGIN [TRANSACTION];
Marks the beginning of a transaction that comprises
multiple statements.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BY [DESCENDING] column... [DESCENDING] column;
Controls the operation of a MERGE or SET statement
in a DS2 program and sets up special grouping variables.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BY <DESCENDING> variable-1 <<DESCENDING> variable-2 ...>
<NOTSORTED>; Processes data and orders output according to the
BY group.
Product: SAS/GRAPH
Document: SAS/GRAPH: Reference
| |
|
BY <DESCENDING> variable-1 <<DESCENDING> variable-2 ...>
<NOTSORTED>; Processes data and orders output according to the
BY group.
Product: Base SAS
Document: SAS/GRAPH and Base SAS: Mapping Reference
| |
|
BY <DESCENDING> variable-1 <... <DESCENDING> variable-n> <NOTSORTED> ;
Creates a separate graph for each BY group.
Product: Base SAS
Document: SAS 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 DATA Step Statements: Reference
| |
|
CALL label;
Invokes a routine.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
CALL routine(parameter-1 <, ...parameter-n>);
Invokes a SAS CALL routine.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
Specifies that lines of data follow the statement.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
Indicates that data lines follow.
Product: Base SAS
Document: SAS Companion for z/OS
| |
|
Specifies that the lines of data that follow the
statement contain internal semicolons.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
LIBNAME libref CAS <options>;
LIBNAME libref CAS HOST= "controller-host-name"
| ("controller-host-name"<"backup-controller-host-name ">)
PORT=network-port-number <options>; LIBNAME libref CAS SESSREF=session-name <options>;
Associates a SAS libref with in-memory tables on
the CAS server.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
CAS session-name <options>;
CAS _ALL_ LIST | _ALL_ TERMINATE
Starts and manages your SAS Cloud Analytic Services
session.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
CASLIB caslib-reference-name <SESSREF=session-reference> <DATASOURCE=(SRCTYPE="type" <data-source-options> ) >
<PATH="directory-path"><options>; CASLIB caslib-reference-name LIST <SESSREF=session-reference> ;
CASLIB _ALL_ ASSIGN | _ALL_ LIST <SESSREF=session-reference>;
Adds and manages caslibs in a SAS Cloud Analytic Services
session.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
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 Global 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 Global Statements: Reference
| |
|
*message;
or
/*message*/
Specifies the purpose of the statement or program.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
COMMIT [TRANSACTION];
Makes changes that have been performed since the
start of a transaction a permanent part of the database.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
CONNECT TO data-source-name AS <alias>
<(connect-statement-arguments)> <(database-connection-arguments)>; CONNECT USING libref AS <alias>;
Establishes a connection with the data source.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference
| |
|
CONNECT TO engine-name <AS alias> (connection-argument(s) );
Specifies the SAS engine that provides SQL explicit
pass-through access.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
CONNECTION TO [engine-name | alias] (SQL-query);
Enables you to send SELECT queries to the SPD Server
SQL processor using explicit SQL pass-through.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
CONTINUE;
Stops processing the current DO loop iteration and
resumes with the next iteration.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
CONTINUE;
Stops processing the current DO-loop iteration and
resumes processing the next iteration.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
COPY TABLE new-table-name FROM old-table-name [WITHOUT
INDEXES]
[ORDER BY column-name [
ASC | DESC ] [',' column-name [
ASC | DESC ]]] ';'
Copies an SPD Server table.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
CREATE [UNIQUE] INDEX index ON table
(column [ASCENDING | DESCENDING ][, ...column]);
Creates an index on columns in a specified table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
CREATE TABLE table
[\{OPTIONS SAS-table-option=value [...SAS-table-option=value] \}] AS query-expression
; Creates a new table from one or more existing tables.
Product: SAS Cloud Analytic Services
Document: SAS Viya: FedSQL Programming for SAS Cloud Analytic Services
| |
|
CREATE TABLE {table | _NULL_}
[\{OPTIONS SAS-table-option=value [...SAS-table-option=value] \}] |
( [, ... | ])
| AS query-expression
; ::=
column data-type [] [DEFAULT value]
[HAVING [FORMAT format][INFORMAT informat][LABEL 'label']]
::=
CONSTRAINT constraint
{ CHECK (search-condition)
| PRIMARY KEY
| UNIQUE
| NOT NULL } ::=
CONSTRAINT constraint
{ CHECK (search-condition)
| PRIMARY KEY (column [, ...column])
| UNIQUE (column [, ...column])
| }
[] ::=
FOREIGN KEY (referencing-column [, ...referencing-column])
REFERENCES referenced-table (referenced-column [, ...referenced-column])
[] ::=
{ ON UPDATE [ON DELETE ] }
| { ON DELETE [ON UPDATE ] } ::=
CASCADE | SET
NULL | SET DEFAULT | RESTRICT | NO
ACTION ::=
{ DEFERRABLE [INITIALLY DEFERRED | INITIALLY
IMMEDIATE] }
| { [INITIALLY DEFERRED | INITIALLY
IMMEDIATE] DEFERRABLE }
|
INITIALLY DEFERRED
| { NOT DEFERRABLE [INITIALLY IMMEDIATE] }
| { [INITIALLY
IMMEDIATE] NOT DEFERRABLE } Creates a new table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
CREATE VIEW view [SECURITY security-type] AS query-expression;
Creates a FedSQL view of data from one or more tables
or other views.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
CREATE [MATERIALIZED] VIEW view-name AS
SELECT query-expression';'
Creates a view of SPD Server tables from a query
expression. The view can be materialized in a table.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
DATA [ <table-expression> ] [... <table-expression> ] ;
… program-body … [ ENDDATA ; ]
<table-expression>::=
table (table-options)
| _ROWSET_ (table-options)
| _NULL_ Begins a DS2 program and provides names for any
output tables.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DATA statement for creating output data sets
DATA <data-set-name-1 <(data-set-options-1)> >
<...data-set-name-n <(data-set-options-n)> > </ <DEBUG> <NESTING> <STACK=stack-size> <HEXLISTALL>> <NOLIST>; DATA statement for creating a DATA step view
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 statement for creating a stored compiled
DATA step program
DATA data-set-name /
PGM=program-name
<(<password-option> <SOURCE=source-option> )> <NESTING> <NOLIST>; DATA statement for describing a DATA step view
DATA VIEW=view-name <(password-option)> <NOLIST>;
DESCRIBE; DATA statement for use with a stored compiled
DATA step program
DATA PGM=program-name <(password-option)> <NOLIST>;
<DESCRIBE;>
<REDIRECT INPUT
| OUTPUT old-name-1 = new-name-1<… old-name-n = new-name-n> ;>
<EXECUTE;> DATA statement for use on the CAS server
DATA <data-set-name-1 <(data-set-options-1)> >
<...data-set-name-n <(data-set-options-n)> > / < <SESSREF=session-reference-name> | <SESSUUID=session-uuid > > <THREADS=number-of-threads> <SINGLE= NO | YES | NOINPUT> <NESTING> <STACK=stack-size><HEXLISTALL> <NOLIST>; Begins a DATA step and provides names for any output
such as SAS data sets, views, or programs.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
DATALINES;
Specifies that lines of data follow the statement.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
DATALINES4;
Specifies that the lines of data that follow the
statement contain internal semicolons.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
DECLARE PACKAGE package [(table-options)] variable [(constructor-arguments)]
[...variable [(constructor-arguments)]]; Creates a package variable and gives you the option
to create an instance of the package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DECLARE PACKAGE fcmp-package-name variable (
);
Creates a package variable and gives you the option
to create an instance of the FCMP package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DECLARE PACKAGE HITER variable [( 'hash-name' | hash-package-instance)];
Creates a hash iterator package variable and gives
you the option of creating an instance of the hash iterator package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DECLARE PACKAGE HASH variable (
);
DECLARE PACKAGE HASH variable (hashexp, {'datasource'
| '\{sql-text\}'},
'ordered', 'duplicate ', 'suminc', 'multidata'); DECLARE PACKAGE HASH variable (
\[keys\],
\[data\], [hashexp,
{'datasource' | '\{sql-text\}'}, 'ordered', 'duplicate ', 'suminc', 'multidata']); DECLARE PACKAGE HASH variable (
\[keys\], [hashexp, {'datasource'
|
'\{sql-text\}'}, 'ordered', 'duplicate ', 'suminc', 'multidata']); Creates a package variable and gives you the option
of creating an instance of the hash package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DECLARE PACKAGE HTTP variable(
);
Creates a package variable and enables you to create
an instance of the HTTP package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DECLARE PACKAGE JSON variable (
);
Creates a package variable and enables you to create
an instance of the JSON package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DECLARE PACKAGE LOGGER variable ([logger-name]);
Creates a package variable and gives you the option
of creating an instance of the logger package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DECLARE PACKAGE MATRIX variable ([row-dimension, column-dimension]);
Creates an instance of a MATRIX package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DECLARE PACKAGE PCRXFIND variable ([regular-expression]);
Creates a package variable and gives you the option
of creating an instance of the PCRXFIND package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DECLARE PACKAGE PCRXREPLACE variable ([regular-expression]);
Creates a package variable and gives you the option
of creating an instance of the PCRXREPLACE package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DECLARE PACKAGE SQLSTMT variable [('sql-text' [,\[parameter-variable-list\]])];
DECLARE PACKAGE SQLSTMT variable [('sql-text' [, connection-string])];
DECLARE PACKAGE SQLSTMT variable (
);
DECLARE PACKAGE SQLSTMT variable ;
Creates a package variable and enables you to create
an instance of the SQLSTMT package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DECLARE PACKAGE TZ variable ([time-zone-id]);
Creates a package variable and enables you to create
an instance of the TZ package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DECLARE [PRIVATE] {
<data-type> <variable-list> [ <having-clause> ] }
;
< data-type >::=
<exact-numeric-type>
| <approximate-numeric-type> | <binary-string-type> |
<string-type>
| <date-type> <exact-numeric-type>
::=
{INT | BIGINT | SMALLINT | TINYINT
| DECIMAL [(precision [,scale] )] | NUMERIC [(precision [,scale])] } <approximate-numeric-type>
::=
{ DOUBLE | DOUBLE PRECISION | FLOAT | REAL }
<binary-string-type>::=
BINARY(length)
| VARBINARY(length)
<string-type>::=
NCHAR [ ( character-length ) ]
| NVARCHAR [ ( character-length ) ]
| CHAR [ ( character-length ) ] [CHARACTER
SET character-set-identifier ]
| VARCHAR [ ( character-length ) ] [CHARACTER
SET character-set-identifier ] <date-type>::=
{ TIME | TIMESTAMP }
[ ( precision ) ] | DATE
<variable-list>::=
{ variable [...variable ] }
| { variable <array-declaration> [variable...<array-declaration> ] }
<array-declaration>::=
\[ <array-bound> [, ...<
array-bound> ] \] <array-bound>::=
{ [dim-lower:] dim-upper}
| { [dim-lower:] {DIM
(a[, n])
| *} <having-clause>::=
HAVING <having-option> [... <having-option> ]
<having-option>::=
LABEL 'string'
| n'string'
| FORMAT format
| INFORMAT format Declares one or more DS2 variables or temporary
arrays.
Product: Base SAS
Document: SAS DS2 Language 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 Logging: Configuration and Programming Reference
| |
|
DECLARE DICTIONARY object-reference;
Declares a dictionary object.
Product: Base SAS
Document: SAS Component Objects: 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 Component Objects: Reference
| |
|
DECLARE HASH object-reference;
DECLARE HITER object-reference ("hash-reference");
DECLARE object object-reference (<argument_tag-1: value-1, argument_tag-2: value-2, ...>);
Declares a PROC FCMP hash object or PROC FCMP hash
iterator object; creates an instance of and initializes data for a
PROC FCMP hash or PROC FCMP hash iterator object.
Product: Base SAS
Document: SAS 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 Component Objects: Reference
| |
|
DECLARE LOGGER logger-object("logger-name" <, ADDITIVITY: | >
<, LEVEL:"level"> <, APPENDERREF:"appender-name-1" <, APPENDERREF:"appender-name-2"> ...>); Declares a logger object; creates an instance of
a logger object and initializes data for a logger object.
Product: Base SAS
Document: SAS Logging: Configuration and Programming Reference
| |
|
DECLARE ODSOUT object-reference <( )>;
Declares an ODS object and creates an instance of
and initializes data for an ODS object.
Product: Base SAS
Document: SAS Output Delivery System: Advanced Topics
| |
|
DECLARE OBJECT object-reference(PYTHON<("module-name")>);
Declares a Python object.
Product: Base SAS
Document: SAS Component Objects: Reference
| |
|
DECLARE THREAD thread [(table-options)] instance( argument ) [... instance ( argument )];
Creates an instance of a thread.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DELETE FROM table [WHERE ];
Deletes rows from a table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
DELETE;
Stops processing the current observation.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
DESCRIBE;
Retrieves source code from a stored compiled DATA
step program or a DATA step view.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
DESCRIBE TABLE [catalog.][schema.] table;
Retrieves SQL from a table and returns a result
set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
DESCRIBE VIEW ["catalog".]["schema".]"view"
DESCRIBE VIEW XML ["catalog".]["schema".]"view"
Retrieves SQL from a view and returns a result set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
DISCONNECT FROM <data-source-name> | <alias>;
Ends the connection to the data source.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference
| |
|
DISCONNECT FROM [engine-name | alias];
Terminates the SQL explicit pass-through session
with the server SQL processor.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
DISPLAY window<.group> <NOINPUT> <BLANK> <BELL > <DELETE>;
Displays a window that is created with the WINDOW
statement.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
DM <window> 'command(s)' <window> <CONTINUE> ;
Enables you to turn SAS Command Line commands
into SAS global programming statements in the SAS Display Manager
environment.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
DO [numeric-data-type][index-variable =
<index-variable-clause>] [ <conditional-clause> ]
[, ...[<index-variable-clause>] [ <conditional-clause> ]] ; ...statement-list... END [end-label ] ;
< numeric-data-type >::=
<exact-numeric-type>
| <approximate-numeric-type>
<exact-numeric-type>
::=
{INT | BIGINT | SMALLINT | TINYINT
| DECIMAL [(precision [,scale] )] | NUMERIC [(precision [,scale])] } <approximate-numeric-type>
::=
{ DOUBLE | DOUBLE PRECISION | FLOAT | REAL }
<index-variable-clause>::=
start [TO stop [BY increment ]]
<conditional-clause>::=
WHILE
( expression )
| UNTIL ( expression ) Specifies a group of statements to be executed as
a unit.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DO;
...more SAS statements... END;
Specifies a group of statements to be executed as
a unit.
Product: Base SAS
Document: SAS DATA Step 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 DATA Step 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 DATA Step 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 DATA Step Statements: Reference
| |
|
DROP INDEX index [FROM table] [FORCE];
Removes the specified index from a table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
DROP PACKAGE package [(table-options)];
RUN; Deletes a DS2 package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DROP column-list | vararray;
Excludes columns from output tables.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DROP variable-list;
Excludes variables from output SAS data sets.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
DROP TABLE table [FORCE];
Removes an in-memory table from the CAS session.
Product: SAS Cloud Analytic Services
Document: SAS Viya: FedSQL Programming for SAS Cloud Analytic Services
| |
|
DROP TABLE table [FORCE];
Removes a table from the database.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
DROP THREAD thread [(table-options)];
Deletes a DS2 thread program.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DROP VIEW view [FORCE];
Removes a view from the database.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
DS2_OPTIONS options;
Specifies or changes the default behavior of a DS2
program.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DSNEXST 'physical-filename ';
Checks to see whether the specified physical file
exists and is available.
Product: Base SAS
Document: SAS 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 User’s Guide
| |
|
END ASYNC OPERATION
Marks the end of a block of statements intended
for asynchronous, parallel execution.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
END;
Ends DO group or SELECT group processing.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
ENDDATA;
Marks the end of a DATA statement.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
ENDPACKAGE;
Marks the end of a PACKAGE statement.
Product: Base SAS
Document: SAS DS2 Language 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 User’s Guide
| |
|
ENDSAS;
Stops SAS program execution as soon as the statement
is encountered in a SAS program.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
ENDTHREAD;
Marks the end of a THREAD statement.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
ERROR <message>;
Sets _ERROR_ to 1. A message written to the SAS
log is optional.
Product: Base SAS
Document: SAS DATA Step 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 Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference
| |
|
EXECUTE(native-syntax) BY catalog;
Sends a DBMS-specific statement to a DBMS that FedSQL
supports.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
EXECUTE;
Executes a stored compiled DATA step program.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
EXECUTE (SQL-statement)
BY [engine-name | alias];
Submits SQL statements that do not return a result
set directly to the server.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
FILE file-specification <device-type> <options> <operating-environment-options>;
Specifies the current output file for PUT statements.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
FILE PRINT ODS <=(ODS-suboptions)> <options>
;
Creates an ODS output object by binding the data
component to the table template. As an option, the FILE Statement
lists the variables to include in the ODS output, and it specifies
options that control how the variables are formatted.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
FILE file-specification <device-type> <PERMISSION='permission-value'> <ENCODING='encoding-value' > <options> <host-options>;
Specifies the current output file for PUT statements.
Product: Base SAS
Document: SAS Companion for UNIX Environments
| |
|
FILE file-specification<PERMISSION='permission-value'><ENCODING='encoding-value'>
<option-list> <host-option-list> ; Specifies the current output file for PUT statements.
Product: Base SAS
Document: SAS Companion for Windows
| |
|
FILE file-specification <PERMISSION='permission-value'><type>
<ENCODING=encoding-value> <options>; FILE LOG | PRINT <options>;
Specifies the current output file for PUT statements.
Product: Base SAS
Document: SAS Companion for z/OS
| |
|
FILENAME
fileref
'filespec' <access-method>
<operating-environment-options>;
Associates a SAS fileref with an external file.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
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 Global Statements: Reference
| |
|
FILENAME fileref ACTIVEMQ <"destination-name" >< access-method-options>
Assigns a fileref that enables you to access an
ActiveMQ broker by using the ACTIVEMQ access method.
Product: SAS Integration Technologies
Document: Application Messaging with SAS
| |
|
FILENAME fileref ADLS “object path” <adls-options>;
Enables you to access data in Microsoft Azure Data Lake
Storage.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
FILENAME fileref CATALOG 'catalog' <catalog-options>;
Enables you to reference a SAS catalog as an external
file.
Product: Base SAS
Document: SAS Global 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 Global Statements: Reference
| |
|
FILENAME fileref DATAURL 'data-url-specification' <data-url-options>;
Enables you to read data from user-specified text.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
FILENAME
fileref
EMAIL
<
'address'
>
<
email-options>;
Enables you to send electronic mail programmatically from SAS using the Simple
Mail Transfer Protocol SMTP email interface.
Product: Base SAS
Document: SAS Companion for z/OS
| |
|
FILENAME
fileref
EMAIL
<
'address'
>
<email-options>;
Enables you to send electronic mail programmatically
from SAS using the SMTP (Simple Mail Transfer Protocol) email interface.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
FILENAME fileref FILESRVC 'file-uri' <filesrvc-options>;
FILENAME fileref FILESRVC collection-option <filesrvc-options>;
Enables you to store and retrieve user content using
the SAS Viya Files service.
Product: Base SAS
Document: SAS Global 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 Global Statements: Reference
| |
|
FILENAME fileref HADOOP 'external-file' <hadoop-options>;
Enables you to access files on a Hadoop Distributed
File System (HDFS) whose location is specified in a configuration
file.
Product: Base SAS
Document: SAS Global 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
| |
|
FILENAME fileref S3 “object path”<s3-options>;
Enables you to access data objects in an Amazon S3 or MinIO
environment.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
FILENAME fileref SFTP 'external-file' <sftp-options>;
Enables you to access remote files by using the
SFTP protocol.
Product: Base SAS
Document: SAS Global 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 Global Statements: Reference
| |
|
FILENAME fileref <device-type> 'external-file' <PERMISSION='permission-value'>
<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 Companion for UNIX Environments
| |
|
FILENAME
fileref
URL
'external-file'
<url-options>;
Enables you to access remote files by using the
URL access method.
Product: Base SAS
Document: SAS Global 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 Global Statements: Reference
| |
|
FILENAME fileref <device-type>
'external-file' <PERMISSION='permission-value' >
<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
an output device, disassociates a fileref and external file, or lists
attributes of external files.
Product: Base SAS
Document: SAS Companion for Windows
| |
|
FILENAME fileref <device-type> 'physical-filename' <PERMISSION='permission-value'>
<host-options>; FILENAME fileref <device-type> ('physical–filename–1' 'physical-filename-2' ...)
<host-options>; FILENAME fileref | _ALL_ CLEAR;
FILENAME fileref | _ALL_ LIST;
Associates a SAS fileref with an external file.
Product: Base SAS
Document: SAS Companion for z/OS
| |
|
FILENAME
fileref
ZIP
'external-file'
<zip-options>;
Enables you to access ZIP files.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
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: Reference
| |
|
FOOTNOTE<1 ...10> <text-argument(s)>;
Writes up to 10 lines of text at the bottom of the
graph.
Product: Base SAS
Document: SAS/GRAPH and Base SAS: Mapping 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 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 Global 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 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 Companion for Windows
| |
|
FOOTNOTE<n> <'text' | "text"> ;
Prints up to ten lines at the bottom of the procedure
output.
Product: Base SAS
Document: SAS Companion for z/OS
| |
|
Associates SAS formats or user-defined formats with
variables.
Product: Base SAS
Document: SAS 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 DATA Step Statements: Reference
| |
|
FORWARD method [ ...method ];
Indicates that the method definition follows the
method expression.
Product: Base SAS
Document: SAS DS2 Language 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: Reference
| |
|
GOPTIONS <options-list>;
Temporarily sets default values for many graphics
attributes and device parameters used by SAS/GRAPH procedures.
Product: Base SAS
Document: SAS/GRAPH and Base SAS: Mapping Reference
| |
|
GOTO label;
Redirects execution of a script to the specified
script statement.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
GOTO label;
Transfers execution immediately to a labeled statement.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
GOTO 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 DATA Step 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 User’s Guide
| |
|
IF expression;
Continues processing only those rows that meet the
condition.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
IF expression;
Continues processing only those observations that
meet the condition of the specified expression.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
IF expression THEN statement;
[ ELSE statement ;] Executes a statement for rows that meet specific
conditions.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
IF expression THEN statement;
<ELSE statement;> Executes a SAS statement for observations that meet
specific conditions.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
%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 Global Statements: Reference
| |
|
%INCLUDE source </<ENCODING='encoding-value'> <host-options> > ;
Includes and executes SAS statements and data lines.
Product: Base SAS
Document: SAS Companion for Windows
| |
|
%INCLUDE source-1 <source-2 ...>
</<SOURCE2> <S2=length> <S2V=column> <JCLEXCL> <ENCODING='encoding-value'> <host-options>>; Includes SAS statements and data lines.
Product: Base SAS
Document: SAS 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 DATA Step Statements: 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 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 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 Companion for z/OS
| |
|
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 DATA Step Statements: Reference
| |
|
INPUT <NODISPLAY> 'prompt';
Displays a prompt to the user that requests a response
for the server.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
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 DATA Step Statements: Reference
| |
|
INPUT variable <$> start-column<–end-column>
<.decimals> <@ | @@>; Reads input values from specified columns and assigns
the values to the corresponding SAS variables.
Product: Base SAS
Document: SAS DATA Step 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 DATA Step 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 DATA Step Statements: Reference
| |
|
INPUT <pointer-control> variable= <$> <@ | @@>;
INPUT variable= <$> start-column<–end-column>
<@ | @@>; Reads data values that appear after a variable name
that is followed by an equal sign and assigns the values to corresponding
SAS variables.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
INSERT INTO table
{VALUES
(value |
NULL [, ...value |
NULL])}; INSERT INTO table
{
(column [, ...column])
VALUES (value |
NULL [, ...value |
NULL]) };
INSERT INTO table
{
(column [, ...column]) [query-expression] };
Adds rows to a specified table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
KEEP column-list | vararray;
Includes columns in output tables.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
KEEP variable-list;
Specifies the variables to include in output SAS
data sets.
Product: Base SAS
Document: SAS DATA Step 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 User’s Guide
| |
|
Associates descriptive labels with variables.
Product: Base SAS
Document: SAS ODS Graphics: Procedures Guide
| |
|
LABEL variable-1 = 'text-string' <...variable-n = 'text-string'>;
LABEL variable-1 = ' ' < ...variable-n=’
‘>; | variable-1 = <...variable-n= >;
Assigns descriptive labels to variables.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
label: statement;
Identifies a statement that is referred to by another
statement.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
label: statement; [ ... statement ];
Identifies a statement that is referred to by another
statement.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
LEAVE [ identifier ] ;
Stops processing the current DO loop and transfers
execution to either the statement following the current DO statement,
or a labeled DO statement that encloses the current DO statement.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
LEAVE;
Stops processing the current loop and resumes with
the next statement in the sequence.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
LEGEND<1 ...99> <options>;
Controls the
location and appearance of legends on two-dimensional plots, contour
plots, and charts.
Product: SAS/GRAPH
Document: SAS/GRAPH: Reference
| |
|
LEGEND<1 ...99> <options>;
Controls the
location and appearance of legends on maps.
Product: Base SAS
Document: SAS/GRAPH and Base SAS: Mapping Reference
| |
|
LENGTH variable-specification(s) <DEFAULT=n>;
LENGTH <variable-1> <...variable-n> <$> length <DEFAULT=n>;
LENGTH <variable-1> <…variable-n> <$> <length> <DEFAULT=n>;
LENGTH variable(s) <$> length ...<DEFAULT=n >;
Specifies the number of bytes for storing character
and numeric variables, or the number of characters for storing VARCHAR
variables.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
LENGTH <variable-1> <...variable-n> <$> length <DEFAULT=n>;
Specifies the number of bytes for storing variables.
Product: Base SAS
Document: SAS 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 Companion for Windows
| |
|
LENGTH variable(s) <$> length ...<DEFAULT=n >;
Specifies how many bytes SAS uses to store a variable's
value.
Product: Base SAS
Document: SAS 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 User’s Guide
| |
|
LIBNAME libref <engine>
'SAS-library'
< libname-options > <engine-host-options>; LIBNAME libref CLEAR | _ALL_ CLEAR ;
LIBNAME libref LIST | _ALL_ LIST;
LIBNAME libref <engine> (library-specification-1 <...library-specification-n>)
<libname-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 Global 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 User’s Guide
| |
|
LIBNAME < libref> <engine-name> <'physical-path-and-file-name.ext'>
<SAS/ACCESS-engine-connection-options> <SAS/ACCESS LIBNAME-options>; LIBNAME libref CLEAR | _ALL_;
LIBNAME libref LIST | _ALL_ ;
Associates a SAS libref with a Microsoft Excel workbook
or Microsoft Access database.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference
| |
|
LIBNAME libref CVP 'SAS-library' <libname-options>;
Associates a libref for the character variable padding
(CVP) engine to expand character variable lengths so that character
data truncation does not occur when a file requires transcoding.
Product: Base SAS
Document: SAS Global 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 for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
LIBNAME libref JMP 'path' <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 Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference
| |
|
LIBNAME libref JMP 'path' <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 Global Statements: Reference
| |
|
LIBNAME libref JSON < 'JSON-document-path' > <options>;
Provides read-only sequential access to JSON data.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
LIBNAME libref PCFILES SAS/ACCESS-connection-options SAS/ACCESS-LIBNAME-options;
LIBNAME libref CLEAR
| _ALL_ CLEAR;
LIBNAME libref LIST
| _ALL_ LIST;
Associates a SAS libref with a Microsoft Excel workbook
or Access database or with an ODBC data source.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference
| |
|
LIBNAME libref FEDSVR <server-connection-options>
DSN=dsn-definition <DSNUSER="user-ID" DSNPASSWORD="password">
<REMOTE_DRIVER=FEDSVR | FSNET>
<options> ;
Associates a SAS libref with data to be processed
by SAS Federation Server.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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 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 User’s Guide
| |
|
LIBNAME libref SPDE
'full-primary-path'
<options> ;
Associates or disassociates a SAS library with a
libref (a shortcut name) for the SPD Engine.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
LIBNAME libref SPDE 'primary-pathname' HDFS=YES
<ACCELJAVAVERSION=version> <ACCELWHERE=NO | YES> <DATAPATH=('pathname')> <HDFSUSER=ID> <IOBLOCKSIZE=n> <NUMTASKS=n> <PARALLELREAD=NO | YES> <PARALLELWRITE=NO | YES | threads> <PARTSIZE=n | nM | nG | nT>; Assigns a libref to a Hadoop cluster to read, write,
and update a data set in HDFS.
Product: Base SAS
Document: SAS SPD Engine: Storing Data in the Hadoop Distributed File System
| |
|
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 Companion for UNIX Environments
| |
|
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 Global Statements: Reference
| |
|
LIBNAME libref <engine-name>
'('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 Companion for Windows
| |
|
LIBNAME < libref> XLSX <'physical-path-and-file-name.xlsx'>
<SAS/ACCESS LIBNAME-options>; LIBNAME libref CLEAR
| _ALL_ ;
LIBNAME libref LIST
| _ALL_ ;
Associates a SAS libref with a Microsoft Excel workbook
that resides on UNIX or Microsoft Windows. SAS PC Files Server is
not required.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference
| |
|
LIBNAME libref engine 'SAS-library' | 'XML-document-path' <options>;
Processes an XML document.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
LIBNAME libref <engine> <'<file-system-prefix> physical-filename'> <engine/host-options> ;
LIBNAME libref <engine> <(library-specification-1, library-specification-2 ...)>
<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 Companion for z/OS
| |
|
LIBNAME libref INFOMAPS MAPPATH="location" <options>
Associates a SAS libref with information maps.
Product: Base SAS
Document: Base SAS Guide to Information Maps
| |
|
LIBREF libref-name ENGOPTS='connection-string'
Creates a connection to an SPD Server domain within
an EXECUTE statement.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: 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 DATA Step Statements: Reference
| |
|
%LIST<n <:m |
− m> >;
Displays lines that are entered in the current session.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
LIST;
Writes to the SAS log the input data record for
the observation that is being processed.
Product: Base SAS
Document: SAS DATA Step 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 User’s Guide
| |
|
LOAD TABLE new-table-name [
WITH index-name ON (column-name)
[ ','
WITH index-name ON (column-name)]]
AS
SELECT select-list FROM old-table-name
[WHERE sql-expression]';'
Creates a new SPD Server table from an existing
SPD Server table by using a SELECT clause.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
LOCK libref<.member-name<.member-type |
.entry-name.entry-type>>
<LIST | QUERY | SHOW | CLEAR | NOMSG>; Acquires, lists, or releases an exclusive lock on
an existing SAS file.
Product: Base SAS
Document: SAS Global 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 User’s Guide
| |
|
LOCKDOWN ENABLE_AMS=access-method-1 <access-method-2...>;
LOCKDOWN FILE=file-ref;
LOCKDOWN PATH='pathname-1'
<'pathname-n'...>;
LOCKDOWN LIST;
Secures a SAS Foundation server by restricting access
from within a server process to the host operating environment.
Product: SAS Enterprise BI Server
Document: SAS Intelligence Platform: Application Server Administration Guide
| |
|
LOG 'message';
Sends a message to the client SAS log.
Product: SAS/CONNECT
Document: SAS/CONNECT 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 DATA Step Statements: Reference
| |
|
MERGE <table-reference> <table-reference> [... <table-reference>] [/RETAIN];
<table-reference>::=
{ table [ (table-options) ] }
Joins rows from two or more tables into a single
row.
Product: Base SAS
Document: SAS DS2 Language 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 DATA Step Statements: Reference
| |
|
[PRIVATE] METHOD method ([[IN_OUT] <parameter>
[, ... [IN_OUT]]] )
[RETURNS data-type]; END;...method-body ... <parameter>::=
<data-type> variable < data-type >::=
<exact-numeric-type>
| <approximate-numeric-type> | <binary-string-type> |
<string-type>
| <date-type> <exact-numeric-type>
::=
{INT | BIGINT | SMALLINT | TINYINT
| DECIMAL [(precision [,scale] )] | NUMERIC [(precision [,scale])] } <approximate-numeric-type>
::=
{ DOUBLE | DOUBLE PRECISION | FLOAT | REAL }
<binary-string-type>::=
BINARY(length)
| VARBINARY(length)
<string-type>::=
NCHAR [ ( character-length ) ]
| NVARCHAR [ ( character-length ) ]
| CHAR [ ( character-length ) ] [CHARACTER
SET character-set-identifier ]
| VARCHAR [ ( character-length ) ] [CHARACTER
SET character-set-identifier ] <date-type>::=
{ TIME | TIMESTAMP }
[ ( precision ) ] | DATE
Defines a block of code that can be called and executed
multiple times.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
MISSING character(s);
Assigns characters in your input data to represent
special missing values for numeric data.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
MODIFY master-data-set <(data-set-options)> transaction-data-set <(data-set-options)>
<CUROBS=variable> <NOBS=variable> <END=variable> <UPDATEMODE=MISSINGCHECK | NOMISSINGCHECK>; BY by-variable; MODIFY master-data-set <(data-set-options)> KEY=index </
UNIQUE>
<KEYRESET=variable> <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 DATA Step Statements: Reference
| |
|
NOTE <text-arguments(s)>;
Writes lines of text in the output.
Product: SAS/GRAPH
Document: SAS/GRAPH: Reference
| |
|
NOTE <text-arguments(s)>;
Writes lines of text in the output.
Product: Base SAS
Document: SAS/GRAPH and Base SAS: Mapping Reference
| |
|
NOTIFY 'message';
Sends a message in a window to the client session.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
;
Creates an empty statement.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
;
or
;;;;
Signals the end of data lines or acts as a placeholder.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
ODS _ALL_ CLOSE;
Closes all open ODS output destinations.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS CHTML <(<ID=> identifier)>< action> ;
ODS CHTML <(<ID=> identifier)><options> ;
Opens, manages, or closes the CHTML destination,
which produces a compact, minimal HTML that does not use style information.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS CSVALL <(<ID=>
identifier)> < action> ;
ODS CSVALL <(<ID=>
identifier)> <options> ;
Opens, manages, or closes the CSVALL destination,
which produces CSVALL output containing columns of data values that
are separated by commas and produces tabular output with titles, notes,
and BY lines.
Product: Base SAS
Document: SAS 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 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 Output Delivery System: User’s Guide
| |
|
ODS EPUB <(<ID=>
identifier)> < action> ;
ODS EPUB <(<ID=>
identifier)> <options> ;
Opens, manages, or closes the ODS EPUB destination,
which generates EPUB e-books.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS EPUB2 <(<ID=> identifier)> < action> ;
ODS EPUB2 <(<ID=> identifier)> <options> ;
Opens, manages, or closes the EPUB2 destination,
which generates EPUB e-books using the EPUB2 standard.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS EPUB3 <(<ID=> identifier)> < action> ;
ODS EPUB3 <(<ID=> identifier)> <options> ;
Opens, manages, or closes the EPUB3 destination,
which generates EPUB e-books.
Product: Base SAS
Document: SAS 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 Output Delivery System: User’s Guide
| |
|
ODS EXCEL <(<ID=> identifier)> < action> ;
ODS EXCEL <(<ID=> identifier)> <options> ;
Opens, manages, or closes the ODS destination for , which produces spreadsheet files
compatible with
and later
versions.
Product: Base SAS
Document: SAS 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 Output Delivery System: User’s Guide
| |
|
ODS GRAPHICS <OFF | ON> </ options> ;
Enables or disables processing
and sets graphics environment options. This statement affects ODS
template-based () graphics only. The ODS GRAPHICS statement
does not affect device-based graphics ().
Product: Base SAS
Document: SAS ODS Graphics: Procedures Guide
| |
|
ODS GRAPHICS <OFF | ON> </ options> ;
Enables or disables processing
and sets graphics environment options. This statement affects ODS
template-based () graphics only. The ODS GRAPHICS statement
does not affect device-based graphics ().
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS HTML <(<ID=> identifier)> <<action> | <option(s)>>;
Opens or closes the HTML destination.
Product: SAS/GRAPH
Document: SAS/GRAPH: Reference
| |
|
ODS HTML <(<ID=> identifier)> <<action> | <option(s)>>;
Opens or closes the HTML destination.
Product: Base SAS
Document: SAS/GRAPH and Base SAS: Mapping Reference
| |
|
ODS HTML <(<ID=> identifier)> < action> ;
ODS HTML <(<ID=> identifier)> <options> ;
Opens, manages, or closes the HTML destination,
which produces HTML 4.0 output in the SAS Windowing environment. This
output can contain embedded style sheets.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS HTML3<(<ID=> identifier)> < action> ;
ODS HTML3 <(<ID=> identifier)> <options> ;
Opens, manages, or closes the HTML3 destination,
which produces HTML 3.2 formatted output.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS HTML5 <(<ID=> identifier)> < action> ;
ODS HTML5 <(<ID=> identifier)> <options> ;
Opens, manages, or closes the HTML5 destination,
which produces HTML 5.0 output that contains embedded style sheets.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS LAYOUT ABSOLUTE< option-1>< option-2
...>
Enables you to specify an exact page location using
x and y coordinates. Absolute layout is limited to one page and is
supported only by the PRINTER destinations
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS LAYOUT END;
Ends a gridded or absolute layout statement block.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS LAYOUT GRIDDED<option-1>< option-2
...>
Enables you to arrange output dynamically in a
two-dimensional grid structure.
Product: Base SAS
Document: SAS 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 Output Delivery System: User’s Guide
| |
|
ODS MARKUP <(<ID=> identifier)> < action> ;
ODS MARKUP <(<ID=> identifier)> <options> <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 Output Delivery System: User’s Guide
| |
|
ODS NO_DECIMAL_ALIGN;
Right-justifies numeric columns when no justification
is specified.
Product: Base SAS
Document: SAS 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 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>
;
Opens, adds to, publishes, or closes one SAS Output
Delivery System (ODS) package object.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS PATH <(APPEND)( | PREPEND)( | REMOVE) > location(s);
ODS PATH path-argument;
The ODS PATH statement controls where ODS stores
new templates that you create and where ODS finds the templates that
your programs use.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS PCL <(<ID=>
identifier)> < action> ;
ODS PCL <(<ID=>
identifier)> <options> ;
Opens, manages, or closes the PCL destination, which
produces printable output for PCL (HP LaserJet) files.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS PDF <(<ID=> identifier)> < action> ;
ODS PDF <(<ID=> identifier)> <options> ;
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 Output Delivery System: User’s Guide
| |
|
ODS PHTML action;
ODS PHTML <options> ;
Opens, manages, or closes the PHTML destination,
which produces simple HTML output that uses twelve style elements
and no class attributes for the presentation.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS POWERPOINT <(<ID=> identifier)> < action> ;
ODS POWERPOINT <(<ID=> identifier)> <options> ;
Opens, manages, or closes the ODS destination for , which produces output.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS PREFERENCES;
Reverts the ODS settings back to start-up defaults.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS PRINTER <(<ID=>
identifier)> < action> ;
ODS PRINTER <(<ID=>
identifier)> <options> ;
Opens, manages, or closes the PRINTER destination,
which produces printable output.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS PROCLABEL 'string';
ODS PROCLABEL= 'string';
Enables you to change a procedure label.
Product: Base SAS
Document: SAS 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 Output Delivery System: User’s Guide
| |
|
ODS PS <(<ID=>
identifier)> < action> ;
ODS PS <(<ID=>
identifier)> <options> ;
Opens, manages, or closes the PS destination, which
produces PostScript (PS) output.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS REGION < option-1>< option-2
...>
Creates a region container for absolute layouts.
A region can contain output (such as text, tables, images, graphs)
or nested layout containers.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS REGION (<option-1><option-2
...>);
Creates a region container for gridded layouts.
A region can contain output (such as text, tables, images, graphs)
or nested layout containers.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS RESULTS
ON | OFF;
ODS RESULTS=
ON | OFF;
Controls whether ODS output is displayed in the Results
window.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS RTF <(<ID=>
identifier)> action;
ODS RTF <(<ID=>
identifier)> <options> ;
Opens, manages, or closes the RTF destination, which produces output written in
Rich Text Format for use with .
Product: Base SAS
Document: SAS 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 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 Output Delivery System: User’s Guide
| |
|
ODS directory.tagset-name file-specification <options> ;
ODS directory.tagset-name file-specification action;
Opens, manages, or closes the specified tagset destination.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS TAGSETS.RTF <(<ID=>
identifier)> action;
ODS TAGSETS.RTF <(<ID=>
identifier)> <options> ;
Opens, manages, or closes the RTF destination, which
produces measured output that is written in Rich Text Format.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS TEXT= 'text-string'
Inserts text into your ODS output.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS TRACE ON </options> ;
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 Output Delivery System: User’s Guide
| |
|
ODS USEGOPT | NOUSEGOPT;
Determines whether ODS uses traditional option
settings.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS VERIFY <ON | OFF | ERROR | WARN> ;
Prints or suppresses a message indicating that a
style template or a table template being used is not supplied by SAS.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
ODS WORD <(<ID=> identifier)> < action> ;
ODS WORD <(<ID=> identifier)> <options> ;
Opens, manages, or closes the ODS destination for , which generates output compatible
with
and
later versions.
Product: Base SAS
Document: SAS Output Delivery System: User’s Guide
| |
|
OPTIONS options;
Specifies or changes the value of one or more SAS
system options.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
OPTIONS options;
Specifies or changes the value of one or more SAS
system options.
Product: Base SAS
Document: SAS System Options: Reference
| |
|
OPTIONS options-1 <. . . option-n > ;
Changes the value of one or more SAS system options.
Product: Base SAS
Document: SAS Companion for z/OS
| |
|
OUTPUT [ { table [ ... table ] }
| _ROWSET_ | _NULL_ ];
Writes the current row to a table.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
OUTPUT <data-set-name(s)>;
Writes the current observation to a SAS data set.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
PACKAGE package [/ENCRYPT=SAS | AES] [/table-options];
…
package-body … ENDPACKAGE;
PACKAGE fcmp-package-name [/ENCRYPT=SAS | AES] [/table-options]
LANGUAGE=[']FCMP[']
TABLE='library-name';
… package-body … ENDPACKAGE;
Creates a DS2 package.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
PAGE;
Skips to a new page in the SAS log.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
PATTERN<1 ...255>
<COLOR=pattern-color | _style_> <IMAGE=fileref | "external-file"> <IMAGESTYLE=TILE | FIT> <REPEAT=number-of-times> <VALUE=bar/block-pattern | plot-pattern | pie/star-pattern>; Defines the characteristics
of patterns used in graphs.
Product: SAS/GRAPH
Document: SAS/GRAPH: Reference
| |
|
PATTERN<1 ...255>
<COLOR=pattern-color | _style_> <IMAGE=fileref | "external-file"> <IMAGESTYLE=TILE | FIT> <REPEAT=number-of-times> <VALUE=block-pattern | map-pattern >; Defines the
characteristics of patterns used in maps.
Product: Base SAS
Document: SAS/GRAPH and Base SAS: Mapping Reference
| |
|
PUT < put-list > [ ... <put-list> ] ;
<put-list>::=
_ALL_
| 'character-string'
| ['character-string']<eq-expression> [=] [[:] format [-L | -C | -R]] <eq-expression>::=
identifier
| array-reference
| this-expression Prints the values of program variables, arrays,
and constants to the SAS log.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
PUT <specification(s)> <_ODS_> <@ | @@>;
PUT 'ERROR: text' | 'NOTE: text' | 'WARNING: text';
PUT 'ERROR- text' | 'NOTE- text' | 'WARNING- text';
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 DATA Step Statements: Reference
| |
|
PUT variable start-column <- end-column>
<.decimal–places> <@ | @@>; Writes variable values in the specified columns
in the output line.
Product: Base SAS
Document: SAS DATA Step 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 DATA Step 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 DATA Step 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 DATA Step Statements: 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 Output Delivery System: User’s Guide
| |
|
PUTLOG <‘text ’>;
PUTLOG <‘ERROR: text ’> <‘NOTE: text ’> <‘WARNING: text ’>
PUTLOG <‘ERROR- text ’> <‘NOTE- text ’> <‘WARNING- text ’>;
Writes a message to the SAS log.
Product: Base SAS
Document: SAS DATA Step 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 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 DATA Step Statements: Reference
| |
|
REMOVE <data-set-name(s)>;
Deletes an observation from a SAS data set.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
RENAME old-name {=
| AS} new-name [ ... old-name
{= | AS} new-name ];
Specifies new names for columns in output tables.
Product: Base SAS
Document: SAS DS2 Language 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 DATA Step Statements: Reference
| |
|
REPLACE <data-set-name-1> <...data-set-name-n>;
Replaces an observation in the same location.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
RESETLINE;
Restarts the program line numbers in the SAS log
to 1.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
RETAIN;
RETAIN column-list;
RETAIN column-list <
constant-value >;
RETAIN column-list (
< constant-value > … < constant-value > );
< constant-value >::=
bit_constant
| hex_constant
| floating_constant
| decimal_constant
| sas_missing_value
| integer_constant
| string_constant
| null
| DATE character_constant
| TIME character_constant
| TIMESTAMP character_constant RETAIN vararray;
Specifies that all columns or all columns in the
column list have their values retained between executions of the RUN
method.
Product: Base SAS
Document: SAS DS2 Language 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 DATA Step Statements: Reference
| |
|
RETURN;
Signals the end of a routine.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
RETURN [ expression ];
Returns execution from a method to the method caller.
Product: Base SAS
Document: SAS DS2 Language 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 DATA Step Statements: Reference
| |
|
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 User’s Guide
| |
|
ROLLBACK [TRANSACTION];
Rolls back transaction changes to the beginning
of the transaction.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
CONNECT TO dbms-name <AS alias> <(dbms-argument-1=value <dbms-argument-2=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-2=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 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 task2... <TIMEOUT=seconds>;
LISTTASK <_ALL_ | task> ;
KILLTASK <_ALL_ | task1task2>...; 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 User’s Guide
| |
|
RUN <CANCEL>;
Executes the previously entered SAS statements.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
%RUN;
Ends source statements following a %INCLUDE * statement.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
SASFILE <libref.> member-name<.member-type> <(password-options)>
OPEN | LOAD | CLOSE; Opens a SAS data set and allocates enough buffers
to hold the entire file in memory.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
SASFILE <libref.> member-name<.member-type> <(password-options)>
OPEN | LOAD | CLOSE; Reduces I/O processing by holding the entire data
set in memory.
Product: Base SAS
Document: SAS Companion for z/OS
| |
|
SCANFOR pause-specification-1 <pause-specification-2>...;
Specifies a pause until conditions are met (an alias
for WAITFOR).
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
The main clauses of the SELECT statement can be summarized
as follows.
SELECT
FROM
[WHERE ]
[GROUP
BY ]
[HAVING ]
[ORDER
BY ]
[LIMIT
{count | ALL}]
[OFFSET number] ;The detailed syntax of the SELECT statement is as follows.
[ORDER
BY [, ...]]; ::=
{ | }
{UNION [ALL] [CORRESPONDING [BY
(column, column, ...)]]}{ | } ::=
SELECT [ALL | DISTINCT] ::=
*
| column [AS column-alias]
| expression [AS column-alias]
| table.*
| table-alias.* ::=
FROM [, ...]
[WHERE ]
[GROUP BY [, ...]]
[HAVING ] ::=
table [[AS] alias]
|
CONNECTION TO catalog () [[AS] alias]
|
() [[AS] alias]
|
::=
|
|
::=
CROSS
JOIN ::=
[] JOIN ::=
NATURAL [] JOIN ::=
INNER
| LEFT [OUTER]
| RIGHT [OUTER]
| FULL [OUTER] ::=
ON
| USING (column [, ...column]) ::=
{
[NOT] { |
()}
}
[{AND | OR} [NOT] { |
()}] [,... {[NOT] { |
()} [{AND | OR} [NOT] { | ()}]}] ::=
expression {operator | predicate} expression ::=
{order-by-expression [ASC | DESC]} [, ...order-by-expression [ASC | DESC]] ::=
column [, ...column]
| column-position-number
| Retrieves columns and rows of data from tables.
Product: SAS Cloud Analytic Services
Document: SAS Viya: FedSQL Programming for SAS Cloud Analytic Services
| |
|
SELECT [ ( select-expression ) ];
[ < when-list > [ …<
when-list> ] ] ;
[ OTHERWISE statement-list ] ; END [ end-label ];
<when-list>::=
WHEN ( when-expression ) [ statement-list ] Executes one of several statements or groups of
statements.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
The main clauses of the SELECT statement can be summarized
as follows.
SELECT
FROM
[WHERE ]
[GROUP BY ]
[HAVING ]
[ORDER BY ]
[LIMIT {count | ALL}]
[OFFSET number] ;The detailed syntax of the SELECT statement is as follows.
[ORDER BY [, ...]]; ::=
{ | }
{UNION
| EXCEPT | INTERSECT} {[ALL][CORRESPONDING [BY (column[,... column])]]}
{ | } ::=
SELECT [ALL | DISTINCT] ::=
*
| column [AS column-alias]
| expression [AS column-alias]
| table.*
| table-alias.*
| table.column [AS column-alias] ::=
FROM [, ...]
[WHERE ]
[GROUP
BY [, ...]]
[HAVING ] ::=
table [[AS] alias]
|
CONNECTION TO catalog () [[AS] table-alias]
|
() [AS] alias
|
::=
|
|
::=
CROSS
JOIN ::=
[] JOIN ::=
NATURAL [] JOIN ::=
INNER
| LEFT [OUTER]
| RIGHT [OUTER]
| FULL [OUTER] ::=
ON
| USING (column [, ...column]) ::=
{
[NOT] { |
()}
}
[{AND | OR} [NOT] { |
()}] [,...
{[NOT] { |
()} [{AND | OR} [NOT] { | ()}]}] ::=
expression {operator | predicate} expression ::=
{order-by-expression [ASC | DESC]} [, ...order-by-expression [ASC | DESC]] ::=
column [, ...column]
| column-position-number
| Retrieves columns and rows of data from tables.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
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 DATA Step Statements: Reference
| |
|
SET FROM thread [ THREADS
= threads ];
Runs a DS2 program as one or more threads.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
SET < table-reference > [ ... <
table-reference > ] [INDSNAME=variable] ;
[ BY [ DESCENDING ] column [ ... [ DESCENDING ] column ]]
;
< table-reference>::=
{ table [ (table-options) ] }
| \{ sql-text \} Reads rows from one or more tables.
Product: Base SAS
Document: SAS DS2 Language 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 DATA Step Statements: Reference
| |
|
SIGNOFF <options>;
Ends the connection between a client session and
a server session.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
SIGNON <options>;
Initiates a connection between a client session
and a server session.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
SKIP <n>;
Creates a blank line in the SAS log.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
STOP;
Stops execution of a script under normal conditions.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
STOP;
Stops execution of the current DS2 program.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
STOP;
Stops execution of the current DATA step.
Product: Base SAS
Document: SAS DATA Step Statements: Reference
| |
|
SUBMIT INTO object-reference; ...python-code... ENDSUBMIT;
SUBMIT INTO object-reference("file-path");
Inserts Python source code into a Python object
at parse time.
Product: Base SAS
Document: SAS Component Objects: Reference
| |
|
variable + expression;
variable – expression;
Adds or subtracts the result of an expression to
an accumulator variable.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
variable+expression;
Adds the result of an expression to an accumulator
variable.
Product: Base SAS
Document: SAS DATA Step 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 the GBARLINE, GCONTOUR,
and GPLOT procedures.
Product: SAS/GRAPH
Document: SAS/GRAPH: Reference
| |
|
SYSECHO <"text"> ;
Sends a global statement complete event and passes
a text string back to the IOM client.
Product: Base SAS
Document: SAS Global 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 User’s Guide
| |
|
%SYSRPUT macro-variable=value;
%SYSRPUT _USER_
</LIKE=‘character-string’>; Assigns a value from the server session to a macro
variable in the client session.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
SYSTASK LIST <_ALL_ | taskname> <STATE> ;
Lists asynchronous tasks.
Product: Base SAS
Document: SAS Companion for z/OS
| |
|
SYSTASK COMMAND "operating-environment-command" <WAIT | NOWAIT>
<TASKNAME=taskname> <MNAME=name-variable> <STATUS=status-variable> <SHELL="shell-command"> <CLEANUP>; SYSTASK LIST<taskname> <STATE> <STATVAR>;
SYSTASK KILL taskname <taskname...>;
Executes asynchronous tasks.
Product: Base SAS
Document: SAS Companion for UNIX Environments
| |
|
SYSTASK COMMAND "operating system command"<WAIT
| NOWAIT>
<TASKNAME=taskname> <MNAME=name-variable> <STATUS=stat-variable> <SHELL<="shell-command"> > ; SYSTASK LIST <_ALL_ | taskname > <STATE> <STATVAR>;
SYSTASK KILL taskname <taskname...>;
Executes, lists, or terminates asynchronous tasks.
Product: Base SAS
Document: SAS Companion for Windows
| |
|
THREAD thread [ ( data-type variable [ , ... data-type variable ] ) ]
[/ENCRYPT=SAS | AES] [/table-options]; … thread-body … ENDTHREAD;
Creates a DS2 program thread.
Product: Base SAS
Document: SAS DS2 Language 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: 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: Base SAS
Document: SAS/GRAPH and Base SAS: Mapping Reference
| |
|
TITLE <n> <ods-format-options> <'text' | "text">;
Specifies title lines for SAS output.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
TITLE <n> <'text'
| "text">;
Specifies title lines for SAS output.
Product: Base SAS
Document: SAS Companion for UNIX Environments
| |
|
TITLE <n> <'text'
| "text">;
prints up to ten title lines for SAS output.
Product: Base SAS
Document: SAS Companion for Windows
| |
|
TITLE<n> <'text' | "text"> ;
Specifies title lines for SAS output.
Product: Base SAS
Document: SAS Companion for z/OS
| |
|
TITLE<n> <text-options> <"text"> ;
FOOTNOTE<n> <text-options> <"text">;
The TITLE and FOOTNOTE statements control the content,
appearance, and placement of title and footnote text.
Product: Base SAS
Document: SAS ODS Graphics: Procedures Guide
| |
|
TRACE ON | OFF;
Controls the display of script statements in the Log window
as they execute.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
TSO <command>;
Executes a TSO command, emulated USS command, or
MVS program.
Product: Base SAS
Document: SAS Companion for z/OS
| |
|
TYPE text;
Sends characters to the server as if they were entered
at a personal computer.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
UPDATE table
{
SET column= [, ...column=]
| column=value-expression [, ...column=value-expression]
}
[WHERE | value-expression]; Modifies a column's values in existing rows
of a table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
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 DATA Step Statements: Reference
| |
|
VARARRAY <data-type> array-name <array-declaration> [<variable-list>] [<having-clause>];
< data-type >::=
<exact-numeric-type>
| <approximate-numeric-type> | <binary-string-type> |
<string-type>
| <date-type> <exact-numeric-type>
::=
{INT | BIGINT | SMALLINT | TINYINT | DECIMAL [(precision [,scale] )] | NUMERIC [(precision [,scale])] } <approximate-numeric-type>
::=
{ DOUBLE | DOUBLE PRECISION | FLOAT | REAL }
<binary-string-type>::=
BINARY(length)
| VARBINARY(length)
<string-type>::=
NCHAR [ ( character-length )
]
| NVARCHAR [ ( character-length )
]
| CHAR [ ( character-length )
] [CHARACTER SET character-set-identifier ]
| VARCHAR [ ( character-length )
] [CHARACTER SET character-set-identifier ] <date-type>::=
{ TIME | TIMESTAMP }
[ ( precision ) ] | DATE
<array-declaration::=\[array-bound>[, ...<array-bound>]\
<array-bound>::=
{[dim-lower:]dim-upper}
| {[dim-lower:] {DIM(a[, n])
| *} }
<variable-list>::=
name-varlist |
| numbered-range-varlist | name-range-list | name-prefix-list | type-varlist | special-name-list <having-clause>::=
HAVING <having-option>
[… <having-option> ]
<having-option>::=
LABEL 'string'
| n'string'
| FORMAT format
| INFORMAT format Declares one or more DS2 variable arrays.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
VARLIST list-name \[variable-list\];
Creates a named variable list.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
WAITFOR pause-specification-1<pause-specification-2>...;
Specifies a pause until specific conditions are
met.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
| |
|
WAITFOR <_ANY_|_ALL_> task task2... <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 User’s Guide
| |
|
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 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 Companion for Windows
| |
|
WAITFOR <_ANY_ | _ALL_> taskname-1 <taskname-2 ...> <TIMEOUT=seconds>;
Suspends execution of the current SAS session until
the specified tasks finish executing.
Product: Base SAS
Document: SAS Companion for z/OS
| |
|
Selects observations from SAS data sets that meet
a particular condition.
Product: Base SAS
Document: SAS 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 DATA Step 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 DATA Step Statements: Reference
| |
|
X <'operating-environment-command'>;
Issues an operating-system command from within a
SAS session.
Product: Base SAS
Document: SAS Global Statements: Reference
| |
|
X <'>operating-system-command<'>;
Issues an operating environment command from within
a SAS session.
Product: Base SAS
Document: SAS 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 Companion for Windows
| |
|
X <command> ;
X TSO:<command>;
X XEQ: pgmname <parms> ;
X AEQ: pgmname <parms> ;
X WEQ: pgmname <parms> ;
X Ann: pgmname <parms> ;
X Wnn: pgmname <parms> ;
Executes a TSO command, emulated USS command, or
MVS program.
Product: Base SAS
Document: SAS Companion for z/OS
|
Last updated: March 30, 2026