Toby,
Ouch! You must not have seen:
http://support.sas.com/onlinedoc/913/docMainpage.jsp
The SAS System is probably much, much wider and deeper than other
software systems you have experienced and, given the sheer volume of
documentation material, I think SAS does an excellent job of making
such documentation accessible. You can peruse functions and call
routines by category if you wish:
Functions and CALL Routines
Functions and CALL Routines by Category
Categories and Descriptions of Functions and CALL Routines Category
Functions and CALL Routines Description
Array DIM Function
Returns the number of elements in an array
HBOUND Function
Returns the upper bound of an array
LBOUND Function
Returns the lower bound of an array
Bitwise Logical Operations BAND Function
Returns the bitwise logical AND of two arguments
BLSHIFT Function
Returns the bitwise logical left shift of two arguments
BNOT Function
Returns the bitwise logical NOT of an argument
BOR Function
Returns the bitwise logical OR of two arguments
BRSHIFT Function
Returns the bitwise logical right shift of two arguments
BXOR Function
Returns the bitwise logical EXCLUSIVE OR of two arguments
Character String Matching CALL PRXCHANGE Routine
Performs a pattern-matching replacement
CALL PRXDEBUG Routine
Enables Perl regular expressions in a DATA step to send debug output
to the SAS log
CALL PRXFREE Routine
Frees unneeded memory that was allocated for a Perl regular expression
CALL PRXNEXT Routine
Returns the position and length of a substring that matches a pattern
and iterates over multiple matches within one string
CALL PRXPOSN Routine
Returns the start position and length for a capture buffer
CALL PRXSUBSTR Routine
Returns the position and length of a substring that matches a pattern
CALL RXCHANGE Routine
Changes one or more substrings that match a pattern
CALL RXFREE Routine
Frees memory allocated by other regular expression (RX) functions and
CALL routines
CALL RXSUBSTR Routine
Finds the position, length, and score of a substring that matches a pattern
PRXCHANGE Function
Performs a pattern-matching replacement
PRXMATCH Function
Searches for a pattern match and returns the position at which the
pattern is found
PRXPAREN Function
Returns the last bracket match for which there is a match in a pattern
PRXPARSE Function
Compiles a Perl regular expression (PRX) that can be used for pattern
matching of a character value
PRXPOSN Function
Returns the value for a capture buffer
RXMATCH Function
Finds the beginning of a substring that matches a pattern
RXPARSE Function
Parses a pattern
Character ANYALNUM Function
Searches a character string for an alphanumeric character and returns
the first position at which it is found
ANYALPHA Function
Searches a character string for an alphabetic character and returns
the first position at which it is found
ANYCNTRL Function
Searches a character string for a control character and returns the
first position at which it is found
ANYDIGIT Function
Searches a character string for a digit and returns the first
position at which it is found
ANYFIRST Function
Searches a character string for a character that is valid as the
first character in a SAS variable name under VALIDVARNAME=V7, and
returns the first position at which that character is found
ANYGRAPH Function
Searches a character string for a graphical character and returns the
first position at which it is found
ANYLOWER Function
Searches a character string for a lowercase letter and returns the
first position at which it is found
ANYNAME Function
Searches a character string for a character that is valid in a SAS
variable name under VALIDVARNAME=V7, and returns the first position at
which that character is found
ANYPRINT Function
Searches a character string for a printable character and returns the
first position at which it is found
ANYPUNCT Function
Searches a character string for a punctuation character and returns
the first position at which it is found
ANYSPACE Function
Searches a character string for a white-space character (blank,
horizontal and vertical tab, carriage return, line feed, form feed)
and returns the first position at which it is found
ANYUPPER Function
Searches a character string for an uppercase letter and returns the
first position at which it is found
ANYXDIGIT Function
Searches a character string for a hexadecimal character that
represents a digit and returns the first position at which that
character is found
BYTE Function
Returns one character in the ASCII or the EBCDIC collating sequence
CALL CATS Routine
Concatenates character strings and removes leading and trailing blanks
CALL CATT Routine
Concatenates character strings and removes trailing blanks
CALL CATX Routine
Concatenates character strings, removes leading and trailing blanks,
and inserts separators
CALL COMPCOST Routine
Sets the costs of operations for later use by the COMPGED function
CALL MISSING Routine
Assigns a missing value to the specified character or numeric variables.
CALL SCAN Routine
Returns the position and length of a given word from a character expression
CALL SCANQ Routine
Returns the position and length of a given word from a character
expression, and ignores delimiters that are enclosed in quotation
marks
CAT Function
Concatenates character strings without removing leading or trailing blanks
CATS Function
Concatenates character strings and removes leading and trailing blanks
CATT Function
Concatenates character strings and removes trailing blanks
CATX Function
Concatenates character strings, removes leading and trailing blanks,
and inserts separators
CHOOSEC Function
Returns a character value that represents the results of choosing
from a list of arguments
CHOOSEN Function
Returns a numeric value that represents the results of choosing from
a list of arguments
COALESCEC Function
Returns the first non-missing value from a list of character arguments.
COLLATE Function
Returns an ASCII or EBCDIC collating sequence character string
COMPARE Function
Returns the position of the leftmost character by which two strings
differ, or returns 0 if there is no difference
COMPBL Function
Removes multiple blanks from a character string
COMPGED Function
Compares two strings by computing the generalized edit distance
COMPLEV Function
Compares two strings by computing the Levenshtein edit distance
COMPRESS Function
Removes specific characters from a character string
COUNT Function
Counts the number of times that a specific substring of characters
appears within a character string that you specify
COUNTC Function
Counts the number of specific characters that either appear or do not
appear within a character string that you specify
DEQUOTE Function
Removes matching quotation marks from a character string that begins
with an individual quotation mark and deletes everything that is to
the right of the closing quotation mark
FIND Function
Searches for a specific substring of characters within a character
string that you specify
FINDC Function
Searches for specific characters that either appear or do not appear
within a character string that you specify
IFC Function
Returns a character value of an expression based on whether the
expression is true, false, or missing
IFN Function
Returns a numeric value of an expression based on whether the
expression is true, false, or missing
INDEX Function
Searches a character expression for a string of characters
INDEXC Function
Searches a character expression for specific characters
INDEXW Function
Searches a character expression for a specified string as a word
LEFT Function
Left aligns a SAS character expression
LENGTH Function
Returns the length of a non-blank character string, excluding
trailing blanks, and returns 1 for a blank character string
LENGTHC Function
Returns the length of a character string, including trailing blanks
LENGTHM Function
Returns the amount of memory (in bytes) that is allocated for a
character string
LENGTHN Function
Returns the length of a non-blank character string, excluding
trailing blanks, and returns 0 for a blank character string
LOWCASE Function
Converts all letters in an argument to lowercase
MISSING Function
Returns a numeric result that indicates whether the argument contains
a missing value
NLITERAL Function
Converts a character string that you specify to a SAS name literal (n-literal)
NOTALNUM Function
Searches a character string for a non-alphanumeric character and
returns the first position at which it is found
NOTALPHA Function
Searches a character string for a non-alphabetic character and
returns the first position at which it is found
NOTCNTRL Function
Searches a character string for a character that is not a control
character and returns the first position at which it is found
NOTDIGIT Function
Searches a character string for any character that is not a digit and
returns the first position at which that character is found
NOTFIRST Function
Searches a character string for an invalid first character in a SAS
variable name under VALIDVARNAME=V7, and returns the first position at
which that character is found
NOTGRAPH Function
Searches a character string for a non-graphical character and returns
the first position at which it is found
NOTLOWER Function
Searches a character string for a character that is not a lowercase
letter and returns the first position at which that character is found
NOTNAME Function
Searches a character string for an invalid character in a SAS
variable name under VALIDVARNAME=V7, and returns the first position at
which that character is found
NOTPRINT Function
Searches a character string for a non-printable character and returns
the first position at which it is found
NOTPUNCT Function
Searches a character string for a character that is not a punctuation
character and returns the first position at which it is found
NOTSPACE Function
Searches a character string for a character that is not a white-space
character (blank, horizontal and vertical tab, carriage return, line
feed, form feed) and returns the first position at which it is found
NOTUPPER Function
Searches a character string for a character that is not an uppercase
letter and returns the first position at which that character is found
NOTXDIGIT Function
Searches a character string for a character that is not a hexadecimal
digit and returns the first position at which that character is found
NVALID Function
Checks a character string for validity for use as a SAS variable name
in a SAS statement
PROPCASE Function
Converts all words in an argument to proper case
QUOTE Function
Adds double quotation marks to a character value
RANK Function
Returns the position of a character in the ASCII or EBCDIC collating sequence
REPEAT Function
Repeats a character expression
REVERSE Function
Reverses a character expression
RIGHT Function
Right aligns a character expression
SCAN Function
Selects a given word from a character expression
SCANQ Function
Returns the nth word from a character expression, ignoring delimiters
that are enclosed in quotation marks
SOUNDEX Function
Encodes a string to facilitate searching
SPEDIS Function
Determines the likelihood of two words matching, expressed as the
asymmetric spelling distance between the two words
STRIP Function
Returns a character string with all leading and trailing blanks removed
SUBPAD Function
Returns a substring that has a length you specify, using blank
padding if necessary
SUBSTR (left of =) Function
Replaces character value contents
SUBSTR (right of =) Function
Extracts a substring from an argument
SUBSTRN Function
Returns a substring, allowing a result with a length of zero
TRANSLATE Function
Replaces specific characters in a character expression
TRANTAB Function
Transcodes a data string by using a translation table
TRANWRD Function
Replaces or removes all occurrences of a word in a character string
TRIM Function
Removes trailing blanks from character expressions and returns one
blank if the expression is missing
TRIMN Function
Removes trailing blanks from character expressions and returns a null
string (zero blanks) if the expression is missing
UPCASE Function
Converts all letters in an argument to uppercase
VERIFY Function
Returns the position of the first character that is unique to an expression
Currency Conversion EUROCURR Function
Converts one European currency to another
DBCS KCOMPARE Function
Returns the result of a comparison of character strings
KCOMPRESS Function
Removes specific characters from a character string
KCOUNT Function
Returns the number of double-byte characters in a string
KCVT Function
Converts data from an encoding code to another encoding code
KINDEX Function
Searches a character expression for a string of characters
KINDEXC Function
Searches a character expression for specific characters
KLEFT Function
Left aligns a character expression by removing unnecessary leading
DBCS blanks and SO/SI
KLENGTH Function
Returns the length of an argument
KLOWCASE Function
Converts all letters in an argument to lowercase
KREVERSE Function
Reverses a character expression
KRIGHT Function
Right aligns a character expression by trimming trailing DBCS blanks and SO/SI
KSCAN Function
Selects a specific word from a character expression
KSTRCAT Function
Concatenates two or more character strings
KSUBSTR Function
Extracts a substring from an argument
KSUBSTRB Function
Extracts a substring from an argument according to the byte position
of the substring in the argument
KTRANSLATE Function
Replaces specific characters in a character expression
KTRIM Function
Removes trailing DBCS blanks and SO/SI from character expressions
KTRUNCATE Function
Truncates a numeric value to a specified length
KUPCASE Function
Converts all single-byte letters in an argument to uppercase
KUPDATE Function
Inserts, deletes, and replaces character value contents
KUPDATEB Function
Inserts, deletes, and replaces the contents of the character value
according to the byte position of the character value in the argument
KVERIFY Function
Returns the position of the first character that is unique to an expression
Date and Time DATDIF Function
Returns the number of days between two dates
DATE Function
Returns the current date as a SAS date value
DATEJUL Function
Converts a Julian date to a SAS date value
DATEPART Function
Extracts the date from a SAS datetime value
DATETIME Function
Returns the current date and time of day as a SAS datetime value
DAY Function
Returns the day of the month from a SAS date value
DHMS Function
Returns a SAS datetime value from date, hour, minute, and second
HMS Function
Returns a SAS time value from hour, minute, and second values
HOUR Function
Returns the hour from a SAS time or datetime value
INTCK Function
Returns the integer count of the number of interval boundaries
between two dates, two times, or two datetime values
INTNX Function
Increments a date, time, or datetime value by a given interval or
intervals, and returns a date, time, or datetime value
JULDATE Function
Returns the Julian date from a SAS date value
JULDATE7 Function
Returns a seven-digit Julian date from a SAS date value
MDY Function
Returns a SAS date value from month, day, and year values
MINUTE Function
Returns the minute from a SAS time or datetime value
MONTH Function
Returns the month from a SAS date value
NLDATE Function
Converts the SAS date value to the date value of the specified locale
using the date-format modifiers
NLDATM Function
Converts the SAS datetime values to the time value of the specified
locale using the datetime format modifiers
NLTIME Function
Converts the SAS time or datetime value to the time value of the
specified locale using the time-format modifiers
QTR Function
Returns the quarter of the year from a SAS date value
SECOND Function
Returns the second from a SAS time or datetime value
TIME Function
Returns the current time of day
TIMEPART Function
Extracts a time value from a SAS datetime value
TODAY Function
Returns the current date as a SAS date value
WEEK Function
Returns the week number value
WEEKDAY Function
Returns the day of the week from a SAS date value
YEAR Function
Returns the year from a SAS date value
YRDIF Function
Returns the difference in years between two dates
YYQ Function
Returns a SAS date value from the year and quarter
Descriptive Statistics CSS Function
Returns the corrected sum of squares
CV Function
Returns the coefficient of variation
GEOMEAN Function
Returns the geometric mean
GEOMEANZ Function
Returns the geometric mean, using zero fuzzing
HARMEAN Function
Returns the harmonic mean
HARMEANZ Function
Returns the harmonic mean, using zero fuzzing
IQR Function
Returns the interquartile range
KURTOSIS Function
Returns the kurtosis
LARGEST Function
Returns the kth largest non-missing value
MAD Function
Returns the median absolute deviation from the median
MAX Function
Returns the largest value
MEAN Function
Returns the arithmetic mean (average)
MEDIAN Function
Computes median values
MIN Function
Returns the smallest value
MISSING Function
Returns a numeric result that indicates whether the argument contains
a missing value
N Function
Returns the number of nonmissing values
NMISS Function
Returns the number of missing values
ORDINAL Function
Returns any specified order statistic
PCTL Function
Computes percentiles
RANGE Function
Returns the range of values
RMS Function
Returns the root mean square
SKEWNESS Function
Returns the skewness
SMALLEST Function
Returns the kth smallest nonmissing value
STD Function
Returns the standard deviation
STDERR Function
Returns the standard error of the mean
SUM Function
Returns the sum of the nonmissing arguments
USS Function
Returns the uncorrected sum of squares
VAR Function
Returns the variance
External Files DCLOSE Function
Closes a directory that was opened by the DOPEN function
DCREATE Function
Creates an external directory
DINFO Function
Returns information about a directory
DNUM Function
Returns the number of members in a directory
DOPEN Function
Opens a directory and returns a directory identifier value
DOPTNAME Function
Returns directory attribute information
DOPTNUM Function
Returns the number of information items that are available for a directory
DREAD Function
Returns the name of a directory member
DROPNOTE Function
Deletes a note marker from a SAS data set or an external file
FAPPEND Function
Appends the current record to the end of an external file
FCLOSE Function
Closes an external file, directory, or directory member
FCOL Function
Returns the current column position in the File Data Buffer (FDB)
FDELETE Function
Deletes an external file or an empty directory
FEXIST Function
Verifies the existence of an external file associated with a fileref
FGET Function
Copies data from the File Data Buffer (FDB) into a variable
FILEEXIST Function
Verifies the existence of an external file by its physical name
FILENAME Function
Assigns or deassigns a fileref to an external file, directory, or
output device
FILEREF Function
Verifies that a fileref has been assigned for the current SAS session
FINFO Function
Returns the value of a file information item
FNOTE Function
Identifies the last record that was read and returns a value that
FPOINT can use
FOPEN Function
Opens an external file and returns a file identifier value
FOPTNAME Function
Returns the name of an item of information about a file
FOPTNUM Function
Returns the number of information items that are available for an
external file
FPOINT Function
Positions the read pointer on the next record to be read
FPOS Function
Sets the position of the column pointer in the File Data Buffer (FDB)
FPUT Function
Moves data to the File Data Buffer (FDB) of an external file,
starting at the FDB's current column position
FREAD Function
Reads a record from an external file into the File Data Buffer (FDB)
FREWIND Function
Positions the file pointer to the start of the file
FRLEN Function
Returns the size of the last record read, or, if the file is opened
for output, returns the current record size
FSEP Function
Sets the token delimiters for the FGET function
FWRITE Function
Writes a record to an external file
MOPEN Function
Opens a file by directory id and member name, and returns the file
identifier or a 0
PATHNAME Function
Returns the physical name of a SAS data library or of an external
file, or returns a blank
SYSMSG Function
Returns the text of error messages or warning messages from the last
data set or external file function execution
SYSRC Function
Returns a system error number
External Routines CALL MODULE Routine
Calls the external routine without any return code
CALL MODULEI Routine
Calls the external routine without any return code (in IML environment only)
MODULEC Function
Calls an external routine and returns a character value
MODULEIC Function
Calls an external routine and returns a character value (in IML
environment only)
MODULEIN Function
Calls an external routine and returns a numeric value (in IML
environment only)
MODULEN Function
Calls an external routine and returns a numeric value
Financial COMPOUND Function
Returns compound interest parameters
CONVX Function
Returns the convexity for an enumerated cash flow
CONVXP Function
Returns the convexity for a periodic cash flow stream, such as a bond
DACCDB Function
Returns the accumulated declining balance depreciation
DACCDBSL Function
Returns the accumulated declining balance with conversion to a
straight-line depreciation
DACCSL Function
Returns the accumulated straight-line depreciation
DACCSYD Function
Returns the accumulated sum-of-years-digits depreciation
DACCTAB Function
Returns the accumulated depreciation from specified tables
DEPDB Function
Returns the declining balance depreciation
DEPDBSL Function
Returns the declining balance with conversion to a straight-line depreciation
DEPSL Function
Returns the straight-line depreciation
DEPSYD Function
Returns the sum-of-years-digits depreciation
DEPTAB Function
Returns the depreciation from specified tables
DUR Function
Returns the modified duration for an enumerated cash flow
DURP Function
Returns the modified duration for a periodic cash flow stream, such as a bond
INTRR Function
Returns the internal rate of return as a fraction
IRR Function
Returns the internal rate of return as a percentage
MORT Function
Returns amortization parameters
NETPV Function
Returns the net present value as a fraction
NPV Function
Returns the net present value with the rate expressed as a percentage
PVP Function
Returns the present value for a periodic cash flow stream with
repayment of principal at maturity, such as a bond
SAVING Function
Returns the future value of a periodic saving
YIELDP Function
Returns the yield-to-maturity for a periodic cash flow stream, such as a bond
Hyperbolic COSH Function
Returns the hyperbolic cosine
SINH Function
Returns the hyperbolic sine
TANH Function
Returns the hyperbolic tangent
Macro CALL EXECUTE Routine
Resolves an argument and issues the resolved value for execution
CALL SYMPUT Routine
Assigns DATA step information to a macro variable
CALL SYMPUTX Routine
Assigns a value to a macro variable and removes both leading and
trailing blanks
RESOLVE Function
Returns the resolved value of an argument after it has been processed
by the macro facility
SYMEXIST Function
Returns an indication of the existence of a macro variable
SYMGET Function
Returns the value of a macro variable during DATA step execution
SYMGLOBL Function
Returns an indication as to whether a macro variable is in a global
scope to the DATA step during DATA step execution.
SYMLOCAL Function
Returns an indication as to whether a macro variable is in a local
scope to the DATA step during DATA step execution
Mathematical ABS Function
Returns the absolute value
AIRY Function
Returns the value of the airy function
BETA Function
Returns the value of the beta function
CALL ALLPERM Routine
Generates all permutations of the values of several variables
CALL LOGISTIC Routine
Returns the logistic value
CALL SOFTMAX Routine
Returns the softmax value
CALL STDIZE Routine
Standardizes the values of one or more variables
CALL TANH Routine
Returns the hyperbolic tangent
CNONCT Function
Returns the noncentrality parameter from a chi-squared distribution
COALESCE Function
Returns the first non-missing value from a list of numeric arguments.
COMB Function
Computes the number of combinations of n elements taken r at a time
CONSTANT Function
Computes some machine and mathematical constants
DAIRY Function
Returns the derivative of the AIRY function
DEVIANCE Function
Computes the deviance
DIGAMMA Function
Returns the value of the Digamma function
ERF Function
Returns the value of the (normal) error function
ERFC Function
Returns the value of the complementary (normal) error function
EXP Function
Returns the value of the exponential function
FACT Function
Computes a factorial
FNONCT Function
Returns the value of the noncentrality parameter of an F distribution
GAMMA Function
Returns the value of the Gamma function
IBESSEL Function
Returns the value of the modified bessel function
JBESSEL Function
Returns the value of the bessel function
LGAMMA Function
Returns the natural logarithm of the Gamma function
LOG Function
Returns the natural (base e) logarithm
LOG10 Function
Returns the logarithm to the base 10
LOG2 Function
Returns the logarithm to the base 2
LOGBETA Function
Returns the logarithm of the beta function
MOD Function
Returns the remainder from the division of the first argument by the
second argument, fuzzed to avoid most unexpected floating-point
results
MODZ Function
Returns the remainder from the division of the first argument by the
second argument, using zero fuzzing
PERM Function
Computes the number of permutations of n items taken r at a time
SIGN Function
Returns the sign of a value
SQRT Function
Returns the square root of a value
TNONCT Function
Returns the value of the noncentrality parameter from the student's t
distribution
TRIGAMMA Function
Returns the value of the Trigamma function
Probability CDF Function
Computes cumulative distribution functions
LOGCDF Function
Computes the logarithm of a left cumulative distribution function
LOGPDF Function
Computes the logarithm of a probability density (mass) function
LOGSDF Function
Computes the logarithm of a survival function
PDF Function
Computes probability density (mass) functions
POISSON Function
Returns the probability from a Poisson distribution
PROBBETA Function
Returns the probability from a beta distribution
PROBBNML Function
Returns the probability from a binomial distribution
PROBBNRM Function
Computes a probability from the bivariate normal distribution
PROBCHI Function
Returns the probability from a chi-squared distribution
PROBF Function
Returns the probability from an F distribution
PROBGAM Function
Returns the probability from a gamma distribution
PROBHYPR Function
Returns the probability from a hypergeometric distribution
PROBMC Function
Computes a probability or a quantile from various distributions for
multiple comparisons of means
PROBNEGB Function
Returns the probability from a negative binomial distribution
PROBNORM Function
Returns the probability from the standard normal distribution
PROBT Function
Returns the probability from a t distribution
SDF Function
Computes a survival function
Quantile BETAINV Function
Returns a quantile from the beta distribution
CINV Function
Returns a quantile from the chi-squared distribution
FINV Function
Returns a quantile from the F distribution
GAMINV Function
Returns a quantile from the gamma distribution
PROBIT Function
Returns a quantile from the standard normal distribution
QUANTILE Function
Computes the quantile from a specified distribution
TINV Function
Returns a quantile from the t distribution
Random Number CALL RANBIN Routine
Returns a random variate from a binomial distribution
CALL RANCAU Routine
Returns a random variate from a Cauchy distribution
CALL RANEXP Routine
Returns a random variate from an exponential distribution
CALL RANGAM Routine
Returns a random variate from a gamma distribution
CALL RANNOR Routine
Returns a random variate from a normal distribution
CALL RANPERK Routine
Randomly permutes the values of the arguments, and returns a
permutation of k out of n values
CALL RANPERM Routine
Randomly permutes the values of the arguments
CALL RANPOI Routine
Returns a random variate from a Poisson distribution
CALL RANTBL Routine
Returns a random variate from a tabled probability distribution
CALL RANTRI Routine
Returns a random variate from a triangular distribution
CALL RANUNI Routine
Returns a random variate from a uniform distribution
CALL STREAMINIT Routine
Specifies a seed value to use for subsequent random number generation
by the RAND function
NORMAL Function
Returns a random variate from a normal distribution
RANBIN Function
Returns a random variate from a binomial distribution
RANCAU Function
Returns a random variate from a Cauchy distribution
RAND Function
Generates random numbers from a specified distribution
RANEXP Function
Returns a random variate from an exponential distribution
RANGAM Function
Returns a random variate from a gamma distribution
RANNOR Function
Returns a random variate from a normal distribution
RANPOI Function
Returns a random variate from a Poisson distribution
RANTBL Function
Returns a random variate from a tabled probability distribution
RANTRI Function
Returns a random variate from a triangular distribution
RANUNI Function
Returns a random variate from a uniform distribution
UNIFORM Function
Returns a random variate from a uniform distribution
SAS File I/O ATTRC Function
Returns the value of a character attribute for a SAS data set
ATTRN Function
Returns the value of a numeric attribute for the specified SAS data set
CEXIST Function
Verifies the existence of a SAS catalog or SAS catalog entry
CLOSE Function
Closes a SAS data set
CUROBS Function
Returns the observation number of the current observation
DROPNOTE Function
Deletes a note marker from a SAS data set or an external file
DSNAME Function
Returns the SAS data set name that is associated with a data set identifier
EXIST Function
Verifies the existence of a SAS data library member
FETCH Function
Reads the next nondeleted observation from a SAS data set into the
Data Set Data Vector (DDV)
FETCHOBS Function
Reads a specified observation from a SAS data set into the Data Set
Data Vector (DDV)
GETVARC Function
Returns the value of a SAS data set character variable
GETVARN Function
Returns the value of a SAS data set numeric variable
IORCMSG Function
Returns a formatted error message for _IORC_
LIBNAME Function
Assigns or deassigns a libref for a SAS data library
LIBREF Function
Verifies that a libref has been assigned
NOTE Function
Returns an observation ID for the current observation of a SAS data set
OPEN Function
Opens a SAS data set
PATHNAME Function
Returns the physical name of a SAS data library or of an external
file, or returns a blank
POINT Function
Locates an observation identified by the NOTE function
REWIND Function
Positions the data set pointer at the beginning of a SAS data set
SYSMSG Function
Returns the text of error messages or warning messages from the last
data set or external file function execution
SYSRC Function
Returns a system error number
VARFMT Function
Returns the format assigned to a SAS data set variable
VARINFMT Function
Returns the informat assigned to a SAS data set variable
VARLABEL Function
Returns the label assigned to a SAS data set variable
VARLEN Function
Returns the length of a SAS data set variable
VARNAME Function
Returns the name of a SAS data set variable
VARNUM Function
Returns the number of a variable's position in a SAS data set
VARTYPE Function
Returns the data type of a SAS data set variable
Special ADDR Function
Returns the memory address of a numeric variable on a 32-bit platform
ADDRLONG Function
Returns the memory address of a character variable on 32-bit and
64-bit platforms
CALL POKE Routine
Writes a value directly into memory on a 32-bit platform
CALL POKELONG Routine
Writes a value directly into memory on 32-bit and 64-bit platforms
CALL SLEEP Routine
Suspends the execution of a program that invokes this call routine
for a specified period of time
CALL SYSTEM Routine
Submits an operating environment command for execution
DIF Function
Returns differences between the argument and its nth lag
GETOPTION Function
Returns the value of a SAS system or graphics option
INPUT Function
Returns the value produced when a SAS expression that uses a
specified informat expression is read
INPUTC Function
Enables you to specify a character informat at run time
INPUTN Function
Enables you to specify a numeric informat at run time
LAG Function
Returns values from a queue
PEEK Function
Stores the contents of a memory address into a numeric variable on a
32-bit platform
PEEKC Function
Stores the contents of a memory address in a character variable on a
32-bit platform
PEEKCLONG Function
Stores the contents of a memory address in a character variable on
32-bit and 64-bit platforms
PEEKLONG Function
Stores the contents of a memory address in a numeric variable on
32-bit and 64-bit platforms
PTRLONGADD Function
Returns the pointer address as a character variable on 32-bit and
64-bit platforms
PUT Function
Returns a value using a specified format
PUTC Function
Enables you to specify a character format at run time
PUTN Function
Enables you to specify a numeric format at run time
SLEEP Function
Suspends the execution of a program that invokes this function for a
specified period of time
SYSGET Function
Returns the value of the specified operating environment variable
SYSPARM Function
Returns the system parameter string
SYSPROCESSID Function
Returns the process id of the current process
SYSPROCESSNAME Function
Returns the process name associated with a given process id or the
name of the current process
SYSPROD Function
Determines if a product is licensed
SYSTEM Function
Issues an operating environment command during a SAS session and
returns the system return code
UUIDGEN Function
Returns the short or binary form of a Universal Unique Identifier (UUID)
State and ZIP Code FIPNAME Function
Converts two-digit FIPS codes to uppercase state names
FIPNAMEL Function
Converts two-digit FIPS codes to mixed case state names
FIPSTATE Function
Converts two-digit FIPS codes to two-character state postal codes
STFIPS Function
Converts state postal codes to FIPS state codes
STNAME Function
Converts state postal codes to uppercase state names
STNAMEL Function
Converts state postal codes to mixed case state names
ZIPCITY Function
Returns a city name and the two-character postal code that
corresponds to a ZIP code
ZIPFIPS Function
Converts ZIP codes to two-digit FIPS codes
ZIPNAME Function
Converts ZIP codes to uppercase state names
ZIPNAMEL Function
Converts ZIP codes to mixed case state names
ZIPSTATE Function
Converts ZIP codes to two-character state postal codes
Trigonometric ARCOS Function
Returns the arccosine
ARSIN Function
Returns the arcsine
ATAN Function
Returns the arc tangent
ATAN2 Function
Returns the arc tangent of two numeric variables
COS Function
Returns the cosine
SIN Function
Returns the sine
TAN Function
Returns the tangent
Truncation CEIL Function
Returns the smallest integer that is greater than or equal to the
argument, fuzzed to avoid unexpected floating-point results
CEILZ Function
Returns the smallest integer that is greater than or equal to the
argument, using zero fuzzing
FLOOR Function
Returns the largest integer that is less than or equal to the
argument, fuzzed to avoid unexpected floating-point results
FLOORZ Function
Returns the largest integer that is less than or equal to the
argument, using zero fuzzing
FUZZ Function
Returns the nearest integer if the argument is within 1E-12
INT Function
Returns the integer value, fuzzed to avoid unexpected floating-point results
INTZ Function
Returns the integer portion of the argument, using zero fuzzing
ROUND Function
Rounds the first argument to the nearest multiple of the second
argument, or to the nearest integer when the second argument is
omitted
ROUNDE Function
Rounds the first argument to the nearest multiple of the second
argument, and returns an even multiple when the first argument is
halfway between the two nearest multiples
ROUNDZ Function
Rounds the first argument to the nearest multiple of the second
argument, with zero fuzzing
TRUNC Function
Truncates a numeric value to a specified length
Variable Control CALL LABEL Routine
Assigns a variable label to a specified character variable
CALL SET Routine
Links SAS data set variables to DATA step or macro variables that
have the same name and data type
CALL VNAME Routine
Assigns a variable name as the value of a specified variable
Variable Information CALL VNEXT Routine
Returns the name, type, and length of a variable that is used in a DATA step
VARRAY Function
Returns a value that indicates whether the specified name is an array
VARRAYX Function
Returns a value that indicates whether the value of the specified
argument is an array
VARTRANSCODE Function
Returns the transcode attribute of a SAS data set variable
VFORMAT Function
Returns the format that is associated with the specified variable
VFORMATD Function
Returns the format decimal value that is associated with the
specified variable
VFORMATDX Function
Returns the format decimal value that is associated with the value of
the specified argument
VFORMATN Function
Returns the format name that is associated with the specified variable
VFORMATNX Function
Returns the format name that is associated with the value of the
specified argument
VFORMATW Function
Returns the format width that is associated with the specified variable
VFORMATWX Function
Returns the format width that is associated with the value of the
specified argument
VFORMATX Function
Returns the format that is associated with the value of the specified
argument
VINARRAY Function
Returns a value that indicates whether the specified variable is a
member of an array
VINARRAYX Function
Returns a value that indicates whether the value of the specified
argument is a member of an array
VINFORMAT Function
Returns the informat that is associated with the specified variable
VINFORMATD Function
Returns the informat decimal value that is associated with the
specified variable
VINFORMATDX Function
Returns the informat decimal value that is associated with the value
of the specified argument
VINFORMATN Function
Returns the informat name that is associated with the specified variable
VINFORMATNX Function
Returns the informat name that is associated with the value of the
specified argument
VINFORMATW Function
Returns the informat width that is associated with the specified variable
VINFORMATWX Function
Returns the informat width that is associated with the value of the
specified argument
VINFORMATX Function
Returns the informat that is associated with the value of the
specified argument
VLABEL Function
Returns the label that is associated with the specified variable
VLABELX Function
Returns the variable label for the value of the specified argument
VLENGTH Function
Returns the compile-time (allocated) size of the specified variable
VLENGTHX Function
Returns the compile-time (allocated) size for the value of the
specified argument
VNAME Function
Returns the name of the specified variable
VNAMEX Function
Validates the value of the specified argument as a variable name
VTRANSCODE Function
Returns a value that indicates whether transcoding is on or off for
the specified character variable
VTRANSCODEX Function
Returns a value that indicates whether transcoding is on or off for
the specified argument
VTYPE Function
Returns the type (character or numeric) of the specified variable
VTYPEX Function
Returns the type (character or numeric) for the value of the
specified argument
VVALUE Function
Returns the formatted value that is associated with the variable that
you specify
VVALUEX Function
Returns the formatted value that is associated with the argument that
you specify
Web Tools HTMLDECODE Function
Decodes a string containing HTML numeric character references or HTML
character entity references and returns the decoded string
HTMLENCODE Function
Encodes characters using HTML character entity references and returns
the encoded string
URLDECODE Function
Returns a string that was decoded using the URL escape syntax
URLENCODE Function
Returns a string that was encoded using the URL escape syntax
Previous Page | Next Page | Top of Page
Copyright (c) 2006 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
Post by t***@hotpop.comHi All
How can I convert char to num and num to char in datastep (in proc sql)?
So basic, so troublesome - only in SAS.
Toby
While they SAS provides such specialized functions to convert zip to
state and other useless ones, to me it seems the most basic functions
are missing in SAS. In addition, listing functions alphabetically in the
help file does not indicate much intelligence behind the SAS system of
functions. In every other programming environment, I find such things
like operators, string manipulation functions, methematical functions,
while in SAS its all just thrown into your face.