This course is intended towards data analytics as a whole. This comprises of data preparation and data manipulation (technically SAS Base). Moving a step further Analytics would be covered where statistics and various analytics techniques would be covered(technically SAS Analytics). Then we move for data insignts ,Macros and SQL (Technically Advance SAS).This will be project based workshop rather than just classroom training.

The online classes are conducted on weekday basis. either in the morning or late evening.

Topics Covered

Learning Base SAS programming Basic Concepts Introduction to SAS tool SAS Libraries /Temporary Library/ Permanent Library Creating Libraries Start with a Basic SAS programs Data Step / Proc Step / Statements/ Global statements Variables / Datatypes / properties of Variables Access Data INFILE statement options to read raw data files Creating a file refrence with filename statement DATALINES statement with an INPUT statement Starting With Raw Data(Basics) Styles of Input Reading Unaligned Data / Understanding List Input Understanding Column Input / Reading Data Aligned in Columns Formats and Informats Standard Data/ Non Standard Data How Informats and Format works Working with Date/Time/Datetime informat How and when to use Yearcutoff Starting With Raw Data( Beyond Basics) Formatted Input style Using Modifiers Mixing Styles of Input Testing a Condition before Creating an Observation Creating Multiple Observations from a Single Record Reading Multiple Records to Create a Single Observation PDV: How the DATA Step Works Writing Basic Data Step How SAS Processes Programs Compilation phase Execution Phase Debugging a Data Step Testing SAS Programs Manipulating SAS Datasets Creating & Modifying Variables Assigning Values Conditionally Specifying Lengths for Variables Subsetting Data Assigning Permanent Labels and Formats Grouping Statements Using DO Groups Assigning Values Conditionally Using SELECT Groups Reading a Single Data Set Manipulating Data Using BY-Group Processing Reading Observations Using Direct Access (Point= option) Detecting the End of a Data Set(end= option) Understanding How Data Sets Are Read through PDV Renaming Variables Selecting Variables Combining SAS Data Sets One-to-One Reading Concatenating Interleaving Match-Merging Match-Merge Processing Excluding Unmatched Observations Transforming Data with SAS Functions General Form of SAS Functions Converting Data with Functions Restriction for WHERE Expressions Manipulating SAS Date Values with Functions SAS Date and Time Values SAS Date Functions Modifying Character Values with Functions Modifying Numeric Values with Functions Nesting SAS Functions RELEVANT BASE SAS PROCEDURES: APPEND PROCEDURE SORT PROCEDURE DATASETS PROCEDURE PRINTTO PROCEDURE FORMAT PROCEDURE TRANSPOSE PROCEDURE IMPORT PROCEDURE EXPORT PROCEDURE PRINT PROCEDURE TABULATE PROCEDURE REPORT PROCEDURE MEANS PROCEDURE SUMMARY PROCEDURE FREQ PROCEDURE Generating Data with DO Loops Constructing DO Loops Introduction to Constructing DO Loops DO Loop Execution Counting Iterations of DO Loops Decrementing DO Loops Nesting DO Loops Iteratively Processing Data That Is Read from a Data Set Conditionally Executing DO Loops Using Conditional Clauses with the Iterative DO Statement Creating Samples Processing Variables with Arrays Creating One-Dimensional Arrays Understanding SAS Arrays Defining an Array Variable Lists as Array Elements Referencing Elements of an Array Compilation and Execution Using the DIM Function in an Iterative DO Statement Creating Variables in an ARRAY Statement Creating Temporary Array Elements

Who should attend

Who want to learn Base SAS andwant to clear the global Base SAS certification exam can attend these classes.

Pre-requisites

Basic computer knowledge Should be a graduate Should have a good internet connection for online classes

What you need to bring

NA

Key Takeaways

Would be able to clear SAS certification exam.