Professional Sas Programming Logic

by Aster, Rick

• ISBN13: 9781891957055
• ISBN10: 1891957058
• Format: Paperback
• Copyright: 2000-11-01
• Publisher: Breakfast Communications Corp

Table of Contents

Introduction	7	(4)
SAS Programming	11	(24)
Running a SAS Program	11	(8)
The SAS Environment	19	(5)
Objects and Names	24	(7)
Programming Concepts	31	(4)
The SAS Way: Examples	35	(26)
From Fixed-Field Text Data to Analysis	35	(13)
List Input and Concatenation	48	(7)
Computation	55	(6)
Statements and Steps	61	(18)
Things to Look For---and What They Mean	61	(10)
Steps and SAS Datasets	71	(2)
Data Steps	73	(6)
Control Flow	79	(32)
Logical Constructions	79	(10)
Shaping the Observation Loop	89	(18)
Outside Connections	107	(4)
Variables and Values	111	(24)
Variables and Attributes	111	(8)
Data Types	119	(5)
Values	124	(11)
Constants and Expressions	135	(14)
Constants	135	(2)
Expressions	137	(1)
Operators	138	(8)
Function Calls	146	(3)
Special Kinds of Values	149	(12)
Missing Values	149	(3)
Values That Measure Time	152	(6)
Bitfields	158	(1)
Double Byte Character Set Data	159	(2)
Loops and Arrays	161	(16)
Arrays	161	(6)
Loops	167	(7)
Programming With Loops and Arrays	174	(3)
I/O	177	(14)
Storage and Other Devices	177	(4)
Names for Files	181	(6)
Engines and SAS Dataset Access	187	(4)
SAS Dataset I/O	191	(20)
Input SAS Datasets in the Data Step	191	(15)
Creating SAS Datasets in the Data Step	206	(2)
Updating a SAS Dataset in the Data Step	208	(2)
SAS Datasets in the Proc Step	210	(1)
Options for SAS Datasets	211	(24)
Dataset Options	211	(5)
Modifying SAS Datasets	216	(2)
Indexes	218	(5)
Integrity Constraints	223	(3)
Generation Datasets	226	(1)
Passwords	227	(2)
Audit Trails	229	(2)
SAS Dataset Information	231	(2)
System Options for SAS Files	233	(2)
Text File I/O	235	(42)
Selecting Files and Setting Options	236	(7)
Terms for Processing Records	243	(6)
Processing Input Records	249	(11)
Processing Output Records	260	(9)
Delimited Files	269	(2)
Fixed-Field Files	271	(2)
Binary Files	273	(1)
Updating a Text File	274	(1)
Data Step Windows	275	(2)
Informats and Formats	277	(38)
Character Fields	281	(5)
Numeric Fields	286	(9)
Binary Fields	295	(5)
Time Fields	300	(10)
Using Informats and Formats	310	(5)
Print Output	315	(16)
Print Files and Pages	315	(3)
Writing Print Files in the Data Step	318	(2)
Output Objects and ODS	320	(6)
Proc Step Output	326	(5)
Functions and CALL Routines	331	(38)
Mathematical Functions	333	(13)
Character Functions	346	(12)
Time Computation	358	(6)
Other Categories of Functions	364	(5)
Low-Level I/O Programming	369	(20)
SAS Dataset I/O Functions	373	(9)
Text File I/O Functions	382	(6)
Directory I/O Functions	388	(1)
Execution	389	(42)
The Execution Process	389	(12)
Messages and Error Handling	401	(6)
Session	407	(19)
Variability of the SAS Environment	426	(5)
Macro Language	431	(16)
The Objects of Macro Language	431	(9)
Macro Expressions	440	(4)
System Options for Macro Language	444	(1)
User Parameters	445	(2)
Proc Steps	447	(14)
Proc Step Syntax	447	(4)
Proc Step Execution	451	(4)
Summary Statistics	455	(2)
Sorting	457	(4)
Reporting	461	(18)
Print	461	(6)
Report	467	(12)
Analysing Data	479	(22)
Summary	479	(9)
Tabulate	488	(5)
Univariate	493	(2)
Report	495	(2)
Freq	497	(2)
Corr	499	(2)
Managing Data	501	(8)
Sort	501	(1)
Copy	502	(1)
Append	503	(1)
Catalog	504	(1)
Compare	505	(1)
Transpose	506	(3)
Sql	509	(20)
Query Expressions	511	(9)
Database Management Actions	520	(5)
Sql Execution	525	(4)
Creating Formats and Informats	529	(22)
The Proc Format Step	529	(5)
Value Formats	534	(3)
Value Informats	537	(3)
Picture Formats	540	(5)
Managing Stored Formats and Informats	545	(6)
Glossary	551	(13)
Index	564