SAS Functions by Example, Second Edition
2nd Edition
Published on 12. November 2014
472 pages
978-1-60764-364-7 (ISBN)
Description
Fully updated for SAS 9.2, Ron Cody's SAS Functions by Example, Second Edition, is a must-have reference for anyone who programs in Base SAS. With the addition of functions new to SAS 9.2, this comprehensive reference manual now includes more than 200 functions, including new character, date and time, distance, probability, sort, and special functions. This new edition also contains more examples for existing functions and more details concerning optional arguments.
Like the first edition, the new edition also includes a list of SAS programs, an alphabetic list of all the functions in the book, and a comprehensive index of functions and tasks. Beginning and experienced SAS users will benefit from this useful reference guide to SAS functions.
This book is part of the SAS Press program.
More details
Other editions
Additional editions
Book
03/2010
2nd Edition
SAS Publishing
€86.40
Shipment within 3-4 weeks
Person
Ron Cody, EdD, is a retired professor from the Rutgers Robert Wood Johnson Medical School who now works as a national instructor for SAS and as an author of books on SAS and statistics. A SAS user since 1977, Ron's extensive knowledge and innovative style have made him a popular presenter at local, regional, and national SAS conferences. He has authored or co-authored numerous books, as well as countless articles in medical and scientific journals.
Content
- Intro
- Contents
- List of Programs
- PrefaceSecondEd.new
- PrefaceFirstEd.new
- Acknowledgments
- 1 Introduction: A Brief Discussion of SAS Functions and Call Routines
- Storage Length for Character Variables
- Explanation
- Function: UPCASE
- Explanation
- Function: LOWCASE
- Examples
- Explanation
- Function: PROPCASE
- Examples
- Explanation
- Explanation
- Function: COMPBL
- Example
- Explanation
- Function: COMPRESS
- Examples
- Explanation
- Converting Social Security Numbers to Numeric Form
- Explanation
- Counting the Number of Digits in a Character String
- Explanation
- The "ANY" Functions (ANYALNUM, ANYALPHA, ANYDIGIT, ANYPUNCT, ANYSPACE, ANYUPPER, and ANYLOWER)
- Function: ANYALNUM
- Function: ANYDIGIT
- Examples
- Function: ANYPUNCT
- Examples
- Function: ANYSPACE
- Examples
- Explanation
- Explanation
- The "NOT" Functions (NOTALNUM, NOTALPHA, NOTDIGIT, NOTUPPER and NOTLOWER)
- Function: NOTALNUM
- Examples
- Function: NOTALPHA
- Examples
- Function: NOTDIGIT
- Examples
- Function: NOTUPPER
- Examples
- Function: NOTLOWER
- Examples
- Explanation
- FIND, FINDC, and FINDW
- Function: FIND
- Examples
- Function: FINDC
- Examples
- Explanation
- Explanation
- Explanation
- Explanation
- Function: FINDW
- Examples
- Explanation
- INDEX, INDEXC, and INDEXW
- Function: INDEX
- Examples
- Function: INDEXC
- Examples
- Explanation
- Function: VERIFY
- Examples
- Explanation
- Function: SUBSTR
- Examples
- Explanation
- Explanation
- Explanation
- Function: SUBSTR (on the left-hand side of the equal sign)
- Examples
- Explanation
- Function: SUBSTRN
- Examples
- Explanation
- Function: CHAR
- Examples
- Explanation
- Function: FIRST
- Examples
- Explanation
- CALL Routines
- Function: CALL CATS
- Example
- Function: CALL CATT
- Example
- Function: CALL CATX
- Example
- Explanation
- Example
- Function: CATS
- Example
- Function: CATT
- Example
- Function: CATX
- Example
- Function: CATQ
- LEFT and RIGHT
- Function: LEFT
- Example
- Explanation
- Function: RIGHT
- Example
- Explanation
- TRIM, TRIMN, and STRIP
- Function: TRIM
- Examples
- Explanation
- Function: TRIMN
- Examples
- Explanation
- Function: STRIP
- Examples
- Explanation
- Function: COMPARE
- Examples
- Explanation
- CALL COMPCOST, COMPGED, and COMPLEV
- Function: CALL COMPCOST
- Examples
- Explanation
- Function: COMPLEV
- Examples
- Explanation
- Output from Program 1.37
- Explanation
- SAS Log from Program without CALL COMPCOST
- SAS Log from Program with CALL COMPCOST
- Function: SOUNDEX
- Explanation
- Function: SPEDIS
- Examples
- SCAN
- Function: SCAN
- Examples
- Explanation
- Explanation
- Explanation
- CALL SCAN
- Function: CALL SCAN
- Examples
- Explanation
- Explanation
- Function: TRANSLATE
- Examples
- Explanation
- Explanation
- Function: TRANWRD
- Examples
- Explanation
- Function: LENGTH
- Examples
- Function: LENGTHC
- Examples
- Function: LENGTHM
- Examples
- Function: LENGTHN
- Examples
- Function: COUNT
- Examples
- Explanation
- Function: COUNTC
- Examples
- Explanation
- Function: COUNTW
- Examples
- Explanation
- Function: CHOOSEC
- Examples:
- Explanation
- Function: CHOOSEN
- Examples:
- Explanation
- Function: MISSING
- Examples:
- Explanation
- Explanation
- Function: COALESCEC
- Examples
- Explanation
- Function: IFC
- Examples
- Function: RANK
- Examples
- Examples
- Explanation
- Function: REVERSE
- Examples
- Examples
- Explanation
- Function: NVALID
- Examples
- Explanation
- 2 Perl Regular Expressions
- Explanation
- Function: PRXMATCH
- Explanation
- Explanation
- Explanation
- Function: CALL PRXSUBSTR
- Examples
- Explanation
- Explanation
- Function: CALL PRXPOSN
- Example
- Explanation
- Explanation
- Function: CALL PRXNEXT
- Examples
- Explanation
- Explanation
- Explanation
- Function: CALL PRXFREE
- Examples
- Explanation
- 3 Sort Functions
- Function: CALL SORTN
- Examples
- Explanation
- Explanation
- Function: CALL SORTC
- Examples
- Explanation
- Function: MDY
- Examples
- Explanation
- Explanation
- Function: DHMS
- Examples
- Function: HMS
- Examples
- Function: DATE and TODAY (equivalent functions)
- Examples
- Function: DATETIME
- Examples
- Function: TIME
- Examples
- Explanation
- Creating a Data Set to Demonstrate Other Date Functions
- Explanation
- Function: YEAR
- Examples
- Function: QTR
- Examples
- Function: MONTH
- Examples
- Function: WEEK
- Examples
- Function: WEEKDAY
- Examples
- Examples
- Explanation
- Function: HOUR
- Function: MINUTE
- Examples
- Function: SECOND
- Examples
- Explanation
- Function: DATEPART
- Examples
- Function: TIMEPART
- Examples
- Explanation
- Function: INTCK
- Examples
- A Discussion of Interval Multipliers and Shifted Intervals
- Function: INTNX
- Examples
- Some examples demonstrating the SAMEDAY alignment
- Explanation
- Using the INTNX Function to Determine Starting Boundaries for Multi-Day Intervals
- Function: YRDIF
- Examples
- Explanation
- Computing Exact Ages
- Partial List of Holidays:
- Examples
- Explanation
- Function: DATEJUL
- Function: JULDATE
- Examples
- Function: JULDATE7
- Examples
- Explanation
- 5 Array Functions
- Function: DIM
- Purpose: To determine the number of elements in an array.
- Examples
- Explanation
- Program 5.2: Creating a macro to compute and print out the number of numeric and character variables in a SAS data set
- Explanation
- *** statistics for data set array_1 ***
- There are 7 numeric variables and 2 character variables
- Using the DIM Function with Multidimensional Arrays
- Functions: HBOUND and LBOUND
- Explanation
- 6 Truncation Functions
- Function: CEIL
- Examples
- Explanation
- Function: FLOOR
- Examples
- Explanation
- Function: INT
- Examples
- Explanation
- Function: ROUND
- Examples
- Explanation
- Explanation
- Demonstrating the Difference between Various Truncation Functions
- Explanation
- Function: TRUNC
- Examples
- Explanation
- 7 Descriptive Statistics Functions
- Function: N
- Examples
- Explanation
- Function: NMISS
- Examples
- Explanation
- Function: MEAN
- Examples
- Function: MEDIAN
- Examples
- Function: SUM
- Examples
- Explanation
- Function: RANGE
- Examples
- Function: IQR
- Examples
- Function: STD
- Examples
- Explanation
- Function: MIN
- Examples
- Function: MAX
- Examples
- Explanation
- A Word about the SMALLEST and LARGEST Functions
- Function: SMALLEST
- Examples
- Explanation
- Examples
- Explanation
- A Macro to Average Test Scores Where One or More of the Lowest Scores Are Dropped
- Explanation
- Function: PCTL
- Examples
- Explanation
- Function: ORDINAL
- Examples
- Explanation
- Explanation
- Using the STD Function to Perform a t-Test
- Explanation
- 8 Mathematical and Numeric Functions
- Function: CONSTANT
- Examples
- Function: MOD
- Examples
- Explanation
- Explanation
- Function: ABS
- Examples
- Explanation
- Function: SQRT
- Examples
- Explanation
- Function: EXP
- Examples
- Function: LOG
- Examples
- Function: LOG10
- Function: FACT
- Examples
- Function: GAMMA
- Examples
- Explanation
- Function: IFN
- Examples
- Explanation
- Explanation
- 9 Random Number Functions
- A Word about Random Number Seeds
- Explanation
- Explanation
- Function: RANUNI
- Examples
- Explanation
- Explanation
- Explanation
- Explanation
- Explanation
- Explanation
- Two Macros to Assign n Subjects into k Groups
- Function: CALL RANUNI
- Examples
- Function: RANNOR
- Examples
- Explanation
- Function: CALL RANNOR
- Examples
- Explanation
- Function: RAND
- 10 Special Functions
- Functions: LAG and LAGn
- Examples
- Explanation
- Examples
- Explanation
- Explanation
- Function: INPUTC
- Examples
- Explanation
- Explanation
- Function: PUT
- Examples
- Explanation
- Function: PUTC
- Examples
- Explanation
- Function: PUTN
- Examples
- Explanation
- 11 State and ZIP Code Functions
- Function: FIPNAME
- Examples
- Function: FIPNAMEL
- Examples
- Function: FIPSTATE
- Examples
- Explanation
- Function: STFIPS
- Examples
- Function: STNAME
- Examples
- Function: STNAMEL
- Examples
- Explanation
- Function: ZIPFIPS
- Examples
- Function: ZIPNAME
- Examples
- Function: ZIPNAMEL
- Examples
- Function: ZIPSTATE
- Examples
- Function: GEODIST
- Examples
- Explanation
- 12 Trigonometric Functions
- Function: COS
- Examples
- Function: SIN
- Examples
- Function: TAN
- Examples
- Explanation
- Function: ARCOS
- Examples
- Function: ARSIN
- Examples
- Explanation
- Function: ATAN
- Examples
- Explanation
- 13 Macro Functions
- Function: CALL SYMPUT
- Examples
- Function: CALL SYMPUTX
- Examples
- Explanation
- Explanation
- Function: RESOLVE
- Examples
- Explanation
- Function: CALL EXECUTE
- Examples
- Explanation
- Explanation
- Function: SYMGET
- Examples
- Explanation
- 14 SAS File I/O Functions
- Creating Test Data Sets
- Function: EXIST
- Function: OPEN
- Examples
- Function: CLOSE
- Examples
- Function: ATTRC
- Examples
- Function: ATTRN
- Examples
- Explanation
- Function: DSNAME
- Examples
- Explanation
- Function: VARLABEL
- Examples
- Function: VARLEN
- Examples
- Explanation
- Function: VARNAME
- Examples
- Function: VARNUM
- Examples
- Explanation
- Function: VARTYPE
- Explanation
- 15 Variable Information Functions
- Function: VTYPE
- Examples
- Explanation
- Function: VLENGTH
- Example
- Function: VNAME
- Examples
- Explanation
- Explanation
- Function: VLABEL
- Examples
- Function: CALL VNEXT
- Examples
- Explanation
- Function: VVALUE
- Examples
- Explanation
- Function: VFORMAT
- Examples
- Function: VFORMATD
- Examples
- Function: VFORMATN
- Examples
- Function: VFORMATW
- Examples
- Function: VINFORMAT
- Examples
- Examples
- Function: VINFORMATN
- Examples
- Function: VINFORMATW
- Examples
- Explanation
- 16 Bitwise Logical Functions
- Function: BNOT
- Examples
- Function: BAND
- Examples
- Function: BOR
- Examples
- Function: BXOR
- Examples
- Explanation
- Explanation
- Encrypting and Decrypting Macros
- Explanation
- List of Functions
- Index
