|
Course Contents:
BASIC SAS
SAS
Description
? Introduction Overview of SAS System and architecture
? Getting Started with SAS Understanding of SAS Environment and Program
? Getting familiar with SAS Data Libraries Understanding of SAS Datasets and SAS Libraries
? Producing List Reports Learn to produce simple Listing report using PRINT Procedure
? Understanding of SORT Procedure for ordering and sequencing of data
? Enhancing Output Producing enhanced and formatted report using FORMAT Procedure and ODS Statement
? Creating SAS Data Sets Creation of SAS Datasets from Non- SAS sources of data like, TXT, CSV, EXCEL and DAT files
? DATA Step Programming Processing data, creation of new variables based simple statistics
? Combining SAS Data Sets Merging / joining of datasets
? Producing Summary Report Learn to produce simple and complex summary report using REPORT Procedure
? Understanding of MEANS and FREQ Procedure to produce simple summary statistics report
? Understanding of PLOT and CHART Procedure to produce simple graphical outputs.
? Summarizing Data Processing and produce summarized data using SAS Functions and Statements r
? Data Transformations processing data with various SAS Character, Numeric and Date Functions.
ADVANCED SAS
SASSQL
SQL Processing with SAS System Descriptions
? Introduction Overview of using SQL tool within SAS
? Basics Queries Working with SELECT Statement for querying and datasets
? Combining Tables Merging / joining of datasets with advance concepts with SQL Joins approach using JOINS
? Clause and SET Operators
? Creating and Modifying Tables and Views Understanding of creating and modifying datasets, data views, and creating Index tables using CREATE TABLE, VIEWS and INDEX statement
.
SAS Macro Language Descriptions
SASMACRO
? Introduction Understanding of Macro Facility and SAS
? Program process flow.
? Macro Variables Using Automatic macro variables like, SYSDATE, SYSTIME, etc.,
? Creation of User Defined Macro Variables using %LET Statement
? Macro Definitions Understanding and creation of Macro definition using
% MACRO and passing parameters
Duration: 60 hours
Contact: Ashutosh on 8861301173, 9844172104.
M/s. Integrated Quality Training Institute
M - 17, 6th Main Road,
HAL 3rd Stage,
Jeevan Bheema Nagar,
Bangalore – 560 075,
Karnataka.
Www: iqtiedu.com, email id: info@iqtiedu.com
|
