Professional SAS Programming Shortcuts

Rick Aster: Professional SAS Programming Shortcuts

About Online Files

Introduction
1. The Log
- Program: Multi-purpose terminator
2. Program Files
3. Startup
4. System Options
5. Libraries
6. Dataset Options
7. Indexes
8. Actions on SAS Datasets
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
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
18. Format Catalogs and Control Datasets
- 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
- 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 dataset
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
- Program: Summary report from REPORT procedure
- Program: Summary report from TABULATE procedure
59. Data Step Report Programming
- Program: Loan payment schedule (ODS table)
- Program: Simple data step text table
- Program: Data step text table with features
- Program: Alternate report when SAS dataset has no observations
60. Data Step Views
61. Macro Variables
62. Macros
63. Macro Programming
64. Program Parameters
- Program: Create macro variables from parameter file
- Program: Parameter window
- Program: Converting variables to macro variables
65. Generating Program Statements
66. Control Reports
67. Cleaning Up a Program
68. Macro Cleanup
69. Efficiency
70. Saving Storage Space
71. Compression
- Program: Storage management report
72. Porting Files and Data
73. Porting SAS Programs
74. Translating Programs
75. Style
76. Data Step Windows
- Program: Arithmetic
- Program: Contest (data entry)
- Program: Editing a SAS dataset
- Program: Animated progress bar
77. Macro Windows
- Program: SAS environment
- Program: Parameter window
- Program: Changing system options
78. Interactive Line Mode
- Program: Arithmetic
79. Menu Bars
- Program: Menu bar
- Program: Menu bar with dialog boxes
80. Command Processing
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
- Text data: Risk (stochastic simulation)
- Program: Risk (exhaustive simulation)
85. Legacy Systems
86. Database Applications
87. Client-Server Design
88. Classic Problems
- Program: Prime number sieve
- Program: Life
- Text data: Global places
- Program: Global distances
Afterword
Index

Contents

Global
Statements

RICK ASTER

SAS

BOOKS

Tech | Dictionary

Download | Rastinate

Rick Aster

Professional SAS Programming Shortcuts

Contents/Online Files

Corrections

Catalog Page