SAS

2567 Satisfied Learners

Best SAS Training in Pune India

Corporate Training & Class room Training

Duration of Training: 4 days.

SAS Syllabus

1. Introduction

Advantages of using SAS

Major components of SAS suite

SAS windows

 

2. Accessing Data in SAS

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 permanant libraries

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

 

3. Behind the scene

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

 

4. SAS statements

Differences between system options, data set options and statement options

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

 

5. SAS Options

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

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

 

6. SAS Functions

INPUT and PUT

Functions for Date and Time – MONTH, YEAR, DAY, MDY, DATE, TODAY, DATETIME

Other SAS functions – SCAN, SUBSTR, TRIM, LEFT, RIGHT, INDEX, UPCASE, LOWCASE, MEAN, COMPRESS, LENGTH

 

7. Arrays

Creating variables using Arrays

Assigning Initial Values to Arrays

Multidimensional Array

 

8. Conditional Processing

Subsetting IF

IF-THEN/ELSE statement

DO statement

Nesting of the DO Loop

DO UNTIL statement

DO WHILE statement

 

9. Connecting to outside world

FTP thru SAS

Connect to different servers (SQL server etc)

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

 

10. Merging & Appending Data

SET and MERGE Statements

MODIFY and UPDATE Statements

WHERE Statement and differences with IF

RETAIN and RETURN Statements

 

11. Analysis and report generation: SAS Procedures

Proc Print, Proc Sort, Proc Means and Proc Contents

Enhance reports through the use of user-defined formats, titles, footnotes

 

12. SAS Macros

Storing SAS Macros

Defining and Calling Macros

Referencing Macro Variables

Macro Parameters

Macro Quoting Technique

Macro Debugging Technique

 

13. Error Handling

Identify and resolve programming logic errors.

Recognize and correct syntax errors.

 

 

Our Courses

Drop A Query