Data Science with SAS Certification

Course details

Knowasap provides best SAS training by our highly professional instructor.

SAS  is the leading business analytics software used in a variety of business domains such as Insurance,Healthcare, Pharmacy, Telecom and fortune 500 companies etc. Very often, business analysts and other professionals with little or no programming experience are required to learn SAS.

SAS stands for Statistical Analysis System. It is useful for the following types of task:

1.  Data entry, retrieval, and management
2.  Report writing and graphics
3. Statistical and mathematical analysis

Chapter 1: INTRODUCTION TO SAS

1. INTRODUCTION
2. NEED FOR SAS
3. WHO USES SAS
4. WHAT IS SAS?
5. OVERVIEW OF BASE SAS SOFTWARE
6. DATA MANAGEMENT FACILITY
7. STRUCTURE OF SAS DATASET
8. SAS PROGRAM
9. PROGRAMMING LANGUAGE
10. ELEMENTS OF THE SAS LANGUAGE
11. RULES FOR SAS STATEMENTS
12. RULES FOR MOST SAS NAMES
13. SPECIAL RULES FOR VARIABLE NAMES
14. TYPES OF VARIABLES
15. DATA ANALYSIS AND REPORTING UTILITIES
16. TRADITIONAL OUTPUT
17. WAYS TO RUN SAS PROGRAMS
18. SAS WINDOWING ENVIRONMENT

1. WRITING YOUR FIRST SAS PROGRAM
2. A SIMPLE PROGRAM TO READ RAW DATA AND PRODUCE A REPORT
3. ENHANCING THE PROGRAM
4. MORE ON COMMENT STATEMENTS
5. INTERNAL PROCESSING IN SAS
6. HOW SAS WORKS
7. THE COMPILATION PHASE
8. THE EXECUTION PHASE
9. PROCESSING A DATA STEP: A WALKTHROUGH
10. CREATING THE INPUT BUFFER AND THE PROGRAM DATA VECTOR
11. WRITING AN OBSERVATION TO THE SAS DATA SET
12. FOUR TYPES OF SAS LIBRARIES
13. SAS LIBRARIES
14. WORK LIBRARY
15. SASHELP LIBRARY
16. SASUSER LIBRARY

1. WHAT IS RAW DATA
2. DEFINITIONS
3. DATA VALUES
4. NUMERIC VALUE
5. CHARACTER VALUE
6. STANDARD DATA
7. NONSTANDARD DATA
8. NUMERIC DATA
9. CHARACTER DATA
10. CHOOSING AN INPUT STYLE
11. LIST INPUT
12. MODIFIED LIST INPUT
13. COLUMN INPUT
14. FORMATTED INPUT
15. NAMED INPUT
16. INSTREAM DATA
17. CREATING MULTIPLE RECORDS FROM SINGLE INPUT ROW
18. READING DATA FROM EXTERNAL FILES
19. READING BLANK SEPARATED VALUES (LIST OR FREE FORM DATA):
20. USING INFORMATS WITH LIST INPUT
21. SUPPLYING AN INFORMAT STATEMENT WITH LIST INPUT
22. USING LIST INPUT WITH EMBEDDED DELIMITERS
23. READING RAW DATA THAT ARE ALIGNED IN COLUMNS:
24. METHOD 1: COLUMN INPUT
25. METHOD 2: FORMATTED INPUT
26. USING MORE THAN ONE INPUT STATEMENT: THE SINGLE TRAILING @
27. READING COLUMN DATA THAT IS ON MORE THAN ONE LINE
28. MIXED-STYLE INPUT:
29. INFILE OPTIONS FOR SPECIAL SITUATIONS
30. FLOWOVER
31. MISSOVER
32. TRUNCOVER
33. PAD
34. USING LRECL TO READ VERY LONG LINES OF RAW DATA
35. CHECKING YOUR DATA AFTER IT HAS BEEN READ INTO SAS

1. INTRODUCTION
2. SET STATEMENT OVERVIEW
3. AUTOMATIC VARIABLES IN SAS
4. INTERLEAVE MULTIPLE SAS DATA SETS
5. COMBINE MULTIPLE SAS DATA SETS
6. CREATING & MODIFYING VARIABLES
7. CREATING MULTIPLE DATASETS IN A SINGLE DATA-STEP
8. SUBSETTING OBSERVATIONS
9. CONDITIONAL SAS STATEMENTS
10. LOGICAL AND SPECIAL OPERATORS
11. THE SAS SUPERVISOR AND THE SET STATEMENT
12. EFFICIENCY AND THE SET STATEMENT
13. KNOW YOUR DATA
14. SET STATEMENT DATA SET OPTIONS
15. DROP AND KEEP OPTIONS
16. RENAME OPTION
17. FIRSTOBS AND OBS OPTIONS
18. IN OPTION -
19. WHERE OPTION -
20. OTHER SET STATEMENT OPTIONS
21. END OPTION
22. KEY OPTION
23. NOBS OPTION
24. POINT OPTION
25. DO LOOPS AND THE SET STATEMENT
26. INTRODUCTION TO RETAIN STATEMENT
27. CARRY OVER VALUES FROM ONE OBSERVATION TO ANOTHER
28. COMPARE VALUES ACROSS OBSERVATIONS
29. ASSIGN INITIAL VALUES
30. DETERMINING COLUMN ORDER IN OUTPUT DATASET
31. SAS SYSTEM OPTIONS

