Rick Aster: Professional SAS Programming Shortcuts

Contents

About Online Files

• Introduction
• 1. The Log
  • Program: Multi-purpose terminator
• 2. Program Files
• 3. Startup
• 4. System Options
• 5. Libraries
• 6. Data Set Options
• 7. Indexes
• 8. Actions on SAS Data Sets
• 9. Data Type and Length
  • Program: Demonstrations of numeric truncation
• 10. Text Data Files
  • Text data: Ingredients (fixed-field)
  • Program: Ingredients (fixed-field)
  • Program: Demonstration of data lines in program file
• 11. Data Fields
  • Program: Writing scientific notation
  • Program: Reading signed numerals
  • Program: Writing signed numerals
• 12. Delimited Files
  • Text data: Presidents (comma-delimited)
  • Program: Reading comma-delimited data
  • Program: Exporting to spreadsheet with labels as headers
  • Program: Transforming all character variables
• 13. Hierarchical Files
  • Text data: Flowering plants (hierarchical)
  • Program: Reading hierarchical data
  • Program: Reading hierarchical data to create relational data
  • Program: Writing hierarchical data
• 14. Binary Files
• 15. Value Formats
  • Program: Value formats
• 16. Value Informats
  • Program: Value informats
• 17. Picture Formats for Numbers
  • Program: Picture formats for numbers
• 18. Format Catalogs and Control Data Sets
  • Program: ROMAN informat
  • Program: WDN and MX formats and informats
  • Program: $ZIPST format
• 19. Time
• 20. Informats and Formats for Time
• 21. International Date Formats
• 22. Picture Formats for Time
  • Program: Picture formats for time
• 23. Validation
  • Program: Value informats for validation
  • Program: Creating integrity constraints
• 24. Strings
  • Program: Shortening a title (two different ways)
• 25. Parsing
  • Program: Parsing chemical symbols
  • Program: Parsing chemical symbols (for SAS 8)
• 26. Variable-Length Strings
• 27. Foreign Data Types
  • Program: PSAY macro for pseudo-array references
  • Program: Bubble sort of character string
  • Program: Remove duplicate characters
• 28. Codes
  • Program: Add punctuation to telephone number
  • Program: Area code
  • Program: Generating serial numbers
  • Program: Adding check digits
• 29. Text Encryption
• 30. Discrete Binary Encoding
  • Program: $COUNTY informat and format (discrete binary encoding of Irish counties)
  • Program: Generating discrete binary encoding from list of values
• 31. Bitfields
• 32. Numeric Effects
  • Program: Double precision granularity
• 33. Missing Values
• 34. Boolean Values
• 35. Financial Calculations
  • Program: 30-year loan
  • Program: Straight-line depreciation
  • Program: Depreciation table
• 36. Time Conversions
• 37. Time Arithmetic
• 38. Extending the Observation Loop
• 39. Loops
• 40. Character Loops
  • Program: Censoring credit card numbers
  • Program: Spaces between characters
  • Online program: Word wrap
• 41. Subsetting and Sampling
  • Program: Random sample based on array of random numbers
  • Program: Sampling with replacement
• 42. SQL
• 43. Sorting
• 44. Groups
• 45. Incomplete Data
  • Program: Completing a range
  • Program: Completing a range (alternate)
  • Program: All possible key combinations
  • Program: Linear interpolation
• 46. Transposing
• 47. Frequency Tables
• 48. Descriptive Statistics
  • Program: Data step formulas for descriptive statistics
• 49. Summary Statistics in Computations
  • Program: Percent of total
  • Program: Percent of BY group total
• 50. Type Conversion
  • Program: Changing the data type of a variable in a SAS data set
• 51. Combining Data
  • Program: Merge after interleaving
  • Program: Merge after checking for unique key values
  • Program: Hierarchy linking
• 52. Table Lookup
  • Program: Chemical elements (lookup arrays)
• 53. Table Lookup From SAS Data Files
  • Program: State capital hash lookup
  • Program: Creating an observation-number lookup table
• 54. Value Formats for Table Lookup
  • Program: Value formats and informats for table lookup
  • Program: Converting a table to a value format
• 55. Calendars
  • Program: Calendar-based program parameters
  • Program: Initializing business operations calendar
  • Program: Calendar pseudo-array lookup (1st edition)
  • Program: Visual calendar
  • Program: Interpreting a visual calendar
  • Program: Converting a list of changes to a list of days
• 56. Multiple Text Files
• 57. Print Files
• 58. Table Reports
  • Test data: Volcanoes
  • Program: Simple detail report from REPORT procedure
  • Program: Advanced detail report from REPORT procedure
• 59. Summary Reports
  • Program: Summary report from REPORT procedure
  • Program: Summary report from TABULATE procedure
• 60. Data Step Views
• 61. Macro Variables
• 62. Macros
• 63. Macro Programming
• 64. Program Parameters
  • Program: Create macro variables from parameter file
  • Program: Converting variables to macro variables
  • Online program: Parameter window
• 65. Generating Program Statements
• 66. Control Reports
• 67. Cleanup
• 68. Efficiency
  • Online program: Storage management report
• 69. ODS
• 70. ODS Objects
• 71. ODS Destinations
• 72. HTML
• 73. ODS Style
• 74. Pages and Printing
• 75. XML
• 76. The XML Engine
• 77. Tagsets
• 78. Internet Services
• 79. Spreadsheets
• 80. Word Processing and Email
• 81. Text Processing
  • Program: Standardized addresses (thesaurus)
  • Program: Name matching
• 82. Text Analysis
  • Text data: Thoreau paragraph
  • Program: Text analysis
• 83. Random Numbers
• 84. Simulations
  • Program: Risk (stochastic simulation)
  • Program: Risk (exhaustive simulation)
• 85. Data Center Techniques
• 86. Porting Files and Data
• 87. Porting SAS Programs
• 88. Classic Problems
  • Program: Prime number sieve
  • Program: Sudoku
  • Program: Synthesizer
  • Online program: Life
  • Online text data: Global places
  • Online program: Global distances
• Afterword
• Index