Professional SAS Programming Shortcuts
Over 1,000 ways to improve your SAS programs
Author: Rick Aster
Publisher: Breakfast
For programmers who expect to be able to do anything they can imagine with data, whether it’s simple or complicated, this book presents over 1,000 specific techniques with quick explanations and examples. If you want to see how it’s done in SAS, this book covers everything from data types to table lookup.
3rd Edition (Paperback)
Year: 2012
ISBN: 978-1-891957-19-2
Pages: 400
Publisher’s list price: 45.00
Contents
- Introduction
- 1. The Log
- 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
- 10. Text Data Files
- 11. Data Fields
- 12. Delimited Files
- 13. Hierarchical Files
- 14. Binary Files
- 15. Value Formats
- 16. Value Informats
- 17. Picture Formats for Numbers
- 18. Format Catalogs and Control Data Sets
- 19. Time
- 20. Informats and Formats for Time
- 21. International Date Formats
- 22. Picture Formats for Time
- 23. Validation
- 24. Strings
- 25. Parsing
- 26. Variable-Length Strings
- 27. Foreign Data Types
- 28. Codes
- 29. Text Encryption
- 30. Discrete Binary Encoding
- 31. Bitfields
- 32. Numeric Effects
- 33. Missing Values
- 34. Boolean Values
- 35. Financial Calculations
- 36. Time Conversions
- 37. Time Arithmetic
- 38. Extending the Observation Loop
- 39. Loops
- 40. Character Loops
- 41. Subsetting and Sampling
- 42. SQL
- 43. Sorting
- 44. Groups
- 45. Incomplete Data
- 46. Transposing
- 47. Frequency Tables
- 48. Descriptive Statistics
- 49. Summary Statistics in Computations
- 50. Type Conversion
- 51. Combining Data
- 52. Table Lookup
- 53. Table Lookup From SAS Data Files
- 54. Value Formats for Table Lookup
- 55. Calendars
- 56. Multiple Text Files
- 57. Print Files
- 58. Table Reports
- 59. Data Step Report Programming
- 60. Data Step Views
- 61. Macro Variables
- 62. Macros
- 63. Macro Programming
- 64. Program Parameters
- 65. Generating Program Statements
- 66. Control Reports
- 67. Cleanup
- 68. Efficiency
- 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
- 82. Text Analysis
- 83. Random Numbers
- 84. Simulations
- 85. Data Center Techniques
- 86. Porting Files and Data
- 87. Porting SAS Programs
- 88. Classic Problems
- Afterword
- Index
From the front cover
Code like a SAS programming expert
Solve problems in moving and managing data
Understand the world’s favorite business intelligence software
From the back cover
The most valuable collection of SAS programming tips, techniques, and algorithms ever assembled in one book!
This way to expert SAS knowledge! Why spend hours or days figuring out how to approach a SAS programming problem . . . when it’s all been done before? The answers you need are here: simple explanations of the essential building blocks of SAS code, illustrated with more than 1,000 examples.
Get there faster! The book’s 88 chapters are organized by subject to make it easy to find programming techniques for the everyday tasks of working with business and scientific data. With the carefully engineered and tested solutions you’ll find throughout the book, you’ll avoid mistakes and write better SAS programs faster.
Award-winning SAS expert Rick Aster provides all the information you need to:
- Read and write virtually any kind of data file.
- Program with strings, codes, numbers, dates, binary values, and more.
- Create cross-platform applications and transport data between computing environments.
- Process text values and analyze text documents.
- Create and use lookup tables, and extract and combine data in any way you can imagine.
- Write accurate, efficient programs for working with data.
. . . and much more!
In Rick Aster’s prolific SAS programming career, he has applied his skills to problems in business, research, and government, delving into subjects from economic forecasting to drug safety. Always an advocate of professional computer programming practices in SAS work, Rick has carried this approach over into his many successful books on SAS programming, including the popular Professional SAS Programmer’s Pocket Reference.
2nd Edition (Paperback)
Year: 2005
ISBN: 1-891957-11-2
Pages: 448
Publisher’s list price: 40.00
Contents
- Introduction
- 1. The Log
- 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
- 10. Text Data Files
- 11. Data Fields
- 12. Delimited Files
- 13. Hierarchical Files
- 14. Binary Files
- 15. Value Formats
- 16. Value Informats
- 17. Picture Formats for Numbers
- 18. Format Catalogs and Control Datasets
- 19. Time
- 20. Informats and Formats for Time
- 21. International Date Formats
- 22. Picture Formats for Time
- 23. Validation
- 24. Strings
- 25. Parsing
- 26. Variable-Length Strings
- 27. Foreign Data Types
- 28. Codes
- 29. Text Encryption
- 30. Discrete Binary Encoding
- 31. Bitfields
- 32. Numeric Effects
- 33. Missing Values
- 34. Boolean Values
- 35. Financial Calculations
- 36. Time Conversions
- 37. Time Arithmetic
- 38. Extending the Observation Loop
- 39. Loops
- 40. Character Loops
- 41. Subsetting and Sampling
- 42. SQL
- 43. Sorting
- 44. Groups
- 45. Incomplete Data
- 46. Transposing
- 47. Frequency Tables
- 48. Descriptive Statistics
- 49. Summary Statistics in Computations
- 50. Type Conversion
- 51. Combining Data
- 52. Table Lookup
- 53. Table Lookup From SAS Data Files
- 54. Value Formats for Table Lookup
- 55. Calendars
- 56. Multiple Text Files
- 57. Print Files
- 58. Table Reports
- 59. Data Step Report Programming
- 60. Data Step Views
- 61. Macro Variables
- 62. Macros
- 63. Macro Programming
- 64. Program Parameters
- 65. Generating Program Statements
- 66. Control Reports
- 67. Cleaning Up a Program
- 68. Macro Cleanup
- 69. Efficiency
- 70. Saving Storage Space
- 71. Compression
- 72. Porting Files and Data
- 73. Porting SAS Programs
- 74. Translating Programs
- 75. Style
- 76. Data Step Windows
- 77. Macro Windows
- 78. Interactive Line Mode
- 79. Menu Bars
- 80. Command Processing
- 81. Text Processing
- 82. Text Analysis
- 83. Random Numbers
- 84. Simulations
- 85. Legacy Systems
- 86. Database Applications
- 87. Client-Server Design
- 88. Classic Problems
- Afterword
- Index
1st Edition (Paperback)
Year: 2002
ISBN: 1-891957-06-6
Pages: 608
Publisher’s list price: 55.00
Contents
(the same as the 2nd edition)
From the front cover
The most valuable collection of SAS programming tips, techniques, and algorithms ever assembled in one book!
