Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Share

course photo

SAS

Rohini, Delhi

16,000

No Feedback Yet

No Reviews Yet
0 Interested

About the Course


Learning Objective:

Demonstrate an understanding and skills associated with Base & Advance SAS , including

Reading raw data
Transferring data across different software packages
Data manipulation
Data preparation
Generating reports & graphs
Computing variables and recoding data
Conducting data transformations on a subset of the data
Using iterative DO loops.
Using user-defined formats.
Working with SAS functions for date and time.
Analyzing subsets of the data
Merging and concatenating files
Conducting and interpreting basic statistics
Identify and correct errors

Topics Covered

Course Topics
1) SAS/Base
2) SAS/ODS
3) SAS/ GRAPH
4) SAS/ SQL
5) SAS/ MACROS
6) SAS/ STAT
7) SAS/ACCESS
1) SAS/BASE
I. Introduction
• Introduction SAS.
• Log File
• Output File
• Work File
• Permanent SAS datasets
• Environments where SAS runs
• SAS System Options
• Step boundaries and run-group processing
II. Advanced Input Features
• Where is my raw data?
• INFILE
• DATALINES
• Input statement
• Column INPUT
• Formatted INPUT
• List INPUT
• MISSOVER, DLM
• Informats with list INPUT
• :
• &
• Advanced input pointers
• Formatted lists with pointers
• Reading multiple line input
• Multiple INPUT statements
• / and # pointers
• The trailing @
• The double trailing @@
III. DATA step functions
• Character functions (Left, Tranwrd, Index,Find,Trim,catx,
Compress, Put, Input, Scan, Substr, Upcase, Lowcase Etc.)
• Numaric functions (Int, ceil, floor, Round, Min, Max, sum,
mean).
• Date Function (Todat, Datetime, Date, Time, Timepart, Day,
Month, Year, Qtr).
• Arrays
IV. SAS Structures and Flow
• Input and output
• DATA step overview
• Compile processing
• DATA
• LENGTH
• FORMATS, INFORMATS, LABELS
• RENAME
• RETAIN
• DROP and KEEP
• If, If- then, Else-if, If then Do.
• Reading existing SAS datasets with SET
V. SAS Executable Statements
• Assignment statements
• Numeric-character conversion
• Character concatenation
• Accumulating totals
• RETAIN and SUM
• SUM statement
• SELECT statement
• Subsetting observations
• Deleting observations
• Subsetting IF statement
• WHERE statement
• OUTPUT
• PUT
VI. Procedures
• Proc Print
• Proc Contents
• Proc Sort
• Proc Means
• Proc Freq
• Proc Report
• Proc Tabulate
• Proc Printto
• Proc Transpose
• Proc Format
• Proc Import
• Proc Export
• Proc Append
• Proc Summary
VII. SAS Do-loops
• Syntax
• How to create Do loops.
• Conditional Do loops(DO until, DO while, by clause).
• Nesting DO loops.
VIII. Merging SAS Datasets
• Syntax
• One to one merges
• Match merging
• Multiple OBS with the same BY variable
• Merging with identical variable names
• Merging without a common variable
• Update statement
2. SAS/ODS
• ODS /Trace/Select/Exclude
• ODS /HTML FILE
• ODS/PDF FILE
• ODS/RTF FILE
• ODS REPORT WITH STYLE OPTION.
3. SAS/GRAPH
• Proc PLOT
• Proc GPLOT
• Proc CHART
• Proc GCHART
4. SAS/SQL
• SQL/CREATE TABLE
• SQL/ALTER
• SQL/DROP
• SQL/INSERT
• SQL/UPDATE
• SQL/SELECT
• SQL/DELETE
• SQL/WHERE
• SQL/OPERATORS
• SQL/JOIN
• SQL/UNION
• SQL/ORDER BY
• SQL/GROUP BY
5. SAS/MACROS
X. An Introduction to SAS Macros
• Functions of the SAS macro processor
• Defining and using a macro
• Macro processor flow
• Macro and macro variable
• Local and global macro
• Avoid macro errors
• Positional macro parameters
• Automatic macro variables
• Call Symput
• System options for debugging macro
6. SAS/STATISTICS
• Proc UNIVARIATE
• Proc MEANS
• Proc FREQ
• Proc GLM
• Proc RANK
• Proc ANOVA
• Proc REG
• Proc TTEST (Paired)
• Proc CORR (correlation)
7. SAS/ACCESS
• How to connect with data server
• Libname Code
• Sql Code

Who should attend

Candidates interested for Data Analysis, Business Analysis, Market Research Analysis,

Pre-requisites

Graduate, having knoledge of Excel, VBA etc.

What you need to bring

Laptop if available.

Key Takeaways

Student will be expert on working SAS.
Content
Reviews
There are no Reviews yet.
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions


There are no Reviews yet.
cash back100% Money Back Guarentee

About the Trainer

Akshay picture

Akshay

Graduate


Trainer is SAS Certified and working on SAS domain with Banking Industries.

Course Id: 22248