Syllabus: 

1. SAS Foundation

2. SAS Basics

2.1. create library

2.2. create table (datalines, cards)

2.3. Rename and Reorder columns (RENAME, PROC SORT)

2.4. Alter table (SET)

2.5. Create new table from existing table

2.6. Add new columns (fixed, conditional (IF-THEN-ELSE), calculated)

2.7. Date related functions

2.8. Date Formatting

2.9. INFORMAT FORMAT for Date

2.10. Concatenation multiple columns

2.11. Sorting dataset

2.12. Subsetting/Filtering Data with the WHERE Statement

2.13. Subsetting/Filetring Data with the IF Statement

2.14. Complex Filtering

2.15. Customizing Output (NOBS, VAR, KEEP, DROP)

2.16. Export data into csv/xlsx/txt format

2.17. save data in customized library

2.18. Import data into csv/xlsx/txt format

3. SAS Intermediate

3.1. Handling missing values (IF ... THEN, PROC MEANS, PROC FREQ)

3.2. Removing duplicates (PROC SORT NODUPKEY/NODUP)

3.3. Handling outliers (PROC UNIVARIATE, IF conditions)

3.4. Standardizing data (UPCASE, LOWCASE, PROPCASE)

3.5. PROC FORMAT for data labeling

3.6. Data Aggregation & Summarization:

PROC MEANS/ PROC SUMMARY for descriptive statistics

PROC FREQ for frequency tables

PROC UNIVARIATE for distribution analysis

3.7. Rank and Dense Rank Dataset using proc rank

3.8. Merging Dataset

3.9. PROC SQL

4. SAS Advanced

4.1 ML with SAS 

4.1.1 Regression and Classification techniques

4.1.2 Model Validation

4.2 SAS Macro

Duration: 3 Months course + 2 Exam + 2 mock interview

Guide: Soumyajit Basak (Feel free to connect)

Time: Weekends 10 am - 11:30 am (2 Days or 3 hours weekly)

Fees: INR 85000 INR 55000 (Foundation + Basics: 10000; Intermediate: 16000; ML with SAS: 14000; SAS MACRO: 15000)**

Registration: Click here

Note: 

• In need you may customized the course

• We will help you to make a creative resume + we will provide certificate for accomplishing the work* 

• For more details drop a mail to given mail id by keeping the subject as Query_ISP_112. Please expect a response within 24 hours.

• Live classes with dobut clearing sessions and daily assignment will be provided.

• No recordings will be provided

* minimum 70% grade requires in final exam

** Fees is adjustable based on following structure:

a.. Foundation + Basics + Intermediate 

b.. Foundation + Basics + Intermediate + ML with SAS

c.. Foundation + Basics + Intermediate + SAS Macro

d.. Foundation + Basics + Intermediate + ML with SAS + SAS Macro