Professional SAS Programming Shortcuts

by Aster, Rick

• ISBN13: 9781891957116
• ISBN10: 1891957112
• Edition: 2nd
• Format: Paperback
• Copyright: 2005-04-30
• Publisher: Breakfast Communications Corp

Summary

In just three years, Professional SAS Programming Shortcuts became SAS programmers' favorite book of tips, techniques, and algorithms. The new 2nd edition is updated and redesigned to provide quicker access to how-to instruction and thousands of examples of common data processing techniques done in SAS, including many not described in any other book.

Table of Contents

Lists	8	(1)
Introduction	9	(2)
The Log	11	(6)
Running a SAS Program
Messages and Debugging
Program Files	17	(3)
Startup	20	(5)
Batch and Interactive Modes
SAS Processes
System Options	25	(8)
Setting System Options
Obtaining Values of System Options
Libraries	33	(3)
Dataset Options	36	(4)
Indexes	40	(3)
Actions on SAS Datasets	43	(8)
Creating
Describing
Changing
Copying
Deleting
Data Type and Length	51	(4)
Text Data Files	55	(5)
Filerefs
Input Text Data
Output Text Data
Data Fields	60	(7)
Scientific Notation
Signed Numerals
Implied Decimal Points
Measured Strings
Variable Number of Fields
Continuation Character
Delimited Files	67	(4)
Hierarchical Files	71	(5)
Input
Output
Binary Files	76	(4)
Value Formats	80	(4)
Value Informats	84	(3)
Picture Formats for Numbers	87	(3)
Format Catalogs and Control Datasets	90	(9)
Format Catalogs
Control Datasets
Time	99	(5)
Informats and Formats for Time	104	(4)
International Date Formats	108	(2)
Picture Formats for Time	110	(3)
Validation	113	(8)
Informats and Error Controls
Validation Logic
Integrity Constraints
Strings	121	(9)
Measuring and Testing Strings
String Transformations
Substrings and Concatenations
Parsing	130	(3)
Variable-Length Strings	133	(4)
Terminated Strings
Measured Strings
Pascal Strings
Foreign Data Types	137	(5)
Codes	142	(7)
Code I/O and Conversions
Serial Numbers and Check Digits
Text Encryption	149	(2)
Character Substitution
Transposition
Discrete Binary Encoding	151	(4)
Bitfields	155	(3)
Numeric Effects	158	(4)
Rounding
Range Effects
Percents
Testing Numbers
Missing Values	162	(5)
Boolean Values	167	(4)
Financial Calculations	171	(5)
Time Conversions	176	(6)
Points in Time
Duration
Clock Issues
Time Arithmetic	182	(7)
Comparisons
Rounding
Time Loops
Time Interval Arithmetic
Age
Extending the Observation Loop	189	(4)
Loops	193	(5)
Character Loops	198	(4)
Subsetting and Sampling	202	(6)
Subsetting
Sampling
SQL	208	(4)
Sorting	212	(7)
Groups	219	(7)
BY Groups in Proc Steps
Formatted Grouping
Class Groups
Processing Groups in a Data Step
Incomplete Data	226	(6)
Key Combinations and Sequences
Interpolation
Transposing	232	(6)
Transposing in a Data Step
The Transpose Procedure
Frequency Tables	238	(7)
Descriptive Statistics	245	(6)
Creating Summary Data
Summary Statistics in Computations	251	(2)
Type Conversion	253	(3)
Combining Data	256	(5)
Table Lookup	261	(5)
Lookup Expressions
Lookup Arrays
Hash Objects for Lookup
Table Lookup From SAS Data Files	266	(6)
Value Formats for Table Lookup	272	(4)
Calendars	276	(6)
Multiple Text Files	282	(3)
Input
Output
Print Files	285	(8)
Print Files in the SAS Environment
Title and Footnote Lines
Print Output in Data Steps
Print Output in Proc Steps
Table Reports	293	(8)
Print
Report
Summary Reports
Tabulate
ODS
Data Step Report Programming	301	(9)
ODS Tables
Text Tables
Data Step Views	310	(2)
Macro Variables	312	(5)
Assigning Values
Obtaining Values
Macros	317	(8)
Parameters
Macro Control Flow
Managing Macros
Macro Programming	325	(5)
Macro Expressions
Macro Functions
Macro Statements
Avoiding Errors in Macro Programming
Program Parameters	330	(3)
Generating Program Statements	333	(4)
Control Reports	337	(4)
Cleaning Up a Program	341	(4)
Macro Cleanup	345	(3)
Efficiency	348	(6)
Saving Storage Space	354	(5)
Observation Length
Number of Observations
Saving and Deleting Data
Compression	359	(4)
Porting Files and Data	363	(5)
Porting SAS Programs	368	(5)
Dependencies
Isolating Nonportable Code
Translating Programs	373	(2)
Style	375	(2)
Data Step Windows	377	(7)
Macro Windows	384	(3)
Interactive Line Mode	387	(2)
Menu Bars	389	(5)
Command Processing	394	(2)
Text Processing	396	(9)
Names and Alphabetic Keys
Words
Name Matching
Text Analysis	405	(5)
Random Numbers	410	(3)
Random Number Streams
Random Number Functions and Call Routines
Distributions for Random Numbers
Simulations	413	(5)
Legacy Systems	418	(4)
Data Center Files
Older SAS Versions
Database Applications	422	(4)
Database Design
Database Programming
Metadata
Client-Server Design	426	(4)
SAS/Connect
Control Level
Classic Problems	430	(7)
Prime Number Sieve
Life
Global Distances
Afterword	437	(1)
Index	438