SAS Functions by Example, Second Edition

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. Contents 4 List of Programs 8 Preface to the Second Edition 20 Preface to the First Edition 22 Acknowledgments 24 Introduction 26 Chapter 1 Character Functions 28 Storage Length for Character Variables 30 Function: UPCASE 33 Function: LOWCASE 34 Function: PROPCASE 36 Function: COMPBL 38 Function: COMPRESS 39 Converting Social Security Numbers to Numeric Form 41 Counting the Number of Digits in a Character String 42 The "ANY" Functions (ANYALNUM, ANYALPHA, ANYDIGIT, ANYPUNCT, ANYSPACE, ANYUPPER, and ANYLOWER) 43 Function: ANYALNUM 44 Function: ANYALPHA 45 Function: ANYDIGIT 46 Function: ANYPUNCT 47 Function: ANYSPACE 48 Function: ANYUPPER 49 Function: ANYLOWER 50 The "NOT" Functions (NOTALNUM, NOTALPHA, NOTDIGIT, NOTUPPER and NOTLOWER) 53 Function: NOTALNUM 53 Function: NOTALPHA 54 Function: NOTDIGIT 55 Function: NOTUPPER 56 Function: NOTLOWER 57 FIND, FINDC, and FINDW 59 Function: FIND 59 Function: FINDC 61 Function: FINDW 66 INDEX, INDEXC, and INDEXW 68 Function: INDEX 69 Function: INDEXC 69 Function: VERIFY 71 Function: SUBSTR 73 Function: SUBSTR (on the left-hand side of the equal sign) 77 Function: SUBSTRN 79 Function: CHAR 81 Function: FIRST 82 CALL Routines 84 Function: CALL CATS 85 Function: CALL CATT 86 Function: CALL CATX 87 The “CAT” Functions (CAT, CATS, CATT, CATX, and CATQ) 89 Function: CAT 89 Function: CATS 90 Function: CATT 91 Function: CATX 92 Function: CATQ 93 LEFT and RIGHT 97 Function: LEFT 97 Function: RIGHT 99 TRIM, TRIMN, and STRIP 100 Function: TRIM 100 Function: TRIMN 102 Function: STRIP 104 Function: COMPARE 105 CALL COMPCOST, COMPGED, and COMPLEV 108 Function: CALL COMPCOST 108 Function: COMPGED 109 Function: COMPLEV 111 Function: SOUNDEX 116 Function: SPEDIS 119 SCAN 124 Function: SCAN 124 CALL SCAN 129 Function: CALL SCAN 129 Function: TRANSLATE 133 Function: TRANWRD 136 Function: LENGTH 138 Function: LENGTHC 139 Function: LENGTHM 139 Function: LENGTHN 140 Function: COUNT 141 Function: COUNTC 143 Function: COUNTW 145 Function: CHOOSEC 148 Function: CHOOSEN 150 Function: MISSING 152 Function: COALESCEC 155 Function: IFC 156 Function: RANK 159 Function: REPEAT 160 Function: REVERSE 162 Function: NLITERAL 163 Function: NVALID 165 Chapter 2 Perl Regular Expressions 170 Function: PRXMATCH 179 Function: CALL PRXSUBSTR 183 Function: CALL PRXPOSN 187 Function: CALL PRXNEXT 191 Function: PRXPAREN 193 Function: CALL PRXCHANGE 195 Function: CALL PRXFREE 198 Chapter 3 Sort Functions 200 Function: CALL SORTN 201 Function: CALL SORTC 203 Chapter 4 Date and Time Functions 205 Function: MDY 207 Function: DHMS 210 Function: HMS 211 Function: DATE and TODAY (equivalent functions) 211 Function: DATETIME 212 Function: TIME 212 Creating a Data Set to Demonstrate Other Date Functions 214 Function: YEAR 215 Function: QTR 216 Function: MONTH 216 Function: WEEK 217 Function: INTNX 232 Function: YRDIF 236 Computing Exact Ages 238 Function: DATEJUL 241 Function: JULDATE 242 Function: JULDATE7 243 Function: WEEKDAY 218 A Discussion of Interval Multipliers and Shifted Intervals 229 Using the INTNX Function to Determine Starting Boundaries for Multi-Day Intervals 235 Function: INTCK 224 Function: TIMEPART 223 Function: DATEPART 222 Function: SECOND 221 Function: MINUTE 220 Function: HOUR 220 Chapter 5 Array Functions 246 Function: DIM 246 Purpose: To determine the number of elements in an array. 247 Functions: HBOUND and LBOUND 250 Chapter 6 Truncation Functions 252 Function: CEIL 253 Function: FLOOR 254 Function: INT 256 Function: ROUND 257 Demonstrating the Difference between Various Truncation Functions 260 Function: TRUNC 261 Chapter 7 Descriptive Statistics Functions 264 Function: N 265 Function: NMISS 266 Function: MEAN 268 Function: MEDIAN 269 Function: SUM 269 Function: RANGE 271 Function: IQR 272 Function: STD 272 Function: MIN 274 Function: MAX 275 A Word about the SMALLEST and LARGEST Functions 276 Function: SMALLEST 276 Function: LARGEST 278 A Macro to Average Test Scores Where One or More of the Lowest Scores Are Dropped 280 Function: PCTL 282 Function: ORDINAL 284 Using the ORDINAL Function to Sort Values within an Observation 288 Using the STD Function to Perform a t-Test 291 Chapter 8 Mathematical and Numeric Functions 294 Function: CONSTANT 295 Function: MOD 297 Function: ABS 300 Function: SQRT 302 Function: EXP 303 Function: LOG 304 Function: LOG10 304 Function: FACT 306 Function: GAMMA 308 Function: IFN 309 Chaper 9 Random Number Functions 314 A Word about Random Number Seeds 315 Function: RANUNI 317 Two Macros to Assign n Subjects into k Groups 325 Function: CALL RANUNI 329 Function: RANNOR 330 Function: CALL RANNOR 335 Function: RAND 337 Chapter 10 Special Functions 342 Functions: LAG and LAGn 343 Function: INPUT 348 Function: INPUTC 351 Function: INPUTN 353 Function: PUT 354 Function: PUTC 356 Function: PUTN 358 Function: CALL MISSING 360 Chapter 11 State and ZIP Code Functions 362 Function: FIPNAME 363 Function: FIPNAMEL 363 Function: FIPSTATE 364 Function: STFIPS 366 Function: STNAME 366 Function: STNAMEL 367 Function: ZIPFIPS 369 Function: ZIPNAME 369 Function: ZIPNAMEL 370 Function: ZIPSTATE 371 Function: GEODIST 373 Chapter 12 Trigonometric Functions 378 Function: COS 379 Function: SIN 379 Function: TAN 380 Function: ARCOS 382 Function: ARSIN 383 Function: ATAN 384 Chapter 13 Macro Functions 386 Function: CALL SYMPUT 387 Function: CALL SYMPUTX 387 Function: RESOLVE 390 Function: CALL EXECUTE 392 Function: SYMGET 395 Chapter 14 SAS File I/O Functions 398 Creating Test Data Sets 399 Function: EXIST 400 Function: OPEN 401 Function: CLOSE 402 Function: ATTRC 402 Function: ATTRN 404 Function: DSNAME 406 Function: VARFMT 408 Function: VARLABEL 409 Function: VARLEN 410 Function: VARNAME 411 Function: VARNUM 412 Function: VARTYPE 413 Chapter 15 Variable Information Functions 418 Function: VTYPE 419 Function: VLENGTH 421 Function: VNAME 423 Function: VLABEL 426 Function: CALL VNEXT 426 Function: VVALUE 429 Function: VFORMAT 431 Function: VFORMATD 431 Function: VFORMATN 432 Function: VFORMATW 432 Function: VINFORMAT 433 Function: VINFORMATN 434 Function: VINFORMATW 435 Chapter 16 Bitwise Logical Functions 438 Function: BNOT 439 Function: BAND 440 Function: BOR 441 Function: BXOR 441 Encrypting and Decrypting Macros 445 List of Functions 448 Index 456 1607643405,9781607643401 Fully Updated For Sas 9.2, This Book 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--resource Description Page. Character Functions -- Perl Regular Expressions -- Sort Functions -- Date And Time Functions -- Array Functions -- Truncation Functions -- Descriptive Statistics Functions -- Mathematical And Numeric Functions -- Random Number Functions -- Special Functions -- State And Zip Code Functions -- Trigonometric Functions -- Macro Functions -- Sas File I/o Functions -- Variable Information Functions -- Bitwise Logical Functions. Ron Cody. Description Based On Print Version Record. Includes Index.