Radical Technologies
  • Starting Data Science and Analytics with Spark, Scala ,R and Python…Devops with- Chef Puppet Docker Ansible Salt Stack Jenkins Git Nagios Jira….VMWARE VCP 5.5 + 6.0 and 6.5 On Cisco UCS Server ….AWS | Salesforce | Openstack | Azure – Implementation,Migration  and  certification oriented Training …Windows SCCM And Server Deployment training with real time examples……Starting Training on Netapp Data Ontap Cluster Mode + 7.0 Mode…Appear for any RedHat Practical Exams at Any Time through KOALA-Redhat Systems…Discounted Oracle , Microsoft Exam Vouchers available….Exam Centres at Aundh & Kharadi in Pune, HSR Layout in Bangalore

  • 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.