Why SAS ? why not others

Advantages of using SAS

Major components of SAS suite

SAS windows

Ascending/Descending

Removing duplicates using options

Storing duplicates

Use COLUMN, FORMATTED and LIST input to read raw data files.

Use INFILE statement options to control processing when reading raw data files.

Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls.

SAS libraries: Creating temporary and permanent libraries

Options to read raw data: Missover, Truncover ,DSD,DLM

SAS DATA Step Processing – Compilation Phase and Execution Phase

Program Data Vector (PDV)

SAS dataset: data and descriptor portions

Understanding how SAS files are stored

Differences between system options, data set options and statement options

Informats, Formats, Attrib, Datalines, Delete, Drop, Keep, Label, Length, Retain, Sum, Dim

Data set options: KEEP, DROP, RENAME, FIRSTOBS, OBS, IN, LABEL, WHERE

SAS System Options – OBS, FIRSTOBS, BUFNO, BUFSIZE, LINESIZE,PAGESIZE, NODATE, YEARCUTOFF

INPUT and PUT

Character Functions

Numeric Functions

Date Functions

Subsetting IF

IF-THEN/ELSE statement

DO statement

DO UNTIL statement

DO WHILE statement

FTP thru SAS

Connect to different servers (SQL server etc)

Export data to create standard and comma-delimited raw data files

SET and MERGE Statements

MODIFY and UPDATE Statements

WHERE Statement and differences with IF

RETAIN and RETURN Statements

Proc Freq, Proc Print, Proc Sort, Proc Means, Summary, Copy, Proc Report, Proc Import/Export, Proc Format, Proc Append, Proc Contents, Proc Rank, Proc Transpose, Proc Tabulate, Proc compare

Storing SAS Macros

Defining and Calling Macros

Referencing Macro Variables

Macro Parameters

Macro Quoting Technique

Macro Debugging Technique

Select statement

Sorting

Subset the data

Joins (Inner, left, right, Full...)

Identify and resolve programming logic errors

Recognize and correct syntax errors