|
|
|
|
|
|
|
enables you to import
a comma-separated file and write the output to a SAS data set.
|
|
|
enables you to import
a Microsoft XLSX file and write the output to a SAS data set.
|
|
|
provides a template
for a DS2 package. A package is similar to a DS2 program. The package
body consists of a set of global declarations and a list of methods.
The main syntactical differences are the PACKAGE and ENDPACKAGE statements.
These statements define a block with global scope. For more information,
see SAS DS2 Language Reference.
|
|
|
provides a template
for a DS2 program. DS2 is a SAS programming language that is appropriate
for advanced data manipulation. DS2 is included with Base SAS and
shares core features with the SAS DATA step. DS2 exceeds the DATA
step by adding variable scoping, user-defined methods, ANSI SQL data
types, and user-defined packages. The DS2 SET statement accepts embedded
FedSQL syntax, and the run-time-generated queries can exchange data
interactively between DS2 and any supported database. This allows
SQL preprocessing of input tables, which effectively combines the
power of the two languages. For more information, see SAS DS2 Language Reference.
|
|
|
provides a template
for a DS2 threaded program. Typically, DS2 code runs sequentially.
That is, one process runs to completion before the next process begins.
It is possible to run more than one process concurrently, using threaded
processing. In threaded processing, each concurrently executing section
of code is said to be running in a thread. For more information, see SAS DS2 Language Reference.
|
|
|
enables you to export
SAS data as a comma-separated text file.
|
Generate PowerPoint
Slide
|
enables you to stream
Microsoft PowerPoint output to your web browser.
|
|
|
enables you to export
SAS data as an XML file that you can view in your web browser.
|
Simulate Linear Regression
Data
|
creates an input data
source that you can use for linear regression analysis. Linear regression
analysis tries to assign a linear function to your data by using the
least squares method.
|
Simulate One-Way ANOVA
Data
|
creates an input data
source that considers one treatment factor with three treatment levels.
When you analyze this data by using the One-Way ANOVA task, the goal
is to test for differences among the means of the levels and to quantify
these differences.
|
|
|
|
|
enables you to specify
the content for the SOURCE entry type in a catalog. The SOURCE entry
can contain the same code as SAS programs.
|
|
|
lists in a SAS table
all of the catalogs in the specified library. By default, this table
is saved in the Work library and with catalogs as the filename.
|
|
|
lists all the catalog
types in the specified catalog.
|
|
|
prints the GRSEG entry
to the open destinations specified by the SAS Output Delivery System
(ODS output).
|
|
|
|
|
provides a template
for writing SQL queries. For more information, see SAS SQL Procedure User's Guide.
|
|
|
provides a template
for creating HTML, PDF, and RTF output by using the SAS Output Delivery
System. For more information, see SAS Output Delivery System: User's Guide.
|
Note: For more information about
the SGPLOT, SGPANEL, and SGSCATTER procedures, see SAS ODS Graphics: Procedures Guide.
|
|
|
uses the VBAR statement
in the SGPANEL procedure and enables you to create multiple bar charts.
|
|
|
uses the VBOX statement
in the SGPANEL procedure and enables you to create multiple box plots.
|
|
|
uses the COMPARE statement
in the SGSCATTER procedure. This code snippet creates a comparative
panel of scatter plots with shared axes.
|
|
|
uses the DOT statement
in the SGPLOT procedure. Dot plots summarize horizontally the values
of a category variable. By default, each dot represents the frequency
for each value of the category variable.
|
|
|
uses the REG statement
in the SGPLOT procedure. This code snippet produces a regression plot
with a quadratic fit and includes confidence limits.
|
|
|
uses the HBAR statement
in the SGPLOT procedure. This code snippet creates a horizontal bar
chart that summarizes the values of a category variable.
|
|
|
uses the HIGHLOW statement
in the SGPLOT procedure. High-low charts show how several values of
one variable relate to one value of another variable. Typically, each
variable value on the horizontal axis has several corresponding values
on the vertical axis.
|
|
|
uses the HISTOGRAM statement
in the SGPLOT procedure. This code snippet produces a histogram with
two density plots. In this snippet, one density plot uses a normal
density estimate and the other density plot uses a kernel density
estimate.
|
|
|
uses the MATRIX statement
in the SGSCATTER procedure. This code snippet creates a scatter plot
matrix.
|
|
|
uses the VBOX statement
in the SGPLOT procedure. A box plot summarizes the data and indicates
the median, upper and lower quartiles, and minimum and maximum values.
The plot provides a quick visual summary that easily shows center,
spread, range, and any outliers. The SGPLOT and the SGPANEL procedures
have separate statements for creating horizontal and vertical box
plots.
|
Note: For more information about
SAS macros, see SAS Macro Language: Reference.
|
|
|
provides several examples
of these SAS macros that work with character values:
-
The %EVAL function evaluates arithmetic
and logical expressions by using integer arithmetic. This function
operates by converting its argument from a character value to a numeric
or logical expression. After the expression is evaluated, the result
is converted back to a character value.
This function is useful
because the SAS Macro Facility is basically a text generator. As a
result, an arithmetic expression is first converted to a numeric expression.
After this numeric expression is evaluated, it is converted back to
an arithmetic expression.
-
The %INDEX function returns the
position of the first character of a string.
-
The %LENGTH function returns the
length of a string.
-
The %SCAN function searches for
a word that is specified by its position in a string.
-
The %SUBSTR function produces a
substring of a character string.
-
The %UPCASE function converts values
to uppercase.
|
|
|
designates the beginning
of a section of a macro definition that is treated as a unit until
a matching %END statement is encountered. This macro section is called
a %DO group.
A simple %DO statement
often appears in conjunction with %IF-%THEN-%ELSE statements to designate
a section of the macro to be processed depending on whether the %IF
condition is true or false.
Note: SAS also provides a %DO iterative
statement, which is different from the code that is generated by this
snippet. For more information, see SAS Macro Language: Reference.
|
|
|
conditionally processes
a portion of a macro. The expression that is the condition for the
%IF-%THEN-%ELSE statement can contain only operands that are constant
text or text expressions that generate text.
|
|
|
names one or more local
macro variables whose values you specify when you invoke the macro.
There are two types of macro variables: positional and keyword. Parameters
are local to the macro that defines them. You must supply each parameter
name. You cannot use a text expression to generate it. A parameter
list can contain any number of macro parameters separated by commas.
The macro variables in the parameter list are usually referenced in
the macro.
|
|
|
provides a basic template
for working with SAS macros. Macros enable you to perform many tasks,
including substituting text in a program. A SAS program can contain
any number of macros, and you can invoke a macro multiple times in
a single program. For more information, see SAS Macro Language: Reference.
|
|
|
provides examples of
macro functions that tell the macro processor to interpret special
characters and mnemonics as text rather than as part of the macro
language.
-
The %STR function masks special
characters and mnemonic operators in constant text at macro compilation.
This function masks these special characters and mnemonic operators: + - * / < > = ¬ ^ ~ ; , # blank
AND OR NOT EQ NE LE LT GE GT IN This function also
masks these characters when they occur in pairs and when they are
not matched and are marked by a preceding %: ' " ()
-
The %NRSTR function masks special
characters and mnemonic operators in constant text at macro compilation.
This function masks all of the special characters and mnemonic operators
listed for the %STR function. In addition, the %NRSTR function masks
these characters: & %
-
The %BQUOTE function masks special
characters and mnemonic operators in a resolved value at macro execution.
This function masks these special characters and mnemonic operators: ' " () + - * / < > = ¬ ^ ~ ; , # blank
AND OR NOT EQ NE LE LT GE GT IN
|
SAS Macro Quoting (continued)
|
-
The %SUPERQ function masks all
special characters and mnemonic operators at macro execution but prevents
further resolution of the value. This function masks these special
characters and mnemonic operators: & % ' " () + - * / < > = ¬ ^ ~ ; , # blank
AND OR NOT EQ NE LE LT GE GT IN
-
The %QSCAN function searches for
a word and masks special characters and mnemonic operators.
-
The %QSUBSTR function produces
a substring and masks special characters and mnemonic operators.
-
The %QUPCASE function converts
a value to uppercase and returns a result that masks special characters
and mnemonic operators.
-
The %UNQUOTE function unmasks a
value during macro execution so that any special characters and mnemonic
operators are interpreted as macro language elements instead of text.
For more information
about macro complication and macro execution, see SAS Macro Language: Reference.
|
|
|
provides examples of
how to create user-defined global and local macro variables. Macro
variables are tools that enable you to dynamically modify the text
in a SAS program through symbolic substitution. You can assign large
or small amounts of text to macro variables. Then you can use that
text by simply referencing the variable that contains the text.
Macro variables that
are defined by the macro programmer are called user-defined macro
variables. Macro variables that are defined by the macro processor
are called automatic macro variables. You can define and use macro
variables anywhere in SAS programs, except within data lines.
|
Note: These snippets are available
only if your site licenses SAS/IML.
|
Find Roots of Nonlinear
Equation
|
enables you to find
the roots of a function of one variable. Finding the root (or zero)
of a function enables you to solve nonlinear equations.
|
|
|
enables you to numerically
integrate a one-dimensional function by using the QUAD subroutine
in SAS/IML software. Use the QUAD subroutine to numerically find the
definite integral of a function on a finite, semi-infinite, or infinite
domain.
|
Generate a Bootstrap
Distribution
|
uses the IML procedure
to create and analyze a bootstrap distribution of the sample mean.
|
Fit by using Maximum
Likelihood
|
uses maximum likelihood
estimation to estimate parameters for the normal density estimate.
|
Simulate Multivariate
Normal Data
|
simulates data from
a multivariate normal distribution with a specified mean and covariance.
|
