Radical Technologies
  • News Update: - AWS Solution Architect Exam - Get 50 % Off before April 10th 2017.....Vmware VCP 6.0 + 6.5 Combo on High End Cisco UCS Servers ...Openstack Version 8.0 New Batch Registration Started ....Bigdata Hadoop - Experience Our Expertise ... Real 16 Node Hadoop Cluster Build on Amazon Cloud... Available Discounted Oracle Global Certification Vouchers...Aws , Salesforce, RHCSA , RHCE Sure Shot Exam Preparation Sessions....Mastering Devops .......Chef+Puppet+Docker+Ansible + Salt Stack + Jenkins +Git +Nagios +Jira......ServiceNow Combo.... Admin + Scripting and Implementation + Advanced administration.....Oracle Exadata Training on High End Cisco UCS Servers ....Congratulations to All RHCSA and RHCE Certified Students- Next RHCSA and RHCE Exam date- April 30th 2017.
  • COMBO COURSES

    RedHat Linux, Vitualization, Cloud, Hadoop,Datawarehousing Combo Courses with Discounted Price.....

    Readmore..

  • ONLINE TRAINING

    Radical Technologies provides best Online Training with Real-time Projects by Industry Experts....

    Online Schedule

  • BATCH SCHEDULE

    Best Classroom Training from Industry Consultants on High end Real-time Enterprise servers...

    Classroom Schedule

  • CERTIFICATIONS

    Authorized Exam Center for RedHat, Oracle, IBM, Microsoft, Cisco, Salesforce, AWS etc...

    Readmore..

SAS

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.