1. INPUT SAS DATA SET FOR EXAMPLE
2. SELECTING OBSERVATIONS FOR A NEW SAS DATA SET
3. DELETING OBSERVATIONS BASED ON A CONDITION
4. ACCEPTING OBSERVATIONS BASED ON A CONDITION
5. COMPARING THE DELETE AND SUBSETTING IF STATEMENTS
6. METHODS OF CREATING NEW DATA SETS WITH A SUBSET
7. SUBSETTING RECORDS FROM AN EXTERNAL FILE WITH A SUBSETTING IF STATEMENT
8. SUBSETTING OBSERVATIONS IN A DATA STEP WITH A WHERE STATEMENT
9. SUBSETTING OBSERVATIONS IN A PROC STEP WITH A WHERE STATEMENT
10. SUBSETTING OBSERVATIONS IN PROC SQL
11. DIFFERENCE BETWEEN IF AND WHERE

1. OVERVIEW
2. USING SAS INFORMATS
3. INPUT STATEMENT
4. INPUT FUNCTION
5. INPUTN AND INPUTC FUNCTIONS
6. ATTRIB AND INFORMAT STATEMENTS
7. USING SAS FORMATS
8. FORMAT STATEMENT IN PROCEDURES
9. PUT STATEMENT
10. PUT FUNCTION
11. PUTN AND PUTC FUNCTIONS
12. BESTw. Format
13. ADDITIONAL COMMENTS

1. CATEGORIES OF FUNCTIONS
2. SAS CHARACTER FUNCTIONS
3. FUNCTIONS THAT CHANGE THE CASE OF CHARACTERS
4. UPCASE
5. LOWCASE
6. PROPCASE
7. FUNCTIONS THAT REMOVE CHARACTERS FROM STRINGS
8. FUNCTION: COMPBL
9. FUNCTION: COMPRESS
10. FUNCTIONS THAT SEARCH FOR CHARACTERS
11. FUNCTION: ANYALNUM
12. FUNCTION: ANYALPHA
13. FUNCTION: ANYDIGIT
14. FUNCTION: ANYPUNCT
15. FUNCTION: ANYSPACE
16. FUNCTION: NOTALNUM
17. FUNCTION: NOTALPHA
18. FUNCTION: NOTDIGIT
19. FUNCTION: NOTUPPER
20. FUNCTIONS THAT SEARCH STRINGS
21. FIND AND FINDC
22. INDEX, INDEXC, AND INDEXW
23. FUNCTIONS TO VERIFY DATA
24. FUNCTION VERIFY
25. FUNCTIONS THAT EXTRACT PARTS OF STRINGS
26. FUNCTION: SUBSTR (ON THE LEFT-HAND SIDE OF THE EQUAL SIGN)
27. FUNCTION: SUBSTRN
28. FUNCTIONS THAT JOIN TWO OR MORE STRINGS TOGETHER

1. WHY DO WE NEED ARRAYS?
2. BASIC ARRAY CONCEPTS
3. ARRAY STATEMENT
4. ARRAY REFERENCES
5. VARIABLE NAME ARRAY REFERENCE

1. DEFINITIONS FOR BY-GROUP PROCESSING
2. BY-GROUP PROCESSING
3. BY VALUE
4. BY GROUP
5. AND
6. MODIFYING SAS DATA SETS: EXAMPLES.
7. INVOKING BY-GROUP PROCESSING
8. PRE PROCESSING INPUT DATA FOR BY-GROUP PROCESSING
9. SORTING OBSERVATIONS FOR BY-GROUP PROCESSING

1. DEFINITIONS
2. CONCATENATING
3. INTERLEAVING
4. ONE-TO- ONE READING OR ONE-TO-ONE MERGING
5. MATCH-MERGING
6. UPDATING
7. MODIFYING
8. DEFINITIONS FOR READING, COMBINING, AND MODIFYING SAS DATA SETS
9. READING A SAS DATA SET
10. COMBINING SAS DATA SETS
11. MODIFYING SAS DATA SETS

1. INTRODUCTION
2. THE ANATOMY OF A PROC
3. THE PROC STATEMENT
4. TITLE AND FOOTNOTE STATEMENTS
5. BY STATEMENT
6. LABEL STATEMENT
7. FORMAT STATEMENT
8. RUN OR QUIT STATEMENT
9. DESCRIPTION OF DATA USED IN REPORTS
10. SAS REPORTING PROCEDURES
11. PROCS FOR ALL THAT DETAIL
12. USING PROC PRINT
13. USING PROC SQL
14. PROC REPORT

1. INTRODUCTION
2. WHY LEARN PROC SQL?
3. SELECT STATEMENT
4. THE SELECT STATEMENT SYNTAX
5. A SIMPLE PROC SQL
6. A COMPLEX PROC SQL
7. LIMITING INFORMATION ON THE SELECT
8. CREATING NEW VARIABLES
9. THE CALCULATED OPTION ON THE SELECT
10. USING LABELS AND FORMATS
11. THE CASE EXPRESSION ON THE SELECT
12. ADDITIONAL SELECT STATEMENT CLAUSES

1. INTRODUCTION
2. SAS MACRO OVERVIEW
3. TRADITIONAL SAS PROGRAMMING
4. THE SAS MACRO LANGUAGE
5. MACRO LANGUAGE COMPONENTS
6. MACRO VARIABLES
7. MACRO STATEMENTS

1. INTRODUCTION
2. CREATING VARIOUS TYPES OF REPORTS LISTING OUTPUT
3. OTHER DESTINATIONS
4. HTML
5. PDF AND POSTSCRIPT
6. RTF FILES

1. INTRODUCTION
2. UNDERSTANDING HOW THE SAS SUPERVISOR CHECKS A JOB
3. UNDERSTANDING HOW SAS PROCESSES ERRORS
4. DISTINGUISHING TYPES OF ERRORS .SAS RECOGNIZES FOUR KINDS OF ERRORS:
5. SYNTAX ERRORS
6. EXECUTION-TIME ERRORS
7. DATA ERRORS
8. SEMANTIC ERRORS
9. DIAGNOSING ERRORS