Home Page Icon
Home Page
Table of Contents for
SAS® Macro Language Magic: Discovering Advanced Techniques
Close
SAS® Macro Language Magic: Discovering Advanced Techniques
by Robert Virgile
SAS Macro Language Magic
About This Book
About The Authors
Acknowledgments
Part 1: Preparation
Chapter 1: SAS Language Preparation
1.1 Keep It Simple
1.2 Keep Up with the Software
1.3 Experiment
Chapter 2: Shifting Gears: Macro Language
Part 2: Technique
Chapter 3: CALL EXECUTE
3.1 Basic Rules
3.2 Achieving the Impossible
3.3 Multiple CALL EXECUTEs
3.4 Finally, the Intricacies
3.5 Execute an Experiment
3.6 The Final Intricacy: Macro Variable Resolution
Chapter 4: %SYSFUNC
4.1 Basic Examples
4.2 Capturing the Program Name
4.3 Commas and Nested %SYSFUNCs
4.4 Achieving the Impossible, Revisited
4.5 Capturing Option Settings
4.6 Efficiency Considerations
4.7 A Final Example: ZIP Codes
Chapter 5: CALL SYMPUT
5.1 Leading and Trailing Blanks
5.2 A Similar Lesson, Using Recursion
5.3 Test Your Skill
5.4 Function Shifts in the Real World
5.5 A Key Issue: Extra Blanks
Chapter 6: INTO
6.1 SELECT Executes Immediately
6.2 Numeric-to-Character Conversion
6.3 SELECTing Multiple Values
6.4 DISTINCT Differences
6.5 How Many Macro Variables?
6.6 Zero Incoming Observations
6.7 An Unusual Application: Separated by Else
6.8 Dictionary Tables
6.9 Extremely Long Lists
6.10 Blanks vs. Nulls
Chapter 7: Macro Quoting
7.1 Why Quoting is Necessary
7.2 Why Quoting is a Nightmare
7.3 What Quoting Really Does
7.4 Peeking Inside the Black Box of Quoting
7.5 The Final Word on Quoting
Chapter 8: %LOCAL vs. %GLOBAL
8.1 Why Think %Locally?
8.2 Creating Symbol Tables and Macro Variables
8.3 Symbol Tables with CALL SYMPUT
8.4 Symbol Tables with CALL SYMPUTX
8.5 Choosing the Source Table
8.6 A Persisting Impact
Chapter 9: Arithmetic
9.1 Basic Rules
9.2 Truth in Numbers, Expressions, and Comparisons
Part 3: Execution
Chapter 10: Generating Text
10.1 Utilizing Generated Text
10.2 Counting Words in a String
10.3 Working with Lists
10.4 Prefer the Macro Solution
Chapter 11: Debugging
11.1 Store the Generated SAS Code
11.2 Control Diagnostic Messages
11.3 End When the Error Occurs
Chapter 12: Complexity vs. Simplicity
12.1 Building Job Security
12.2 Ease of Use
12.3 Checking Parameters
12.4 Portability
12.5 Complexity vs. Speed
12.6 Miscellaneous Applications
Chapter 13: A Final Illusion: Backtesting
13.1 The Preparation
13.2 The Steps
13.3 The Implementation
13.3.1 Programming Challenge
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
SAS® Macro Language Magic: Discovering Advanced Techniques
Next
Next Chapter
SAS® Macro Language Magic: Discovering Advanced Techniques
SAS
®
Macro
Language Magic
Discovering Advanced Techniques
Robert Virgile
support.sas.com/bookstore
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset
