Indepth Base SAS Programming Certification preparation Guide with Real Life Examples

Saurav Gupta, Love's playing with Data.......(Data Scientist)

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
65 Videos (3h 9m)
    • 1.0 Introduction to Section

      1:51
    • 1.1 Sas Defination

      1:46
    • 1.2 Sas Rulesx

      4:39
    • 1.3 Proc Step and Data Step Definations

      2:30
    • 1.4 Sas Data sets descriptor portion and Data portion

      2:52
    • 1.5 Sas Attributes in Brief

      3:00
    • 1.6 Sas Windows Environment.compressed

      3:14
    • 1.7 Good Programming Practices

      2:44
    • 2 Reading Data into a sas data set part1

      2:13
    • 2.1 Reading Instream Data lines.compressed

      4:46
    • 2.2 Sas Data Libraries

      5:52
    • 2.3 reading data into permanent data sets.compressed

      2:15
    • 2.4 reading from a raw data files.compressed

      3:45
    • 2.5 Reading COlumn Input Theory.compressed

      2:40
    • 2.6 Reading Column Input prac.compressed

      4:39
    • 2.7 Reading data from external data set.compressed

      3:35
    • 2.8 Summary1.compressed

      1:07
    • 3. Introduction

      0:55
    • 3.1 Sas Libraries and Contents procedure (Varnum)

      3:28
    • 3.2 List Input Theory

      1:32
    • 3.3 List input practical

      3:08
    • 3.4 Formatted input Theory

      4:15
    • 3.5 Formatted input practical

      5:27
    • 3.6 Sas System Options.compressed

      2:17
    • 4. Introduction

      3:42
    • 4.1 Basics of Assignment Statements

      6:51
    • 4.2 Numeric functions Theory

      0:55
    • 4.2x Numeric Functions Practical

      5:37
    • 4.3 Assigning Charater Variables

      2:51
    • 4.4 Conversion by use of Input Function

      4:50
    • 4.5 Summary

      0:32
    • 5. Intro

      1:13
    • 5.1 IF then Statements

      1:34
    • 5.2 Comparison Operator

      2:28
    • 5.3 Missing value (new)

      4:56
    • 5.3 Missing value

      5:20
    • 5.4 Greater Efficiency and Logical operator

      2:17
    • 5.5 AND Logical operator

      2:19
    • 5.6 Intervals-Mixed OR AND operator

      2:04
    • 5.7 Comparing Character Values

      2:53
    • 5.8 Performing Multiple Actions

      2:17
    • 6. Introduction

      2:08
    • 6.1 Basic reports

      2:08
    • 6.2 Identity statement

      2:12
    • 6.3 Firstobs and obs (Selecting Observations)

      1:15
    • 6.4 Where Statement (Selecting Observations)

      3:39
    • 6.5 Sorting observations

      4:49
    • 6.6 Column Totals

      2:16
    • 6.7 Subtotals by Sort procedure

      1:46
    • 6.8 creative sas programmer

      2:01
    • 6.9 Title and Footnote

      2:47
    • 6.10 Dm statement and Doble option

      1:44
    • 6.11 Descriptive Labels and Split option

      4:46
    • 6.12 Formatting data Values

      2:46
    • 7

      2:46
    • 7.1 Processing of SAS program

      1:04
    • 7.1x Step by Step Processing of SAS program(Practical)

      1:55
    • 7.2 Step by step processing (incorrect variable name)

      1:21
    • 7.3 Compilation Phase ( Raw data ) newvoice

      3:46
    • 7.4 Execution Phase

      7:13
    • 7.5 Error Messages

      1:17
    • 7.6 warnings messages

      0:48
    • 7.7 Note messages (Blue)

      2:06
    • 7.8 Good Programming Skills(new)

      4:04
    • 7.9 Put statement Testing Dataset

      1:19

About This Class

I am Happy to hear from my Premium Students that this course is helping them in preparing for Base SAS Certification Examination and Clearing a Job Interview. I am eagerly waiting for hearing, how this course helped you in gaining  success.

                                              @step by step approach for Complete Beginners

@ 150 + SAS Quality lectures            @ 150+SAS Demonstration Exercises         @ 350 + SAS Quizzes 

                                              @ 14 + SAS Practical Exercises (case Studies) with solution 

                                Prepare yourself for BASE SAS Certification Exam / SAS job Interview by

Learning Base SAS Programming step by step with Practical Examples by  Doing! 

- Useful for University students for Academics and Base SAS certification exam.

- Useful for Professionals and Programmer who want to dive into field of Big Data Analytics.

- No programming or technical knowledge required.

This course will start preparing you for that just from scratch for SAS Job and exam from Day 1.

  1. Concept Building Theory
  2. Demonstration of concepts just learned with Practical examples (that is, Learning SAS with examples)
  3. Knowledge testing Quizzes for almost all lectures
  4. Master Practice Exercise with Solution for almost all sections.
  5. Smart and Best approach ( short and trimmed lectures without wastage of time) will definitely yield Good Results. 

There are lots of lengthy Base SAS courses and lectures for beginners out there. However, SAS has a very steep learning curve and students often get overwhelmed. This course is different!

This course is truly step-by-step and without non sense time consuming  air-gaps and pausing activities.That makes this course Short and effective.

In every new tutorial we build on what had already learned and move one extra step forward.

After every video you learn a new valuable concept that you can apply right away. And the best part is that you learn through practical examples.

This training is packed with practical examples and Quiz challenges which will help you to learn and solve problems faced by real programmers in real world.

In summary, this course has been designed for all skill levels and even if you have no programming or statistical background you will be successful in this course!

I can't wait to see you in class,

Sincerely,

Saurav Gupta

Topics To be Covered in this course:

Accessing Data:
- Use 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.
- Create temporary and permanent SAS data sets.

Creating Data Structures:
- Create and manipulate SAS date values.
- Export data to create standard and comma-delimited raw data files.
- Control which observations and variables in a SAS data set are processed and output. 
- Investigate SAS data libraries using base SAS utility procedures.
- Sort observations in a SAS data set.
- Conditionally execute SAS statements.
- Use assignment statements in the DATA step.

Managing Data:
- Accumulate sub-totals and totals using DATA step statements.
- Use SAS functions to manipulate numeric data, and SAS date values.
- Use SAS functions to convert character data to numeric and vice versa.
- Process data using DO LOOPS.

Generating Reports:
- Generate list reports using the PRINT procedure.
- Generate summary reports and frequency tables using base SAS procedures.
- Enhance reports through the use of user-defined formats, titles, footnotes and SAS System reporting.

Handling Errors:
- Identify and resolve programming logic errors.
- Recognize and correct syntax errors.
- Examine and resolve data errors.

Note:

1) Students might be asked to provide an email by SAS website , for downloading FREE SAS University Edition software for their use.(That is Download SAS free of cost)

2) Same applies to SAS community.

3) Practice exercises attached to dropbox via Orangedox. In case of any issue please let me know.

What are the requirements?

  • No prior knowledge or experience needed. Only a passion to be successful!

What am I going to get from this course?

  • Read raw data file and External SAS data sets using list input, Column input and Formatted Input
  • Do any sort of data manipulation
  • Write conditional control structures, debug and efficiently handle errors
  • Write and solve programming questions

What is the target audience?

  • This course is for everyone, right from college students using SAS for a project to statisticians, Professional programmers from other platforms, or pure beginners without any prior programming experience who want to become
  • SAS Analyst
  • SAS programmer
  • Data Analyst
  • Business Analyst
  • Clinical SAS programmer
  • Data Scientist
  • business intelligence.
  • Data Analytics

7

Students

--

Projects

0

Reviews (0)

Saurav Gupta

Love's playing with Data.......(Data Scientist)

My name is Saurav Gupta and I am Super-Excited that you are reading this!

I want you to be confident that I can deliver the best training there is, so below is some of my background.

Engineer

I have done engineering from top Tier 1 Engineering College in India. Apart, from this I am ranked among top 250 Engineers All over India as per Graduate Aptitude Test in Engineering (GATE).

So, Being an Engineer, I have a habit of giving meticulous attention to details, So, ...

See full profile