Input and Infile: Building a SAS Data Set from Raw Data

**Function and
syntax of DATA statement**

**Reading raw
data separated by spaces**

**Reading
data arranged in columns**

**Reading
column data that require informats**

**What goes
on in the Data step?**

**The
results of this code after compile time**

**The
results of this code during run time**

**Results at
the end of the first execution pass through the data set**

**Results at
the end of the last execution pass through the data set**

**Other
examples using list input**

**Using
informats with list input**

**Running
the above code illustrates this common situation.**

**Syntax of
the INFORMAT statement**

**Reading
multiple records (lines) per observation**

**Advanced
variable/informat lists**

**Reading a
mixture of record types: conditional input**

**Other forms
of the IF-THEN statement**

**Style issues
in use of the IF-THEN statement**

**Example 2:
The SELECT-WHEN structure**

Reading and combining SAS data set

**Review:
Building SAS data sets**

**Using a
permanent SAS data set**

**What if
the variables are in a different order?**

**What if
the variable names don't match?**

**Differences
between subsetting IF and WHERE**

**Allowable
expressions in the WHERE statement**

**Using
WHERE in Proc statements**

**Use of the
Drop or Keep statements**

**Use of
Drop= or Keep= data set options**

**Using both
forms of Subsetting - Error?**

**Failure of
the simple one-to-one Merge**

**Possible
problems: Data sets not sorted**

**Possible
problems: Missing observations**

**Possible
problems: Identical variable names**

**Data set
option: Rename syntax**

**Creating
more than one data set with a single data step**

**Splitting
one SAS data set into two data sets**

Precision of Numeric Variables

**Example 1:
Mathematical Transformations**

**Example 4:
Statistical Functions**

**Example 6:
Conversion of numeric values to character values**

**Example 5:
Conversion of character values to numeric values**

**Example 3:
Rounding and truncating**

**Example 2:
Subsetting every nth Observation**

**Example 8:
Operations on Character Values**

**Example 10:
Reading Fields with a combination of Numeric and Character values**

**Large Data Sets
- It is worth the effort to be efficient?**

**Avoiding
Unnecessary DATA Steps**

**Selecting
Records with an IF statement: When do you use it?**

**Using a
WHERE Statement to Select Records from a SAS Data Set**

**Dropping
Unnecessary Variables When Building a SAS Data Set from Raw Data**

**Dropping
Unnecessary Variables When Building a SAS Data Set from Raw Data**

**Review
These Ideas (we've covered them before)**

**Logical
Comparisons: Multiple OR Operators versus the IN Operator**

**Appending
Data with a Data Step**

**Appending
Data with Proc Append**