Rick Aster: Professional SAS Programming Secrets: 3rd and 4th editions

Contents

About Online Files

Introduction: The Secret Is Out
1. SAS Does What You Tell It
- Program 1a: Very short and simple
- Program 1b: Hello, world
- Text data file 1c: Planet size data (CSV)
- Program 1d: Planet masses
2. First, Know the Data
- Text data file 2a: Gasoline inventory data (CSV)
- Program 2b: Attributes
3. It’s the Same As Any Language
- Program 3a: All-purpose terminator
4. One Step at a Time
- Text data file 4a: Dwarf planet size data (CSV)
- Program 4b: Planets vs. dwarf planets
5. Behind the Scenes
- Program 5a: Observation loop demonstration
- Program 5b: Array DO loop demonstration
- Program 5c: ROMAN informat
- Program 5d: Special values in value informats
- Program 5e: Value formats
- Program 5f: Picture format
- Program 5g: PCTCHG function
- Program 5h: PARENTHESIZE routine
- Program 5i: DOZEN format
6. Programs Make Decisions

Program 6a: Final actions

7. A File Is Nothing But Fields
- Text data file 7a: Elements and atomic weights (fixed-field)
- Program 7b: Reading a fixed-field text data file
- Program 7c: Writing a fixed-field text data file
- Program 7d: Reading an array
- Text data file 7e: North American broadcast television channels (space-delimited)
- Program 7f: List input
- Program 7g: $VARYING format
- Program 7h: Array of fields
- Program 7i: Copying a text file
- Program 7j: Removing line numbers
- Program 7k: Editing a text file
8. If You Can Express It, SAS Can Compute It
9. With a SAS Data Set, You Can Go Anywhere
- Program 9a: Simple proc steps
- Program 9b: Creating and changing variables (1)
- Program 9c: Creating and changing variables (2)
- Program 9d: Revising a SAS data set
- Program 9e: Revising a SAS data set as a view
- Program 9f: Revising and replacing a SAS data set
- Program 9g: Editing a SAS data set in place
- Program 9h: Exception data set
- Program 9i: Erase WORK library
- Program 9j: Copy of WORK library
- Program 9k: Copy with APPEND procedure
- Program 9l: Variables that are the same in every observation
- Program 9m: Changing the data type of a variable
- Text data file 9n: Crop data (space-delimited)
- Program 9o: Transposing
10. All Groups Are Treated Equally
- Text data file 10a: Design group data (CSV)
- Program 10b: Design group data
- Program 10c: FIRST. and LAST. variables
- Program 10d: Defining age groups in a SELECT block
- Program 10e: Age group value format
- Program 10f: Creating and deleting indexes
- Program 10g: Table lookup with index
- Program 10h: BY groups in PRINT procedure
- Program 10i: Duplicate observations
- Program 10j: Selecting one observation per BY group
- Program 10k: List of distinct values
- Program 10l: Concatenating and interleaving
- Program 10m: Match merging with one observation per BY group
- Program 10n: COMPARE procedure
- Program 10o: PROC SUMMARY report
- Program 10p: PROC SUMMARY output SAS data set
- Program 10q: Summary statistics in data step
- Program 10r: Percent of group
- Program 10s: Changing observation to group
- Program 10t: Changing group to observation
11. Two Data Types Are All You Need
- Program 11a: Rounding error
- Program 11b: TRUNC function for comparison
- Program 11c: Value formats for logical variables
- Program 11d: SAS date values
- Program 11e: Functions for SAS date values
- Program 11f: Checking the time
- Program 11g: Days, hours, minutes, and seconds
- Program 11h: INTNX function for the current time period
- Program 11i: Number of days in the month and year
- Program 11j: EIN, condensed to visual
- Program 11k: EIN, visual to condensed
12. Select and Analyze
- Program 12a: Earthquakes and moon phases: frequency tables and chi-squared test
- Program 12b: Statistic functions
- Program 12c: Arctic ice: t test
- Program 12d: Orbital bodies: 2-sample t test, homogeneity of variance, and simple linear regression
- Program 12e: Clustering orbital bodies
- Program 12f: Stochastic simulation of board game
- Program 12g: Exhaustive simulation of dice
13. Macros Make Big Decisions
- Program 13a: PRINTRESET macro
- Program 13b: Macro logic for no-data report
- Program 13c: Annotate data set from data step statements
- Program 13d: Annotate data set from Annotate macros
- Program 13e: Flexcode TITLE statement
- Program 13f: Flexcode VAR statement
- Program 13g: Changing the order of variables
14. SAS Output Is Ready for the World
- Program 14a: HTML destination
- Program 14b: Selection list
- Program 14c: Output destination
- Program 14d: Data step ODS table of SAS data set
- Program 14e: VARIABLES= suboption
- Program 14f: Aliases in the REPORT procedure
- Program 14g: Listing destination formatting options in the REPORT procedure
- Program 14h: Hidden order column
- Program 14i: COMPUTE block
- Program 14j: Detail report with summary lines in REPORT procedure
- Program 14k: Summary report in REPORT procedure
- Program 14l: Frequency table in REPORT procedure
- Program 14m: TABULATE procedure
- Program 14n: PROC TABULATE Listing output
- Program 14o: Style elements in the TABULATE procedure
- Program 14p: Word wrap
15. Use What You Know
16. Know Where You Are
- Program 16a: Copying rows from a DICTIONARY table
- Program 16b: Creating a macro variable from a DICTIONARY table
- Program 16c: DICTIONARY tables
- Program 16d: Localized text items
17. Ready to Go
- Program 17a: Parameter file
18. Simple Is Efficient
- Program 18a: Cleanup
- Program 18b: Reversing a SAS data file
Index

Global
Statements

RICK ASTER

SAS

BOOKS

Tech | Dictionary

Download | Rastinate

Rick Aster

Professional SAS Programming Secrets

Contents/Online Files

Corrections