SAS Base Programming On The Job Support By The Trainer Through Email

SAS Base Programming On the Job Support by the Trainer through Email

Course Content:

Introduction to SAS:

• Introduction to Base SAS, Installation of SAS tool, Getting started with SAS, various SAS Windows - Log, Explorer, Output, Search, Editor, etc. working with data sets, overview of SAS Functions, Library Types and programming files

SAS Enterprise Guide:

• Import/Export Raw Data files, reading and sub setting the data set, various statements like WHERE, SET, Merge
• Hands-on Exercise - Import Excel file in workspace, Read data, Export the workspace to save data

SAS Operators & Functions:

• Various SAS Operators - Arithmetic, Logical, Comparison, various SAS Functions - NUMERIC, CHARACTER, IS NULL, CONTAINS, LIKE, Input/Put, Date/Time, Conditional Statements (Do While, Do Until, If, Else)
• Hands-on Exercise - Apply logical, arithmetic operators and SAS functions to perform operations.

Compilation & Execution:

• Understanding about Input Buffer, PDV (Backend), learning what is Missover

Using Variables:

• Defining and Using KEEP and DROP statements, apply these statements, Format and Labels in SAS.
• Hands-on Exercise - Use KEEP and DROP statements

Creation and Compilation of SAS Data sets:

• Understanding Delimiter, dataline rules, DLM, Delimiter DSD, raw data files and execution, list input for standard data.
• Hands-on Exercise - Use delimiter rules on raw data files

SAS Procedures:

• The various SAS standard Procedures built-in for popular programs - PROC SORT, PROC FREQ, PROC SUMMARY, PROC RANK, PROC EXPORT, PROC DATASET, PROC TRANSPOSE, , PROC CORR etc.
• Hands-on Exercise - Use SORT, FREQ, SUMMARY, EXPORT and other procedures

Input statement and formatted input:

• Reading standard and non-standard numeric inputs with Formatted inputs, Column Pointer Controls, Controlling while a record loads, Line pointer control / Absolute line pointer control, Single Trailing , Multiple IN and OUT statements, DATA LINES statement and rules, List Input Method, comparing Single Trailing and Double Trailing.
• Hands-on Exercise - Read standard and non-standard numeric inputs with formatted inputs, Control while a record loads, Control a Line pointer, Write Multiple IN and OUT statements

SAS FORMAT:

• SAS FORMAT statements - standard and user-written, associating a format with a variable, working with SAS FORMAT, deploying it on PROC Data sets, comparing ATTRIB and FORMAT statements.
• Hands-on Exercise - Format a variable, deploy format rule on PROC DATA set, Use ATTRIB statement

SAS Graphs:

• Understanding PROC GCHART, various Graphs, Bar Charts - Pie, Bar, 3D, plotting variables with PROC GPLOT.
• Hands-on Exercise - Plot graphs using PROC GPLOT Display charts using PROC GCHART

Interactive Data Processing:

• SAS advanced data discovery and visualization, point-and-click analytics capabilities, powerful reporting tools.

Data Transformation Function:

• Character Functions, Numeric Functions, Converting Variable Type.Hands-on Exercise - Use Functions in data transformation

Output Delivery System (ODS):

• Introduction to ODS, Data Optimization, How to generate files (rtf, pdf, html, doc) using SAS
• Hands-on Exercise - Optimize data, generate rtf, pdf, html and doc files

SAS MACROS:

• Macro Syntax, Macro Variables, Positional Parameters in a Macro, Macro Step
• Hands-on Exercise - Write a macro, Use positional parameters

PROC SQL:

• SQL Statements in SAS, SELECT, CASE, JOIN, UNION, Sorting Data
• Hands-on Exercise - Create sql query to select and add a condition
• Use a CASE in select query

Advanced Base SAS:

• Base SAS web-based interface and ready-to-use programs, advanced data manipulation,
• storage and retrieval, descriptive statistics.
• Hands-on Exercise - Use web UI to do statistical operations

Summarization Reports:

• Report Enhancement, Global Statements, User-defined Formats, PROC SORT, ODS Destinations, ODS Listing, PROC FREQ, PROC Means, PROC UNIVARIATE, PROC REPORT, PROC PRINT
• Hands-on Exercise - Use PROC SORT to sort the results, List ODS, Find mean using PROC Means, print using PROC PRINT