Index
A
absolute column references
ACROSS option
DEFINE statement (REPORT)
LEGEND statement
ACTUAL= option, HBULLET statement (GKPI)
Add Abbreviation dialog box
Add Action dialog box
ADD method
age calculations
about
functions for
simple formula for
society measuring age
%AGE macro function
AGE statement, DATASETS procedure
aliases, report items and
aligning
decimal points
texting across rows
ALL keyword
_ALL_ list abbreviation
DATASETS procedure and
inserting separators manually
SORT procedure and
ALTER data set option
-ALTLOG initialization option
ampersand (&)
ANALYSIS option, DEFINE statement (REPORT)
ANCHOR= option, ODS PDF statement
anchor tags (HTML)
AND operator
ANGLE= option, AXIS statement
ANNO= option
annotate facility
ANNOTATE= option
ANYALNUM function
ANYALPHA function
ANYDATE informats
ANYDIGIT function
ANYDTDTE. informat
ANYDTDTE10. informat
ANYDTDTM. informat
ANYDTTME. informat
ANYPUNCT function
ANYSPACE function
ANYUPPER function
ANYXDIGIT function
APPEND option, CONFIG.CFG file
APPEND statement, DATASETS procedure
Appender object
appending data sets
application tool bar, adding tools to
ARCOS function
ARRAY statement
key indexing and
reordering variables on PDV and
shorthand variable naming and
syntax for
temporary arrays and
transposing data example
arrays
about
functions used within
implicit
key indexing and
shorthand variable naming and
syntax for
table lookup techniques
temporary
transposing data to
ASCENDING option
CLASS statement (MEANS)
CLASS statement (SUMMARY)
ASCII collating sequence
ASIS style attribute
Assign Keys dialog box
assignment statements, logical and comparison operators in
asterisk (*)
at sign (@)
ATTACH= option, FILENAME statement
ATTRIB statement
DATASETS procedure
reordering variables on PDV and
ATTRN function
autocall macro libraries
-AUTOEXEC initialization option
AUTOEXEC.SAS program
AUTOLABEL option, OUTPUT statement
automatic dates
automatic variables
See specific automatic variables
automating processes
AUTONAME option, OUTPUT statement
AutoSave feature (Enhanced Editor)
AVG. format
AXIS statement
about
ANGLE= option
COLOR= option
FONT= option
generating box plots
HEIGHT= option
LABEL= option
MAJOR= option
MINOR= option
ORDER= option
ROTATE= option
UNIVARIATE procedure and
VALUE= option
B
%B directive
%b directive
BACKGROUND= attribute
BCOLOR= option
FOOTNOTE statement
TITLE statement
BEEP command
BEST. format
BEST32. format
BETWEEN operator
BINARY. format
binary number conversions
BMI (Body Mass Index)
BMP files
Body Mass Index (BMI)
BODYTITLE option, ODS RTF statement
BOLD option
FOOTNOTE statement
TITLE statement
Boolean transformations
BORDER graphics option
BOX= option, TABLE statement (TABULATE)
box plots, generating
BOXPLOT procedure
about
high-resolution graphs and
PLOT statement
BOXSTYLE option, PLOT statement (BOXPLOT)
BOXWIDTH option, PLOT statement (BOXPLOT)
BOXWIDTHSCALE option, PLOT statement (BOXPLOT)
%BQUOTE macro function
_BREAK_ automatic variable
BWIDTH= option, SYMBOL statement
BY-group processing
eliminating duplicate observations
FIRST. processing and
indexes and
LAST. processing and
WHERE statement and
BY statement
CLASS statement and
ID statement and
indexes and
MERGENOBY= system option and
percentile statistics example
PRINT procedure
SORT procedure
table lookup techniques
TRANSPOSE procedure
UNIVARIATE procedure
BY variables
attribute consistency
common to data sets
FREQ procedure and
repeating
UNIVARIATE procedure and
#BYLINE option, TITLE statement
#BYVAL option
FOOTNOTE statement
TITLE statement–476
#BYVAR option
FOOTNOTE statement
TITLE statement–476
C
calculations
moving averages–380
person's age
CALL DEFINE routine
REPORT procedure and
style attributes and
style overrides and
traffic lighting and
CALL EXECUTE routine
CALL MISSING routine
about
arrays and
building FIFO stacks
eliminating duplicate observations
transposing data to arrays
CALL MODULE routine
CALL PRNTCRIT routine
CALL SYMPUT routine
CALL SYMPUTX routine
about
building list of macro variables
CALL SYMPUT routine and
%GETGLOBAL macro and
IF statement processing and
saving values of options
CALL SYSTEM routine
CAPABILITY procedure
CARDS statement
CARDS4 statement
Cartesian product
case-sensitive reordering
CASE statement, SQL procedure
CASE_FIRST keyword
CAT function
CATALOG procedure
catalogs
concatenating
deleting
renaming
saving formats
saving informats
CATQ function
CATS function
CATT function
CATX function
CEIL function
CELLWIDTH= attribute
C2F function
C2FF function
CHANGE statement, DATASETS procedure
CHARACTER list modifier
_CHARACTER_ variable name list
character variables
CMISS function and
shorthand naming
variable conversions and
CHARTYPE option
MEANS procedure
SUMMARY procedure
CHECK method
CHISQ option, TABLE statement (FREQ)
CLASS statement, GLM procedure
CLASS statement, MEANS procedure
ASCENDING option
BY statement and
DESCENDING option
EXCLUSIVE option
generalizing programs example
GROUPINTERNAL option
missing classification variables and
MISSING option
MLF option
ORDER= option–238
ordered data and
PRELOADFMT option
sort considerations
CLASS statement, SUMMARY procedure
ASCENDING option
BY statement and
DESCENDING option
EXCLUSIVE option
GROUPINTERNAL option
MISSING option
MLF option
ORDER= option, 237–238
ordered data and
PRELOADFMT option
CLASS statement, TABULATE procedure
about
EXCLUSIVE option
MLF option
PRELOADFMT option
splitting statements
STYLE= option
CLASS statement, UNIVARIATE procedure
about
KEYLEVEL= option
CLASSDATA= option
MEANS procedure
SUMMARY procedure
TABULATE procedure–268
classification variables
CLASSLEV statement, TABULATE procedure
CLEAR method
CLEAR option
LIBNAME statement
ODS LISTING statement
%CLEARTEMPWORK macro
$CL_NAME. format
CLOSE option, ODS LISTING statement
$CL_REG. format
CMISS function
CMPLIB system option
accessing functions
pointing to function definitions
removing functions
$CNAME. format
$CNAME20. format
CNTLIN= option, FORMAT procedure
CNTLOUT= option, FORMAT procedure
COALESCE function
code generation, macro language
code substitution
Cody, Ron
collapsing dates
colon (:)
as comparison modifier
as format modifier
in constructors
shorthand variable naming and
COLOR= option
AXIS statement
FOOTNOTE statement
SYMBOL statement
TITLE statement
column names in VIEWTABLE
COLUMN statement, REPORT procedure
columns in reports
absolute column references
column placement notation and
consolidating
dummy
COLUMNS window (Display Manager)
comma (,)
COMMA7. format
comma-slash (,,/)
comments in macros
COMPARE function
COMPARE= option, COMPARE procedure
COMPARE procedure
about
automating process
COMPARE= option
DATA= option
OUT= option
OUTBASE option
OUTCOMP option
OUTNOEQUAL option
comparison functions
comparison operators
colon modifier in
in assignment statements
COMPBL function
COMPCOST function
COMPGED function
COMPLETECOLS option, REPORT procedure
COMPLETEROWS option, REPORT procedure
COMPLETETYPES option
MEANS procedure
SUMMARY procedure
COMPLEV function
composite indexes
COMPOUND function
compound inequalities
compound variable names
COMPRESS function–165
%COMPRESS macro function
compute blocks
about
dummy columns to consolidate
execution overview
naming report items in
COMPUTED option, DEFINE statement (REPORT)
concatenating
format catalogs
tables
concatenation functions
concatenation operator (||)
-CONFIG initialization option
CONFIG.CFG file
configuration file
about
changing SASAUTOS location
common customizations of
controlling DM initialization
default name
location of
CONNECT statement, SQL procedure
CONSORT flow diagram
CONSTANT function
constructors
about
colon in
DATASET:
HASHEXP:
ORDERED:
CONTAINS operator
CONTENTS= option, REPORT procedure
CONTENTS procedure
indexes and
macro information sources and
metadata sort information and
OUT= option
reordering variables on PDV
VARNUM option
COPY procedure
%COPYSASMACR macro
CORR keyword
COUNT function
COUNTC function
counting functions
COUNTW function
CPUCOUNT system option
Crawford, Peter
CREATE INDEX statement, SQL procedure
CREATE option, INDEX statement (DATASETS)
CSV destination
CSV files
additional information
importing/exporting
writing
CTEXT= graphics option
CTITLE= graphics option
CTONUM. informat
Customize Tools dialog box
D
%D directive
dagger symbol
dash (-)
data engines
additional information
clearing librefs and
determining availability of
LIBNAME statement and
options associated with
reading and writing data with
replacing Excel sheets with
viewing data
data normalization
about
TRANSPOSE procedure and
transposing in DATA steps
DATA= option
COMPARE procedure
DELETE procedure
EXPORT procedure
TRANSPOSE procedure
data processing options
data set options
about
controlling observations
controlling replacement conditions
DATA step statements and
ODS OUTPUT statement and
password protection
SORT procedure and
data sets
accessing metadata for
appending
automating processes and
breaking up
building and maintaining indexes
building formats from
creating
deleting
indexes and
processing metadata across
protecting passwords
recovering physical location information
renaming
reordering variables on PDV
updating with hash tables
data source statements
Data Step Component Interface
See DSCI (Data Step Component Interface)
DATA steps
See also specific DO loops
See also specific statements and functions
accessing metadata of data sets
alternative functions
ANY family of functions
appending data sets
arrays in
building
calculating person's age
comparison functions
component objects in
concatenation functions
counting functions
creating indexes
data set options
determining unique keys
eliminating duplicate observations
executing OS commands
finding minimum/maximum values
generating e-mails
HASH objects and
IN comparison operator and
joins and merges in
NOT family of functions
powerful and flexible functions
processing across observations
transposing data in
underutilized functions
variable conversions
variable information functions
WHERE usage in
data validation
about
checking date strings
in metadata-driven programs
database passwords
DATALINES statement
DATA_NULL step
DATAROW statement, IMPORT procedure
DATASET: constructor
DATASETS procedure
AGE statement
APPEND statement
ATTRIB statement
CHANGE statement
copying index files
creating indexes
DELETE statement
deleting data sets
deleting sheets
INDEX statement
KILL option
MEMTYPE= option
MODIFY statement
NOLIST option
DATASTMTCHK system option
%DATATYP macro function
DATATYPE= option, PICTURE statement (FORMAT)
%DATAVAL macro
date directives
DATE function
date manipulation
intervals and ranges
nested dates
date values
$DATEC. format
DATEN. format
DATEPART function
dates
automatic
building date-specific formats
checking strings with formats
collapsing
expanding
intervals/ranges for
previous month by name
reading in mixed dates
DATESTYLE system option
DATETIME function
datetime values–390
DAY function
DBMS= option
EXPORT procedure
IMPORT procedure
debugging macro programs
decimal number conversions
decimal points, aligning
DECLARE statement
about
eliminating duplicate observations
HASH objects and
hash tables referencing hash tables
simple sort example
DEFAULT= option, VALUE statement (FORMAT)
DEFINE routine
See CALL DEFINE routine
DEFINE statement, REPORT procedure
ACROSS option
ANALYSIS option
COMPUTED option
DISPLAY option
GROUP option
JUST= style attribute
MISSING option
NOPRINT option
NOZERO option
ORDER= option
PRELOADFMT option
superscripts and
DEFINEDATA method
DEFINEDONE method
DEFINEKEY method
DELETE method
DELETE option, INDEX statement (DATASETS)
DELETE procedure
DELETE statement, DATASETS procedure
DELETEFUNC statement, FCMP procedure
DELETESUBR statement, FCMP procedure
deleting
catalogs
data sets
Excel sheets
DelGobbo, Vince
DELIMITER= option
CSV tagset
EXPORT procedure
FILE statement
INFILE statement
delimiters
controlling input
inserting manually
multiple
writing delimited files
DEQUOTE function
DESCENDING option
CLASS statement (MEANS)
CLASS statement (SUMMARY)
SORT procedure
DESCRIBE statement, SQL procedure
DeVenezia, Richard
DEVICE= graphics option
DICTIONARY tables
additional information
attributes of data sets and
list of
recovering physical location information
SQL procedure and
DICTIONARY.CATALOGS table
DICTIONARY.COLUMNS table
DICTIONARY.DICTIONARIES table
DICTIONARY.ENGINES table
DICTIONARY.EXTFILES table
DICTIONARY.FORMATS table
DICTIONARY.FUNCTIONS table
DICTIONARY.GOPTIONS table
DICTIONARY.INDEXES table
DICTIONARY.LIBNAMES table
DICTIONARY.MACROS table
DICTIONARY.MEMBERS table
DICTIONARY.OPTIONS table
DICTIONARY.STYLES table
DICTIONARY.TABLES table
DICTIONARY.TITLES table
DICTIONARY.VIEWS table
DIF function
DIM function
DIR command
direct addressing (key indexing)
DISCONNECT statement, SQL procedure
Display Manager
about
adding to pull-down and pop-up menus
adding tools to application tool bar
adding tools to KEYS list
bringing up windows
COLUMNS window
controlling initialization
Enhanced Editor
executing commands
VIEWTABLE window
DISPLAY option, DEFINE statement (REPORT)
DISTINCT function
DLL (Dynamic Link Library)
DLM= option
FILE statement
INFILE statement
DLMOPT option, INFILE statement
DLMSTR= option
FILE statement
INFILE statement
DM statement
about
additional information
executing commands
quotation marks and
WRTFSAVE option
DMOPTLOAD command
DMOPTSAVE command
%DO loop
EXPORT procedure and
semicolons and
usage example
DO loops
compound
key index lookups
LAG function in
MIDPOINTS option and
OUTPUT statement in
principles of
special forms
DO UNTIL loop
breaking up data sets
eliminating duplicate observations
FINDC function and
HASH object example
key index lookups
stepping through hash tables
variable information functions example
DO WHILE loop
DOC files
dollar sign ($)
%DOPROCESS macro
Dorfman, Paul
DOS command window
dot notation
DOT symbol
double negation
double SET statements
about
look-ahead technique and
MERGE statement and
table lookup techniques
double transpose
DOW (Do-Whitlock) loop
DPARTC. format
$DPARTC. format
DPARTN. format
DROP= data set option
DROP statement
DROP= data set option and
reordering variables on PDV
shorthand variable naming and
DROP TABLE statement, SQL procedure
DSCI (Data Step Component Interface)
about
accessing methods within objects
additional information
breaking up data sets
declaring objects
hash tables referencing hash tables
hash tables updating master data sets
simple sort using HASH object
stepping through hash tables
%DS2CSV macro
DSD option
FILE statement
INFILE statement
%DTEST macro
dummy columns
duplicate observations
about
eliminating
FIRST. processing
FREQ procedure and
HASH objects and
LAST. processing
SORT procedure and
SQL procedure and
DUPOUT= option, SORT procedure
Dynamic Link Library (DLL)
dynamic macro programming
E
e-mails, writing and sending
EBCDIC collating sequence
Edit Keyboard Macro dialog box
ELSE statement
DLM option and
logical and comparison operators in
OUTPUT statement and
EMAIL engine
EMAILHOST= system option
EMAILID= system option
ENCRYPT data set option
END option, ODS LAYOUT statement
END= option, SET statement
about
breaking up data sets example
DO loop examples
look-ahead example
ENDSAS statement
ENDSUB statement, FCMP procedure
Enhanced Editor (Display Manager)
adding tools to application tool bar
additional information
AutoSave feature
macro abbreviations for
options and shortcuts
Enhanced Editor Keys dialog box
Enhanced Editor Options dialog box
environmental variables
EQT operator
EQUALS option, SORT procedure
_ERROR_ automatic variable
error handling
controlling data validations
controlling with macros
customizing
writing to error data sets
%ERRRPT macro
escape character sequences
changing text attributes
controlling indentations
controlling line breaks
controlling spacing
dagger symbol
inline formatting and
page X of Y
subscripts
superscripts
%EVAL macro function
evaluating expressions
about
additional information
Boolean transformations
colon in comparison operators
comparison operators in assignment statements
compound inequalities
data validation
exception reporting
MIN and MAX operators
numeric expressions
operator hierarchy
EXCEL engine
about
additional information
replacing Excel sheets with
working with named ranges
Excel sheets and workbooks
deleting
generating multisheet
naming considerations
preventing export of blank
recovering names of
replacing with data engines
working with named ranges
writing reports to tables
EXCELXP destination
EXCELXP tagset
about
additional information
documentation and options
generating multisheet workbooks
OPTIONS option
SHEET_INTERVAL option
EXCEPT operator (SQL)
exception reporting
controlling data validations
controlling with macros
customizing
writing to error data sets
%EXCEPTIONS macro
EXCLUSIVE option
CLASS statement (MEANS)
CLASS statement (SUMMARY)
CLASS statement (TABULATE)
MEANS procedure
REPORT procedure
SUMMARY procedure
TABULATE procedure
EXIT command (DOS)
EXPAND procedure
expanding dates
Explorer Options: Table Options dialog box
Explorer Options dialog box
Explorer window
EXPORT procedure
about
additional information
DATA= option
DBMS= option
DELIMITER= option
EXCELXP tagset and
exporting CSV files
OUTFILE= option
preventing export of blank sheets
reordering variables on PDV
REPLACE option
SHEET= statement
writing delimited files
exporting CSV files
expressions, evaluating
See evaluating expressions
Extensible Markup Language (XML)
EXCELXP tagset and
MARKUP destination
reading and writing to
XML engine
F
F= option
See FONT= option
F2C function
F2CC function
FCMP Function Editor
FCMP procedure
about
additional information
age measurement formula and
DELETEFUNC statement
DELETESUBR statement
ENDSUB statement
FUNCTION statement
interacting with macro language
OUTLIB= option
passing values to functions and
RETURN statement
SUBROUTINE statement
FIFO stacks
FILE= option
ODS CSV statement
ODS MARKUP statement
FILE statement
DLM= option
DLMSTR= option
DSD option
EMAIL engine and
LRECL= option
FILENAME function
FILENAME statement
ATTACH= option
executing OS commands
FROM= option
PIPE device type and
SUBJECT= option
TO= option
FILENAME window
filtering missing values
FIND function
FIND method
about
hash tables referencing hash tables
stepping through hash tables
table lookup techniques
%FINDAUTOS macro
FINDC function
FINDW function
FIPSTATE function
FIRST. processing
BY-group processing and
eliminating duplicate observations
transposing data to arrays
FIRST method
FIRSTOBS= data set option
FLOOR function
FLOWOVER option, INFILE statement
FLYOVER= attribute
FMTSEARCH= system option
FONT catalog
FONT= option
AXIS statement
FOOTNOTE statement
TITLE statement
FONT_FACE= attribute
fonts
building
default selections
FONT catalog and
TrueType
FONT_SIZE= attribute
FONT_STYLE= attribute
FONT_WEIGHT= attribute
FONT_WIDTH= attribute
FOOTNOTE statement
BCOLOR= option
BOLD option
#BYVAL option
#BYVAR option
COLOR= option
FONT= option
HEIGHT= option
ITALIC option
JUSTIFY= option
LINK= option
ODS supported options
PAGEOF formatting sequence
UNDERLINE option
FORCE option
APPEND statement (DATASETS)
SORT procedure
FOREGROUND= attribute
FORMAT catalog entry type
format libraries
about
concatenating format catalogs
format libraries (continued)
saving formats permanently
searching for formats
format modifiers
about
checking date strings
for INPUT statement
FORMAT procedure
CNTLIN= option
CNTLOUT= option
INVALUE statement
LIBRARY= option
PICTURE statement
REGEXPE option
table lookup techniques
VALUE statement
FORMAT statement
in DATA steps
reordering variables on PDV and
SUMMARY procedure
TABULATE procedure
variable information functions and
format translations
about
filtering missing values
handling text with numeric values
mapping overlapping ranges
passing values into function
FORMATC catalog entry type
formats
See also inline formatting
ANYDATE informats and
building from data sets
checking date strings with
conditionally assigning
controlling order with NOTSORTED option
displaying small probability values
multilabel
passing values into
picture
preloaded
saving in catalogs
saving permanently
searching for
table lookup techniques
formulas, storing as data values
fractional values, picture formats
FRAME option, LEGEND statement
FREQ procedure
about
BY variables and
%DOPROCESS macro and
duplicate observations and
graphics and
NLEVELS option
ODS OUTPUT statement
OUTPUT statement
QNUM function and
SPARSE option
TABLE statement
Friendly, Michael
FROM CONNECTION phrase (SQL)
FROM= option, FILENAME statement
FROM statement, SQL procedure
FTEXT= graphics option
migrating text
setting fonts
UNIVARIATE procedure and
FTITLE= graphics option
Function Editor (FCMP)
FUNCTION statement, FCMP procedure
functions
See also specific functions
alternative
ANY family of
collecting setting values through
comparison
concatenation
counting
for age calculations
interacting with macro language
macro
NOT family of
passing values into
powerful and flexible
removing
storing and accessing
underutilized
user-defined
variable information
viewing definitions
fuzzy merges
G
GCHART procedure
Gebhart, Eric
$GENDERU. format
GEOMEAN function
GET operator
%GETDATANAME macro
%GETFUNC macro
%GETGLOBAL macro
GETNAMES option, LIBNAME statement
GETNAMES= statement, IMPORT procedure
GETOPTION function
GFONT procedure
GIF files
GKPI procedure
GLM procedure
%GLOBAL statement
GOPTIONS procedure
GPLOT procedure
%GRABDRIVE macro
%GRABPATHNAME macro function
graphics elements, linking
graphics fonts, building
Graphics Stream File (GSF)
GROUP option, DEFINE statement (REPORT)
GROUPINTERNAL option
CLASS statement (MEANS)
CLASS statement (SUMMARY)
GSF (Graphics Stream File)
GSFMODE= graphics option
GSFNAME= graphics option
GSUBMIT command
GUESSINGROWS= statement, IMPORT procedure
H
hard coding issues
HASH object
about
additional information
defining and loading
determining unique keys
eliminating duplicate observations
many-to-many merges and
simple sorts using
table lookup techniques
hash sign (#)
hash tables
about
creating
key indexing and
referencing hash tables
stepping through
table lookup techniques
updating master data sets
HASHEXP: constructor
Haworth, Lauren
HAXIS= option, PLOT statement (BOXPLOT)
HBOUND function
HBULLET statement, GKPI procedure
HEADER option, LIBNAME statement
HEIGHT= option
AXIS statement
FOOTNOTE statement
SYMBOL statement
TITLE statement
Henderson, Don
HEX. format
HEX16. format
hexadecimal number conversions
hiding macro code
hierarchy of operators
HISTOGRAM statement, UNIVARIATE procedure
about
MIDPOINTS option
OUTHISTOGRAM= option
histograms
linking to reports
UNIVARIATE procedure and
HITER object
about
accessing hash tables
stepping through hash tables
HPOS graphics option
HTEXT= graphics option
HTITLE= graphics option
HTML anchor tags
HTML destination
about
ASIS style attribute and
linking graphics elements
HTML3 destination
HTML option, VBAR statement (GCHART)
HTML4 tagset
HTML_LEGEND option, VBAR statement (GCHART)
Huang, Charlie
Huntley, Scott
hyperlinks
about
creating internal links
linking graphics elements
style overrides and
hyphen (-)
I
I= option, SYMBOL statement
ID statement
PRINT procedure
TRANSPOSE procedure
UNIVARIATE procedure
IDGROUP option, OUTPUT statement
IDXNAME data set option
IDXWHERE data set option
IF statement
CALL SYMPUTX routine comparison
conditionally assigning formats
DLM option and
logical and comparison operators in
MIN and MAX operator and
negative values and
table lookup techniques
IFC function
IFN function
implicit arrays
IMPORT procedure
about
data source statements
DATAROW statement
DBMS= option
GETNAMES statement
GUESSINGROWS= statement
importing CSV files
MIXED= statement
NAMEROW= statement
RANGE= statement
REPLACE option
SCANTEXT statement
SHEET= statement
STARTROW= statement
TEXTSIZE statement
working with named ranges
importing CSV files
IN comparison operator
DATA steps and
in macro language
SQL procedure and
INAGE. informat
%INCLUDE statement
indentations
INDEX function
about
ANY family of functions and
mixed dates example
semicolons and
INDEX statement, DATASETS procedure
about
CREATE option
DELETE option
INDEXC function
indexes
about
BY statement
caveats and considerations
composite
KEY= option, SET statement
simple
table lookup techniques
INDEXW function
indicator bars and dials
INDSNAME= option, SET statement
inequalities, compound
_INFILE_ automatic variable
INFILE statement
DELIMITER option
DLM= option
DLMOPT option
DLMSTR= option
DSD option
FLOWOVER option
LENGTH= option
MISSOVER option
TRUNCOVER option
INFMT catalog entry type
INFMTC catalog entry type
INFORMAT statement
in DATA steps
reordering variables on PDV and
information sources (macro)
about
accessing metadata for data sets
DICTIONARY tables
SASHELP views
informats
saving in catalogs
user-defined
initialization options
-INITSTMT initialization option
inline formatting
changing text attributes
controlling indentations
controlling line breaks
controlling spacing
dagger symbol
escape character sequences and
page X of Y
subscripts
superscripts
inline style modifiers
INPUT function
about
checking date strings with formats
datetime values and
key indexing and
%SYSFUNC function and
table lookup techniques
variable conversions
INPUT statement
about
additional information
controlling delimited input
format modifiers for
reading variable-length records
INPUTC function
INPUTN function
additional information
automatic dates and
execution considerations
%SYSFUNC function and
INSERT option, CONFIG.CFG file
Insert String dialog box
INSET statement, UNIVARIATE procedure
INSIDE option, LEGEND statement
INTCK function
about
additional information
alignment options
automatic dates
shift operators
START function and
internal links, creating
INTERPOL= option, SYMBOL statement
INTERSECT operator (SQL)
interval multipliers
INTNX function
about
additional information
alignment options
automatic dates
interval multipliers
shift operators
START function and
variable conversion example
INTO : clause, SELECT statement (SQL)
INVALUE statement, FORMAT procedure
creating formats
creating informats
traffic lighting and
IS MISSING operator
IS NULL operator
ITALIC option
FOOTNOTE statement
TITLE statement
J
J= option
See JUSTIFY= option
Java object
JAVAIMG device
joins and merges
about
BY variable attribute consistency and
fuzzy
in DATA steps
repeating BY variables
table lookup techniques
variables in common
Jordan, Mark
JUST= style attribute
JUSTIFY= option
about
FOOTNOTE statement
TITLE statement
K
KEDYDEF command
KEEP= data set option
about
duplicate observations and
KEEP statement and
reordering variables on PDV
SORT procedure and
variable values and
KEEP statement
KEEP= data set option and
reordering variables on PDV
shorthand variable naming and
key indexing (direct addressing)
KEY= option, SET statement–223
Key Performance Indicator (KPI)
Keyboard Macros dialog box
KEYDEF command
KEYLABEL statement, TABULATE procedure
KEYLEVEL= option, CLASS statement (UNIVARIATE)
KEYS window
KEYWORD statement, TABULATE procedure
KILL option, DATASETS procedure
King, John
KMF files
KPI (Key Performance Indicator)
L
LABEL= option
AXIS statement
LEGEND statement
TABLE statement (TABULATE)
LAG function
Langston, Rick
LARGEST function
LAST. processing
BY-group processing and
eliminating duplicate observations
transposing data to arrays
%LASTMY macro function
LASTPAGE formatting sequence
LBOUND function
leading blanks
LEFT function
%LEFT macro function
autocall libraries and
quotation marks and
removing characters from text strings
LEGEND= option, LEGEND statement
LEGEND statement
about
ACROSS option
FRAME option
generating box plots
INSIDE option
LABEL= option
LEGEND= option
NOLEGEND option
OUTSIDE option
SHAPE= option
VALUE= option
$LENC. format
length, numeric variables
LENGTH function
%LENGTH macro function
LENGTH= option, INFILE statement
LENGTH statement
about
in joins and merges
reordering variables on PDV
RETAIN statement and
setting variable attributes
usage example
LENN. format
LET operator
LEVELS option, OUTPUT statement
LIBNAME function
LIBNAME statement
CLEAR option
data access engines and
GETNAMES option
HEADER option
MIXED option
PASSWORD option
SCAN_TEXT option
USER option
VER option
working with named ranges
XMLFILEREF= option
LIBNAME window
LIBRARY= option, FORMAT procedure
LIFO stacks
LIKE operator
line breaks
LINE= option, SYMBOL statement
LINE statement, REPORT procedure
aliases in
changing text attributes
conditionally executing
STYLE= option
superscripts and
LINK= option
FOOTNOTE statement
TITLE statement
LIST style input
LISTING destination
format considerations
HTML anchor tags and
linking graphic elements and
RTS= option and
STYLE= option and
%LOCAL statement
LOG window
Logger object
logical operators in assignment statements
logo symbol
look-ahead technique
additional information
double SET statement and
MERGE statement and
SET statement and
look-back technique
additional information
LAG function and
SET statement and
LRECL= option, FILE statement
M
~m sequence code
macro abbreviations for Enhanced Editor
macro functions
See also specific macro functions
macro information sources
about
accessing metadata for data sets
DICTIONARY tables
SASHELP views
macro language
avoiding macro variable collisions
building macro variables
#BYVAL option and
#BYVAR option and
comments and
controlling exception reporting with macros
debugging considerations
executing specific versions
functions interacting with
generalized programs and
IN operator
macro information sources
macro libraries and
metadata-driven programs and
MFILE system option and
missing values and
quotation marks and
replacing hard coding with
security and protection considerations
writing macro functions
macro libraries
%MACRO statement
MINDELIMITER= system option and
processing overview
SECURE option
SOURCE option
/STORE option
macro variables
avoiding collisions
building
building list of
missing values and
quotation marks and
resetting graphics options
MAJOR= option, AXIS statement
%MAKELIST macro
%MAKETEMPWORK macro
%MAKEXLS macro
mapping overlapping ranges
MARKUP destination
about
EXCELXP tagset
linking reports from
MATCH_ALL option, ODS OUTPUT statement
MAUTOLOCDISPLAY system option
MAUTOSOURCE system option
MAX function
MAX operator
MAX statistic
MAXID option, OUTPUT statement
maximum values
finding
MAX function
MAX operator
MAXWT_B. format
MAXWT_F. format
MDYAMPM. informat
MEAN= option, OUTPUT statement
MEANS procedure
about
CHARTYPE option
CLASS statement
CLASSDATA= option
COMPLETETYPES option–370
EXCLUSIVE option
generalizing programs example
identifying extremes
naming output variables
NWAY option
ORDER= option
OUTPUT statement
preloaded formats and
THREADS system option and
transposing data and
_TYPE_ automatic variable and
TYPES statement
VAR statement
WAYS statement
MEMTYPE= option, DATASETS procedure
%MEND statement
MERGE statement
double SET statement and
in joins and merges
look-ahead technique and
MERGENOBY= system option and
repeating BY variables and
table lookup techniques
MERGENOBY= system option
merges and joins
See joins and merges
metadata
about
accessing for data sets
controlling data validations
macro language and
processing across data sets
sort considerations
sources of information for
methods
about
accessing within objects
dot notation and
return codes
MFILE system option
MI procedure
MIDPOINTS option, HISTOGRAM statement (UNIVARIATE)
MIN function
MIN operator
MIN statistic
MINDELIMITER= system option
MINID option, OUTPUT statement
minimum values
finding
MIN function
MIN operator
MINOPERATOR system option
MINOR= option, AXIS statement
MISSDATE. format
MISSING function
about
checking for missing date values
negation of
MISSING method
MISSING option
CLASS statement (MEANS)
CLASS statement (SUMMARY)
DEFINE statement (REPORT)
TABLE statement (FREQ)
MISSING routine
See CALL MISSING routine
MISSING statement
MISSING system option
missing values
additional information
CALL MISSING routine
checking for missing dates
classification variables
CMISS function and
filtering
imputing
macro variables and
MISSING function and–100
MISSING system option
NMISS function and
numeric
replacing with zero
special
SUM function and
MISSOVER option, INFILE statement
MISSTEXT= option, TABLE statement (TABULATE)
MIXED option, LIBNAME statement
MIXED procedure
MIXED= statement, IMPORT procedure
MLF (multilabel) formats
MLF option
CLASS statement (MEANS)
CLASS statement (SUMMARY)
MLF option, CLASS statement (TABULATE)
MLOGIC system option
MLOGICNEST system option
MMDDY. format
MOD function
MODIFY statement
DATASETS procedure
hash tables updating master data sets
MODULEC function
MODULEN function
MONNAME. format
MONTH function
MONTHABB. format
MONTHNAME. format
moving average calculation–380
MPRINT system option
MPRINTNEST system option
MSGLEVEL= system option
MSOFFICE2k destination
MSTORED system option
MULT= option, PICTURE statement (FORMAT)
multilabel (MLF) formats
MULTILABEL option, VALUE statement (FORMAT)
MYDATT. format
%MYMEANS macro
MZERO. format
N
_N_ automatic variable
%n directive
N= option, OUTPUT statement
N statistic
NAME= option, HBULLET statement (GKPI)
named ranges
NAMEROW= statement, IMPORT procedure
naming
compound variable names
output variables
report items in compute block
shorthand variables
negation, double
negative values, determining
Nelson, Rob
nesting
dates
formats
macros
tables
_NEW_ keyword
NEW LIBRARY window
NEXT method
%NEXTDOG macro function
NLEVELS option, FREQ procedure
NMISS function
-NOAWSMENU initialization option
NOBS= option, SET statement
NOBYLINE system option
NODUPKEY option, SORT procedure
eliminating duplicates example
filling sparse data example
joins and merges example
key indexing and
NODUPREC option and
simple sort example
NODUPLICATES option, SORT procedure
NODUPREC option, SORT procedure
NOEQUALS option, SORT procedure
NOFMTERR system option
NOLEGEND option, LEGEND statement
NOLIST option, DATASETS procedure
NOMAUTOLOCDISPLAY system option
NOMCOMPILE system option
NOMINOPERATOR system option
NOMLOGIC system option
NOMPRINT system option
NOMREPLACE system option
NOOBS option, PRINT procedure
NOPRINT option, DEFINE statement (REPORT)
NOPRINT option, TABLE statement (FREQ)
normalizing data
NOSORTEQUALS system option
NOSYMBOLGEN system option
NOT operator
NOTALPHA function
NOTCHES option, PLOT statement (BOXPLOT)
NOTDIGIT function
notes, customizing
NOTHREADS system option
NOTSORTED option, VALUE statement (FORMAT)
NOTXDIGIT function
-NOWORKINIT initialization option
-NOWORKTERM initialization option
NOXSYNC system option
NOXWAIT system option
NOZERO option, DEFINE statement (REPORT)
%NRSTR macro function
numbered range variable lists
numeric expressions, evaluating
NUMERIC list modifier
numeric missing values
_NUMERIC_ variable name list
numeric variables
FIRST. and LAST. processing
NMISS function and
setting length of
shorthand naming
variable conversions and
NWAY option
MEANS procedure
SUMMARY procedure
O
objects
accessing methods within
creating and naming
determining names of
dot notation and
labels and ODS OUTPUT statement
OBS= data set option
%OBSCNT macro
observations
additional information
building FIFO stacks
BY-group processing
eliminating duplicate
identifying extremes
LAG function and
look-ahead and MERGE statement
look-ahead and SET statement
look-back and SET statement
processing across
SUM statement and
transposing to arrays
O'Conner, Dan
OCTAL. format
ODS (Output Delivery System)
about
additional information
creating hyperlinks
escape character sequences and
graphics options and settings
inline formatting and
reading and writing to XML
STYLE= option and
title and footnote options
traffic lighting
useful tidbits
writing delimited files
writing reports to Excel
ODS CSV statement
ODS ESCAPECHAR option
ODS GRAPHICS statement
ODS LAYOUT statement
ODS LISTING statement
ODS MARKUP statement
EXCELXP tagset and
FILE= option
STYLE= option
ODS NOUSEGOPT statement
ODS OUTPUT statement
creating data sets
data set options and
MATCH_ALL option
object labels and
PERSIST= option
ODS PDF statement
ODS PROCLABEL statement
ODS REGION statement
ODS RESULTS statement
ODS RTF statement
ODS TRACE statement
ODS USEGOPT statement
OPEN= option, SET statement
operator hierarchy
OPTIONS option
EXCELXP tagset
ODS CSV statement
OPTIONS procedure
OPTLOAD procedure
OPTSAVE procedure
ORDER BY statement, SQL procedure
ORDER= option
about
AXIS statement
CLASS statement
CLASS statement (MEANS)
CLASS statement (SUMMARY)
DEFINE statement (REPORT)
MEANS procedure
TABULATE procedure
TITLE statement
ORDERED: constructor
ORDINAL function
OS commands
additional information
data step execution
global execution
sub-session execution comments
OUT= option
COMPARE procedure
CONTENTS procedure
OUTPUT statement (SUMMARY)
SORT procedure
TRANSPOSE procedure
OUTBASE option, COMPARE procedure
OUTCOMP option, COMPARE procedure
OUTFILE= option, EXPORT procedure
OUTHISTOGRAM= option, HISTOGRAM statement (UNIVARIATE)
OUTLIB= option, FCMP procedure
OUTNOEQUAL option, COMPARE procedure
Output Delivery System
See ODS (Output Delivery System)
OUTPUT destination
about
creating data sets
determining object names
MATCH_ALL option
NLEVELS option and
PERSIST= option
OUTPUT method
breaking up data sets
hash tables referencing hash tables
simple sort example
OUTPUT statement
See also ODS OUTPUT statement
AUTOLABEL option
AUTONAME option
conditionally executing
ELSE statement and
FREQ procedure
IDGROUP option
in DO loops
LEVELS option
MAXID option
MEAN= option
MEANS procedure
MINID option
N= option
naming output variables
PCTLPRE= option
PCTLPTS= option
statistic specification
SUMMARY procedure
UNIVARIATE procedure
WAYS option
output variables, naming
OUTSIDE option, LEGEND statement
overlapping ranges, mapping
P
PAGEBY statement, PRINT procedure
PAGEOF formatting sequence
parentheses ()
pass-through (SQL)
passing values as format labels
PASSWORD option, LIBNAME statement
password protection
PATHNAME function
PATTERN statement
PCTLPRE= option, OUTPUT statement (UNIVARIATE)
PCTLPTS= option, OUTPUT statement (UNIVARIATE)
PCTZERO. format
PDF destination
percent sign (%)
percentages, calculating
percentile statistics
period (.)
Perl regular expressions
PERSIST= option, ODS OUTPUT statement
physical location information
picture formats
about
additional information
date directives and
display granularity and
fractional values and
preceding text and
truncating
PICTURE statement, FORMAT procedure
about
DATATYPE= option
fractional values and
MULT= option
PREFIX= option
ROUND option
PLOT statement
BOXPLOT procedure
REG procedure
plot symbols
See also SYMBOL statement
PLOTS= option, TABLE statement (FREQ)
PMENU procedure
PNG files
POINT= option, SET statement
about
DO loops and
look-ahead technique and
POINTLABEL option, SYMBOL statement
pop-up menus, adding tools to
positive values, determining
pound sign (#)
POUNDS. format
PREFIX= option
PICTURE statement (FORMAT)
TRANSPOSE procedure
prefix variable lists
preloaded formats
about
MEANS procedure
modifying report contents with
REPORT procedure and
SUMMARY procedure
TABULATE procedure and
PRELOADFMT option
CLASS statement (MEANS)
CLASS statement (SUMMARY)
CLASS statement (TABULATE)
%PRIMARY statement
PRINT procedure
about
BY statement
filtering missing values
generating table of contents
ID statement
NOOBS option
PAGEBY statement
reordering variables on PDV
STYLE= option
style overrides and
TITLE statement
traffic lighting and
VAR statement
WHERE statement
%PRINTALL macro
%PRINTIT macro
PRINTMISS option, TABLE statement (TABULATE)
PRINTTO procedure
probability plots
probability values, displaying
PROBIT procedure
PROBPLOT statement, UNIVARIATE procedure
process automation
process control charts, generating
%PROCESS macro
PRXCHANGE function
PTCN option, TABLE statement (TABULATE)
PTCSUM option, TABLE statement (TABULATE)
pull-down menus, adding tools to
%PURGEWORK macro
PUT function
about
CALL SYMPUT routine and
execution considerations
in joins and merges
%SYSFUNC function and
table lookup techniques
variable conversions
PUT statement
conditional
customizing text written to logs
generating e-mails
inserting separators manually
variable conversions
%PUT statement
PUTC function
PUTLOG statement
PUTN function
automatic dates and
execution considerations
%SYSFUNC function and
PVALUE. format
PW data set option
PWENCODE procedure
PWREQ data set option
Q
%QLEFT macro function
QNUM function
QQPLOT statement, UNIVARIATE procedure
%QSCAN macro function
%QSYSFUNC macro function
QTR function
%QTRIM macro function
quantile plots (QQplots)
QUERY command
question mark (?)
as format modifier
CONTAINS operator and
quotation marks (")
about
DSD option and
macro language and
%QUOTE macro function
R
%RAND_WO macro
RANGE. format
RANGE= statement, IMPORT procedure
RANUNI function
READ data set option
reading data
in variable-length records
look-ahead technique
look-back technique
mixed dates and
to XML
with data access engines
REG procedure
NOLEGEND option and
PLOT statement
SAS/GRAPH support
REGEXPE option, FORMAT procedure
regular expressions (Perl)
$REGX. format
RENAME= data set option
about
appending data sets
RENAME statement and
table lookup techniques
RENAME function
RENAME statement
renaming
catalogs
data sets
reordering
case-sensitive
numeric strings
variables on PDV
REPEMPTY data set option
REPLACE data set option
REPLACE method
REPLACE option
EXPORT procedure
IMPORT procedure
Repole, Warren
report items
REPORT procedure
about
aligning decimal points
CALL DEFINE routine
COLUMN statement
COMPLETECOLS option
COMPLETEROWS option
compute block and
consolidating columns
CONTENTS= option
DEFINE statement
EXCLUSIVE option
indicator bars and dials
LINE statement
nested dates
preloaded formats and
style overrides and
TABULATE procedure and
THREADS system option and
traffic lighting and
reports
modifying contents with preloaded formats
writing to Excel tables
RESET= graphics option
RETAIN statement
reordering variables on PDV and
SUM statement and
table lookup techniques
return codes (methods)
RETURN statement, FCMP procedure
Rhodes, Dianne
Rhodes, Mike
rolling average calculation–380
Rosenbloom, Mary
ROTATE= option, AXIS statement
ROUND function
ROUND option, PICTURE statement (FORMAT)
RTF destination
issuing raw RTF specific commands
LASTPAGE formatting sequence
linking reports from
PAGEOF formatting sequence
THISPAGE formatting sequence
RTF file format
-RTFCOLOR initialization option
RTS= option, TABLE statement (TABULATE)
RUN statement
RUN_MACRO function
S
SAME operator
_SAME_ operator
SAS/ACCESS engine
SAS/AF application
SAS/GRAPH application
about–314
annotate facility
building indicator bars and dials
changing plot symbols with SYMBOL statement
controlling axes and legends
FREQ procedure and
generating box plots
graphics options and settings
specialty techniques and procedures
splitting text lines
title/footnote options
UNIVARIATE procedure and
SAS/QC application–317
SAS/STAT application
SASAUTOS= system option
autocall libraries and
changing SASAUTOS location
saving system options and
SAS_EXECFILENAME environmental variable
SAS_EXECFILEPATH environmental variable
SASHELP views
additional information
attributes of data sets and
list of
recovering physical location information
SASHELP.VALLOPT view
SASHELP.VCATALG view
SASHELP.VCFORMAT view
SASHELP.VCOLUMNS view
SASHELP.VDCTNRY view
SASHELP.VENGINE view
SASHELP.VEXTFL view
SASHELP.VFORMAT view
SASHELP.VFUNC view
SASHELP.VGOPT view
SASHELP.VINDEX view
SASHELP.VLIBNAM view
SASHELP.VMACRO view
SASHELP.VMEMBER view
SASHELP.VOPTIONS view
SASHELP.VSACCES view
SASHELP.VSCATLG view
SASHELP.VSLIB view
SASHELP.VSTABLE view
SASHELP.VSTABVW view
SASHELP.VSTYLE view
SASHELP.VSVIEW view
SASHELP.VTABLE view
SASHELP.VTITLE view
SASHELP.VVIEW view
-SASINITIALFOLDER initialization option
SASMSTORE= system option
!SASROOT directory
SASV9.CFG file
SAVE command
%SAVEGLOBAL macro
%SCALEPOS macro
SCAN function
%SCAN macro function
SCAN_TEXT option, LIBNAME statement
SCANTEXT statement, IMPORT procedure
Schreier, Howard
search order for macro libraries
searching for formats
Secosky, Jasson
%SECRETSQL macro
SECURE option, %MACRO statement
%SECURECODE macro
security considerations
macro language and
password protection
SELECT statement
DATA steps
SQL procedure
semicolon (;)
%DO blocks and
INDEX function and
troubleshooting missing
sending e-mails
-SET keyword
SET statement
about
breaking up data sets example
double
END= option
HASH objects and
INDSNAME= option
KEEP= data set option and
key index lookups
KEY= option
look-ahead technique and
look-back technique and
NOBS= option
OPEN= option
POINT= option
reordering variables on PDV and
simple sort example
UNIQUE option
SETINIT procedure
SHAPE= option, LEGEND statement
SHEET= statement
EXPORT procedure
IMPORT procedure
SHEET_INTERVAL option, EXCELXP tagset
sheets
See Excel sheets and workbooks
SHEWART procedure
shift operators
shorthand variable lists
SHOWDECR. format
%SHOWSTYLES macro
SHOWVAL. format
SIGN function
slash (/)
%SLIDER macro
SMALLEST function
SORT procedure
BY statement
data set options and
DESCENDING option
duplicate observations and
DUPOUT= option
EQUALS option
FORCE option
metadata sort information
NODUPKEY option
NODUPLICATES option
NODUPREC option
NOEQUALS option
OUT= option
simple sort example
sort order considerations
SORTSEQ option
table lookup techniques
TAGSORT option
THREADS system option and
SORTEDBY data set option
SORTEQUALS system option
SORTSEQ option, SORT procedure
SOUNDEX function
sounds like operator
SOURCE catalog entry
SOURCE option, %MACRO statement
spacing
sparse data
about
CLASSDATA= option and
COMPLETETYPES option and
double transpose
known template of rows
preloaded formats and
SPARSE option and
SPARSE option, TABLE statement (FREQ)
SPEDIST function
-SPLASHLOC initialization option
SQL procedure
CASE statement
CONNECT statement
CREATE INDEX statement
creating indexes
DESCRIBE statement
DICTIONARY tables and
DISCONNECT statement
DROP TABLE statement
duplicate observations and
FROM statement
IN comparison operator and
join operations
ORDER BY statement
pass-throughs and
SELECT statement
sort considerations
THREADS system option and
WHERE clause
START function
START option, ODS LAYOUT statement
STARTROW= statement, IMPORT procedure
STDIZE procedure
STOP statement
/STORE option, %MACRO statement
stored compiled macro libraries
storing
formulas as data values
functions
%STR macro function
strings
See text strings
STRIP function
STUDYDT. format
style attributes
about
CALL DEFINE routine and
changing for text
PRINT procedure and
style modifiers
STYLE= option
CLASS statement (TABULATE)
CLASSLEV statement (TABULATE)
creating links
LINE statement (REPORT)
ODS MARKUP statement
PRINT procedure
TABLE statement (TABULATE)
VAR statement (PRINT)
VAR statement (TABULATE)
SUBJECT= option, FILENAME statement
SUBROUTINE statement, FCMP procedure
subscripts
subsets
CLASSDATA= option and
EXCLUSIVE option and
LEVELS option and
percentiles creating
TYPES statement and
subsets (continued)
WAYS option and
WAYS statement and
subsetting IF statements
SUBSTR function
about
checking date strings example
conditionally executing
manipulating dates
variable information functions and
SUM function
SUM statement
SUMMARY procedure
about
CHARTYPE option
CLASS statement
CLASSDATA= option
COMPLETETYPES option
EXCLUSIVE option
FORMAT statement
identifying extremes
naming output variables
NWAY option
OUTPUT statement
preloaded formats and
shorthand variable naming and
THREADS system option and
transposing date and
_TYPE_ automatic variable and
TYPES statement
VAR statement
WAYS statement
sunflower symbol
%SUPERQ macro function
superscripts
SYMBOL statement
BWIDTH= option
changing plot symbols with
COLOR= option
generating box plots
GPLOT procedure and
HEIGHT= option
I= option
INTERPOL= option
LINE= option
POINTLABEL option
probability plots and
quantile plots and
UNIVARIATE procedure and
VALUE= option
WIDTH= option
SYMBOLGEN system option
SYMBOLLEGEND option, PLOT statement (BOXPLOT)
%SYMEXIST macro function
SYMGET function
$SYMP. format
SYMPUT routine
SYMPUTX routine
See CALL SYMPUTX routine
%SYSCALL statement
%SYSEXEC macro function
%SYSFUNC macro function
about
accessing metadata of data sets
COUNTW function and
FILENAME function and
IFC function and
IFN function and
INPUT function and
INPUTN function and
INTNX function and
PUT function and
PUTN function and
quotation marks and
%SYSGET macro function
-SYSIN initialization option
SYSIN system option
%SYSMACDELETE statement
SYSMSG function
&SYSPARM automatic macro variable
-SYSPARM initialization option
%SYSRC macro function
SYSTASK COMMAND statement
SYSTEM function
system options
See also specific options
about
additional information
data processing options
initialization options
macro language and
saving
T
table lookup techniques
about
array processing
BY statement
direct addressing
double SET statements
format-driven
hash tables
IF statements
indexes and
joins and merges
key indexing
table of contents, generating
TABLE statement, FREQ procedure
about
CHISQ option
classification variables and
MISSING option
NOPRINT option
PLOTS= option
SPARSE option
TABLE statement, TABULATE procedure
about
BOX= option
combination of elements
concatenated elements
LABEL= option
MISSTEXT= option
nested elements
PCTN option
PRINTMISS option
PTCSUM option
RTS= option
singular elements
STYLE= option
tables
building from CSV files
concatenated
dimension components of
hash
nested
writing reports to
TABULATE procedure
about
additional information
calculating percentages
CLASS statement
CLASSDATA= option
CLASSLEV statement
EXCLUSIVE option
FORMAT statement
KEYLABEL statement
KEYWORD statement
ORDER= option
preloaded formats and
REPORT procedure and
style overrides and
TABLE statement
THREADS system option and
traffic lighting and
VAR statement
TAGSORT option, SORT procedure
TARGET= option, HBULLET statement (GKPI)
TARGETDEVICE= graphics option
temporary arrays
_TEMPORARY_ keyword
temporary variables
FIRST. and LAST. processing
indexes and
-TERMSTMT initialization option
TEXT= option, ODS PDF statement
text strings
aligning across rows
changing attributes of
checking date strings with formats
handling with numeric values
marking blocks of in Enhanced Editor
migrating
removing characters from
reordering numeric
splitting lines of
text substitution (term)
TEXTSIZE statement, IMPORT procedure
THISPAGE formatting sequence
THREADS system option
tilde (~)
as escape character
as format modifier
TIME function
time values
TITLE statement
BCOLOR= option
BOLD option
#BYLINE option
#BYVAL option
#BYVAR option
changing text attributes
COLOR= option
FONT= option
font selections in
HEIGHT= option
ITALIC option
JUSTIFY= option
%LASTMY function and
LINK= option
ODS supported options
ORDER= option
PAGEOF formatting sequence
raw RTF commands and
SAS/GRAPH support
UNDERLINE option
TITLE window
TO= option, FILENAME statement
TONS. format
tools
adding to application tool bar
adding to KEYS window
adding to pull-down and pop-up menus
TOXLS libref
Trabachneck, Art
traffic lighting
about
PRINT procedure and
REPORT procedure and
TABULATE procedure and
user-defined format
trailing @
trailing blanks
TRAILSGN informat
TRANSLATE function
TRANSPOSE procedure
about
BY statement
DATA= option
double transpose
ID statement
OUT= option
PREFIX= option
VAR statement
transposing data
about
double transpose
in DATA steps
to arrays
TRANSPOSE procedure and
TRANSTRN function
TRANWRD function
TRIM function
%TRIM macro function
TRIMN function
TrueType fonts
truncating picture formats
TRUNCOVER option, INFILE statement
~2n sequence code
_TYPE_ automatic variable
about
CHARTYPE option and
TYPES statement and
WAYS statement and
TYPES statement
MEANS procedure
SUMMARY procedure
U
UNC (Universal Naming Convention)
UNDERLINE option
FOOTNOTE statement
TITLE statement
underscore (_)
UNION operator (SQL)
UNIQUE option, SET statement
UNIVARIATE procedure
about
ANNO= option
BY statement
CLASS statement
FTEXT= graphics option and
generating presentation-quality plots
HISTOGRAM statement
ID statement
identifying extremes
INSET statement
ODS TRACE statement and
UNIVARIATE procedure (continued)
OUTPUT destination and
OUTPUT statement
probability plots and
PROBPLOT statement
QQPLOT statement
quantile plots and
SAS/GRAPH support and
Universal Naming Convention (UNC)
%UNQUOTE macro function
%UPCASE macro function
UPDATE statement
URL= style attribute
USER option, LIBNAME statement
V
validating data
about
checking date strings
in metadata-driven programs
VALIDVARNAME= system option
VALUE= option
AXIS statement
LEGEND statement
SYMBOL statement
VALUE statement, FORMAT procedure
about
DEFAULT= option
MULTILABEL option
NOTSORTED option
traffic lighting and
VAR command
VAR statement
MEANS procedure
PRINT procedure
shorthand variable lists and
SUMMARY procedure
TABULATE procedure
TRANSPOSE procedure
variable information functions
variable-length records, reading
variable names, shorthand lists
variables
See also numeric variables
character
classification
converting
environmental
macro
naming in compute block
output
shorthand
temporary
VARNAME function
VARNUM option, CONTENTS procedure
VARRAY function
VARRAYX function
VARTYPE function
$VARYING15. informat
$VARYING informat
VAXIS= option, PLOT statement (BOXPLOT)
VBAR statement, GCHART procedure
VER option, LIBNAME statement
-VERBOSE initialization option
%VERIFY macro function
versions, macro
VFORMAT function
VFORMATD function
VFORMATDX function
VFORMATN function
VFORMATNX function
VFORMATW function
VFORMATWX function
VFORMATX function
View Columns tool
VIEWTABLE command
VIEWTABLE window (Display Manager)
about
closing
SASHELP views and
showing column names in
VINARRAY function
VINARRAYX function
VINFORMAT function
VINFORMATD function
VINFORMATDX function
VINFORMATN function
VINFORMATNX function
VINFORMATW function
VINFORMATWX function
VINFORMATX function
VLABEL function
VLABELX function
VLENGTH function
VLENGTHX function
VNAME function
about
additional information
usage example
VNAMEX function
VNEXT function
VPOS graphics option
VT command
VTYPE function
VTYPEX function
VVALUE function
VVALUEX function
W
~w sequence code
WAITFOR statement
warnings, customizing
WAYS option, OUTPUT statement
WAYS statement
MEANS procedure
SUMMARY procedure
WEDIT command
WHERE= data set option
colon operator and
creating WHERE clause
in DATA steps
SORT procedure and
WHERE statement
about
BY-group processing and
checking date strings
colon comparison operator modifier in
compound inequalities and
creating
data set options and
MIN and MAX operators
negative values and
operators supported
PRINT procedure
reordering variables on PDV and
WHICHN function
Whitlock, Ian,
WIDTH= option, SYMBOL statement
Windows fonts
WITHDEC. format
WNetGetConnectionA routine
%WORDCOUNT macro function
WORDDATE18. format
workbooks
See Excel sheets and workbooks
WORK.FORMATS catalog
WORK.SASMACR catalog
WRITE data set option
writing data
in delimited files
in e-mails
reports to Excel tables
to XML
with data access engines
writing macro functions
WRTFSAVE option, DM statement
X
X statement
Xie, Liang
XMIN system option
XML (Extensible Markup Language)
EXCELXP tagset and
MARKUP destination
reading and writing to
XML engine
XML destination
XML engine
XMLFILEREF= option, LIBNAME statement
~xn sequence code
XPIXELS graphics option
XSYNC system option
XWAIT system option
~xz sequence code
Y
YEAR function
YESNO. format
YMDTIME. format
YPIXELS graphics option
YRDIF function
YYQ. format
Z
.z missing value
Zdeb, Mike
Zender, Cynthia
Symbols and Numbers
* (asterisk)
@ (at sign)
- (hyphen)
/ (slash)
" (quotation marks)
about
DSD option and
macro language and
# (pound sign)
$ (dollar sign)
% (percent sign)
& (ampersand)
& format modifier
() (parentheses)
, (comma)
,,/ (comma-slash)
. (period)
._ missing value
: (colon)
as comparison modifier
as format modifier
in constructors
shorthand variable naming and
; (semicolon)
%DO blocks and
INDEX function and
troubleshooting missing
=* operator
> symbol
? (question mark)
as format modifier
CONTAINS operator and
?? format modifier
about
checking date string example
INPUT function and
SUBSTR function and
_ (underscore)
|| (concatenation operator)
~ (tilde)
as escape character
as format modifier
~2n sequence code