get app
    Download Careers360 App
    • Home
    • Udemy
    • Courses
    • Complete SAS Programming Bootcamp 2019 go from Zero to Hero

    Complete SAS Programming Bootcamp 2019: Go from zero to hero

    BY
    Udemy

    Brochure Enquire
    Lavel

    Beginner

    Mode

    Online

    Fees

    ₹ 1499

    Quick Facts

    particular details
    Medium of instructions English
    Mode of learning Self study
    Mode of Delivery Video and Text Based

    Course and certificate fees

    Fees information
    ₹ 1,499
    certificate availability

    Yes

    certificate providing authority

    Udemy

    The syllabus

    Setting Up Your SAS Environment and Download the Data!

    • Setup your SAS Environment with SAS WPS Analytics
    • Setup your SAS Environment with SAS University Edition

    Welcome to the world of SAS!

    • What can you do with SAS?
    • What is a SAS Program? How does the syntax work in SAS?
    • SAS Libraries (Libname Statement)
    • What is a SAS Data Set? Proc Contents and Proc Print
    • Types of Variables in SAS
    • Filter data using the WHERE statement - Operators (Logic, Comparison, Arithmetic
    • Special Operators for the WHERE statement
    • What is a SAS Format?
    • Dates and Date Formats in SAS
    • Creating a user-defined format using Proc Format
    • Ordering data and creating reports by Groups using the BY statement
    • Improve the aesthetics of a report adding Titles, Footnotes, Labels.

    Data Manipulation I (Learn to use the powerful Data Step!)

    • Learn to read a SAS Data Set with the Data Step
    • Creating Variables and Filtering Variables with the KEEP & DROP statements
    • Difference between filtering with the WHERE and Subsetting IF statements
    • Adding Permanent Attributes using the LABEL, FORMAT, and LENGTH statements
    • How does Data Step Processing works?
    • Using simple functions and learning to get frequencies using PROC FREQ
    • Process data conditionally using IF-THEN/ELSE statements
    • Execute multiple statements conditionally using DO and END statements

    Summarizing Character and Numeric Data! (Proc Freq, Means, Univariate)

    • Summarize Character Data in Frequencies using Proc Freq!
    • Create Contingency Tables (2x2 table) with Proc Freq!
    • Summarize Numeric Variables with Proc Means (N Mean Median Std Min Max etc..)
    • Summarize Numeric Data (Proc Univariate: Quantiles, Central Tendency Measures)

    Importing Data (Excel, CSV, Tab) in different formats/structures

    • Using the PUT function to convert Numeric Variable to Character Variable
    • Using INPUT function and INFORMATS to convert Character to Numeric variables
    • Using PROC IMPORT to import different file formats (csv, xlsx, txt)
    • [Advanced] Other techniques to Read Data using Data Step
    • [Advanced] COLUMN INPUT technique to read data organized in columns
    • [Advanced] FORMATTED INPUT technique to read Non Standard data organized in columns
    • [Advanced] MODIFIED LIST INPUT technique to read delimited data (Non/Standard Data

    Data Manipulation II (Controlling Input and Output, Accumulating Totals & more!)

    • Writing Observations Explicitly (Output Statement)
    • Writing to Multiple SAS Data Sets
    • Optimize the processing using SAS Data Set Options (Firstobs=, obs=, Keep=)
    • More Data Set Options (Rename = , Where=)
    • Create an Accumulating Total Variable (Process data vertically - RETAIN statement)
    • Accumulating Totals for a Group of Data using the BY Statement and Data Step
    • Accumulating Totals for more than One Group using the By statement and Retain

    SAS Functions (Character & Numeric Functions)!

    • Character Functions to Extract Text ! (SUBSTR, LENGTH)
    • More functions to Extract Text from String! (RIGHT, LEFT, CHAR, PROPCASE)
    • More Character Functions (SCAN, INDEX, CATX, TRIM, STRIP)!
    • Character Functions to Concatenate Strings (CAT, CATT, CATS)!

    Working with Dates Values (Dates - , Datetime - , Time Values

    • Introduction to SAS Dates (Date Values - Datetime Values - Time Values)
    • Converting Dates stored in text (Character) to Date Values (Numeric)
    • Converting Date Values (Numeric) to text (Character)
    • Using the INTCK() function to calculate difference of 2 dates (in months, years)
    • Using INTNX() function to increment a date (in years, months, qtrs, days, etc)
    • Calculate difference between Dates using the DATDIF() function

    Learning to Combine Data (Concatenating and Merging/Joins)

    • Concatenate Data using the Set Statement in the Data Step - Part 1
    • Concatenate Data using the Set Statement in the Data Step - Part 2
    • Concatenate Data using Proc Append
    • Understand how data can be related (One-to-One, One-to-Many, Many-Many)
    • Using Merge to get all types of Joins (Left, Right, Inner, Full Join, etc)
    • Learn how to merge data in a One-to-One and One-to-Many Scenario
    • Warning on Merge Statement in a Many-to-Many scenario, use SQL instead.

    Do Loops - Processing Data Iteratively

    • Introduction to Do Loops (Iterative, Do Loop)
    • Business Scenario using Iterative, Do-Loops
    • Introduction to Infinite Loops (Do While and Do Until)
    • Business Scenario using Do While/Do Until
    • Solving a Business Scenario Using Iterative, Do Loops and Do While/Until
    • Learn to use Nested Do Loops to solve real problems!

    Working with Arrays and Learning to Transpose Data

    • Introduction to Arrays
    • Ways to reference Variable Lists in Arrays
    • Create and Compare different variables using Arrays
    • Using Arrays as a LookUp Table to make comparisons
    • Exercise 1 - Using Arrays to look for the Max Sale using INDEX and VNAME function
    • Exercise 2 - Using Arrays as a lookup Table to find Antibiotics in prescriptions
    • Using Arrays to Restructure a Dataset (Transpose and Stack Columns)
    • Intro to Proc Transpose (Easiest way to Transpose/Stack Columns in SAS)

    Pivot Tables in SAS using Proc Tabulate!

    • Introduction to Proc Tabulate
    • Creating the Structure of the Table: One- ,Two- , Three- Dimensional Tables
    • Creating the Structure of the Table: Concatenating and Crossing Variables
    • Adding Overall Summarizations using the Keyword ALL (Totals, SubTotals)
    • Adding Statistics to the Analysis Variables (Median, Quartiles, Percentiles)
    • Adding different Percentages (Column-, Row-, Report- Percentages)
    • Specify a denominator to calculate Percentages using keyword PCTN
    • Improve the Aesthetics changing Labels, KeyLabels, Formats
    • Adding Formats to Percentages and Customize missing Values
    • Creating a Professional Report with Proc Tabulate in 20 mins!

    Creating Reports with Proc Report!

    • Introduction to Proc Report - Variable Usages
    • Learn to Create Detail Report Using the Display and Order Usage
    • Learn to Create Summary Reports using the GROUP Usage and Add Statistics
    • Learn to Transpose a Variable with the Across Usage
    • Learn how to create a variable in a Report using the Computed Usage

    Similar Courses

    Programming in SAS for Beginners

    Udemy

    Online
    Beginner     ₹449 ₹3,499

    The Simplest Guide to SAS Programming SAS Base SAS...

    Udemy

    Online
    Beginner     ₹ 3,099

    SAS Programming BASE Certification Course for SAS ...

    Udemy

    Online
    Beginner     ₹ 3,499

    Getting Started with SAS Programming

    SAS Institute via Coursera

    8 Weeks Online
    Beginner

    Courses of your Interest

    Professional Certificate Course in Data Science

    Professional Certificate Course in Data Science

    Newton School

    8 Months Online
    Beginner

    JavaScript Foundations

    PW Skills

    Online
    Beginner     Free

    Technical Analysis Series

    PW Skills

    3 Months Online
    Beginner     Free

    C Programming Foundations

    PW Skills

    Online
    Beginner     Free

    Cracking the Coding Interview in Java Foundation

    PW Skills

    5 Months Online
    Beginner     Free

    Python Foundations

    PW Skills

    Online
    Beginner     Free
    Getting Started with Generative AI APIs

    Getting Started with Generative AI APIs

    Codio via Coursera

    3 Weeks Online
    Beginner
    Generating code with ChatGPT API

    Generating code with ChatGPT API

    Codio via Coursera

    3 Weeks Online
    Beginner
    Prompt Engineering for ChatGPT

    Prompt Engineering for ChatGPT

    Vanderbilt via Coursera

    Online
    Beginner

    More Courses by Udemy

    Microsoft Excel 2013 Course Beginners Intermediate...

    Udemy

    Online
    Beginner     ₹399 ₹2,699

    Instagram Bot with Python V2 Giveaway Instagram Bo...

    Udemy

    Online
    Beginner     ₹ 799

    Intro To Computer Science With Python and Jupyter ...

    Udemy

    Online
    Beginner     ₹ 799

    Python for Beginners to Advance

    Udemy

    Online
    Beginner     ₹ 2,499

    Learn Python Turtle Using Block Coding

    Udemy

    Online
    Beginner     ₹399 ₹799

    Master Python Basics For Developer

    Udemy

    Online
    Beginner     ₹475 ₹3,499

    Programming in Python for Beginners

    Udemy

    Online
    Beginner     ₹ 799

    Learn Python 3 Programming from Scratch

    Udemy

    Online
    Beginner     ₹475 ₹1,299

    Automate Your Life With Python

    Udemy

    Online
    Beginner     ₹ 2,899

    Learn Python Python for Beginners

    Udemy

    Online
    Beginner     ₹ 1,799

    Trending Courses

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Cyber Security Courses Programming Courses Data Science Courses Digital Marketing Courses Law Courses Mechanical Engineering Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses NPTEL Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close
    Download Careers360 App
    All this at the convenience of your phone

    • Regular Exam Updates

    • Best College Recommendations

    • College & Rank predictors

    • Detailed Books and Sample Papers

    • Question and Answers

    google play
    students
    400M+ Students
    Colleges
    36K+ Colleges
    Exams
    500+ Exams
    eBooks
    3K+ eBooks
    Certification
    16K+ Certifications
    mobile