About Course
SAS is a powerful software tool used for data analysis and statistical modeling. If you’re looking for Data Analytics in SAS, Happie Labs is the best option. We offer SAS training programs that are designed to meet the needs of both beginners and experienced SAS users. Our programs are taught by experienced SAS instructors who are familiar with the latest SAS software features and can help you get the most out of your SAS learning experience.
Importance of SAS:
SAS is a software suite that can perform statistical analysis, data visualization, and predictive modeling. It is used by many organizations to make business decisions. Happie Labs offers the Industry’s best SAS Data Analytics Training. The course covers all the aspects of SAS programming and its application in business. The course is taught by experienced SAS professionals who have years of experience in the industry.
The course includes both theoretical and practical sessions. The theoretical part covers the concepts of SAS programming and its application in business. The practical part includes working on live projects. This helps the students to get hands-on experience working with SAS.
The course is designed keeping in mind the needs of both beginners and advanced users. It starts with SAS programming basics and moves on to advanced topics. This makes it suitable for both fresher’s and experienced professionals who want to learn SAS programming.
The course fee is very affordable and the schedule is flexible. Students can choose to study at their own pace or opt for fast-track courses.
SAS Course Content:
SAS/BASE
BASIC THEORY & RULES ETC
SAS WINDOWING ENVIRONMENT
CREATION OF LIBRARIES
SAS PROGRAMMING (BRIEFLY)
– DATASTEP
– PROC STEP
WAYS TO READ DATA INTO SAS
BACK END PROCESS OF DATASTEP
INSTALLATION PROCESS
DATASTEP
DATA STATEMENT &DATASET OPTIONS
INFILE STATEMENT & OPTIONS
INPUT STATEMENT &STYLES & OPTIONS
DATALINES STATEMENT
ATTRIBUTES OF THE VARIABLES
LENGTH, LABEL STATEMENTS
INFORMATS & FORMATS
HOW DATES WORKS IN SAS
OTHER STATEMENTS
SUM STATEMENT
RETAIN STATEMENTS
GOTO STATEMENT
LINK STATEMENT
RETURN STATEMENT
KEEP STATEMENT
DROP STATEMENT
RENAME STATEMENT
REPLACE STATEMENT
RETURN STATEMENT
OUTPUT STATEMENT
DM STATEMENT
CONDITIONAL STATEMENTS & LOOPS
IF, IF/THEN, IF/THEN/ELSE,IF/THEN OUTPUT, IF/THEN DELETE STATEMENTS
WHERE STATEMENT& OPERATORS
DO, DO ITERATIVE, DO UNTIL & DO WHILE STATEMENTS
ARRAYS
COMBINING DATASETS
CONCATENATION
INTERLEAVING
MERGE
UPDATE
MODIFY
FUNCTIONS
CHARACTER FUNCTIONS
NUMERIC FUNCTIONS
DATE FUNCTIONS
OTHERS MISSING CONCEPTS
REVIEW OF DATASTEP
EXAM & DISCUSSION
PROC STEP
UTILITY PROCEDURES
PROC CONTENTS
PROC COPY
PROC SETINIT
PROC DELETE
PROC PWENCODE
PROC APPEND
PROC SORT
PROC DATASETS
PROC OPTIONS
PROC COMPARE
PROC TRANSPOSE
PROC RANK
PROC FORMAT
PROC IMPORT
PROC EXPORT
PROC CATALOG
PROC CPORT
PROC CIMPORT
PROC TEMPLATE
PROC MIGRATE
PROC FORMS
REVIEW OF UTILITY PROCEDURES
SAS/ACCESS
SQL PASS THRU QUERY (PROC SQL)
LIBNAME STATEMEN
PROC DBLOAD
PROC ACCESS
REVIEW OF ACCESS PROCEDURES
REPORTING PROCEDURES
PROC PRINT
PROC TABULATE
PROC REPORT
_NULL_ REPORT (Data step Reporting)
REVIEW OF REPORTING PROCEDURES
SAS/GRAPHS & ODS CONCEPTS
PROC GPLOT
PROC GCHART
PROC SGPLOT
PROC ANNOTATE
PROC GIS
PROC GMAP
ODS
REVIEW OF GRAPHS PROCEDURES
SAS/STAT
BASIC FUNCTIONAL CLASSES OF STATISTICS
STATISTICAL PROCEDURES
PROC MEANS
PROC SUMMARY
PROC UNIVARIATE
PROC FREQ
PROC CORR
PROC REG
PROC ANOVA
PROC GLM
PROC TTEST
PROC LIFE TEST
PROC LIFEREG
PROC LOGISTICS
REVIEW OF STATS PROCEDURES
SAS/MACROS
INTRODUCTION TO THE MACRO FACILITY
PURPOSE OF THE MACRO FACILITY
PROGRAM FLOW
MACRO VARIABLES
INTRODUCTION TO MACRO VARIABLES
AUTOMATIC MACRO VARIABLES
MACRO VARIABLE REFERENCES
USER-DEFINED MACRO VARIABLES
DELIMITING MACRO VARIABLE NAMES
DELETING MACRO VARIABLES
MACRO FUNCTIONS
MACRO DEFINITIONS
DEFINING AND CALLING A MACRO
MACRO PARAMETERS
MACRO STORAGE
DATA STEP AND SQL INTERFACES-
CREATING MACRO VARIABLES IN THE DATA STEP
INDIRECT REFERENCES TO MACRO VARIABLES
RETRIEVING MACRO VARIABLES IN THE DATA STEP
CREATING MACRO VARIABLES IN SQL
MACRO PROGRAMS
CONDITIONAL PROCESSING
PARAMETER VALIDATION
ITERATIVE PROCESSING
GLOBAL AND LOCAL SYMBOL TABLES
FRAMEWORK FOR DEVELOPING MACRO APPLICATIONS
DEBUGGING AND TROUBLESHOOTING
GENERATING CUSTOM MESSAGES
CREATING EFFICIENT MACROS
REVIEW OF MACROS
PERFORMANCE TUNING CONCEPTS
TESTING/DEBUGGING TECHNIQUES
ERROR HANDLING
ADDITIONAL FEATURES BETWEEN SAS VERSIONS
CERTIFICATION CLASSES
DOMAIN-SPECIFIC PROJECT
PRACTICE
SDLC (Software Development Life Cycle)
CODING ON REAL TIME DATA
INTERVIEW QUESTIONS
RESUME PREPARATION
WRITTEN TESTS
MOCK INTERVIEWS
PLACEMENTS & OUTSOURCING
CONSULTING
DEVELOPMENT
PROC SQL
INTRODUCTION TO THE SQL PROCEDURE
WHAT IS SQL?
WHAT IS THE SQL PROCEDURE?
TERMINOLOGY
COMPARING PROC SQL WITH THE SAS DATA STEP
RETRIEVING DATA FROM A SINGLE TABLE
OVERVIEW OF THE SELECT STATEMENT
SELECTING COLUMNS IN A TABLE
CREATING NEW COLUMNS
SORTING DATA
RETRIEVING ROWS THAT SATISFY A CONDITION
SUMMARIZING DATA
GROUPING DATA
FILTERING GROUPED DATA
VALIDATING A QUERY
RETRIEVING DATA FROM MULTIPLE TABLES
INTRODUCTION
SELECTING DATA FROM MORE THAN ONE TABLE BY USING JOINS
USING SUBQUERIES TO SELECT DATA
WHEN TO USE JOINS AND SUBQUERIES
COMBINING QUERIES WITH SET OPERATORS
CREATING AND UPDATING TABLES AND VIEWS
INTRODUCTION
CREATING TABLES
INSERTING ROWS INTO TABLES
UPDATING DATA VALUES IN A TABLE
DELETING ROWS
ALTERING COLUMNS
CREATING AN INDEX
DELETING A TABLE
USING SQL PROCEDURE TABLES IN SAS SOFTWARE
CREATING AND USING INTEGRITY CONSTRAINTS IN A TABLE
CREATING AND USING PROC SQL VIEWS
PROGRAMMING WITH THE SQL PROCEDURE
INTRODUCTION
USING PROC SQL OPTIONS TO CREATE AND DEBUG QUERIES
IMPROVING QUERY PERFORMANCE
ACCESSING SAS SYSTEM INFORMATION USING DICTIONARY TABLES
USING PROC SQL WITH THE SAS MACRO FACILITY
FORMATTING PROC SQL OUTPUT USING THE REPORT PROCEDURE
ACCESSING A DBMS WITH SAS/ACCESS SOFTWARE
USING THE OUTPUT DELIVERY SYSTEM (ODS) WITH PROC SQL
PRACTICAL PROBLEM-SOLVING WITH PROC SQL
OVERVIEW
COMPUTING A WEIGHTED AVERAGE
COMPARING TABLES
OVERLAYING MISSING DATA VALUES
COMPUTING PERCENTAGES WITHIN SUBTOTALS
COUNTING DUPLICATE ROWS IN A TABLE
EXPANDING HIERARCHICAL DATA IN A TABLE
SUMMARIZING DATA IN MULTIPLE COLUMNS
CREATING A SUMMARY REPORT
CREATING A CUSTOMIZED SORT ORDER
CONDITIONALLY UPDATING A TABLE
UPDATING A TABLE WITH VALUES FROM ANOTHER TABLE
CREATING AND USING MACRO VARIABLES
USING PROC SQL TABLES IN OTHER SAS PROCEDURES
