SAS BASE AND ADVANCE NEW 8 Sections54 Lessons10 Weeks
Curriculum
- 8 Sections
- 54 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- WEEK 1-BASICS OF SAS AND READING INSTREAM DATA AND READING DATES8 ItemsIn this section we are going to see the basics of SAS , including Accesssing SAS on Demand, Reading Instream Data by List input and advanced list input methods. Also this section covers Reading And Displaying Dates by informat and format statements.
- WEEK 2-READING DATA FROM EXTERNAL FILES, SORTING AND FILTERING DATA8 ItemsIn this section we will see How to import data from External Files in Data step Using Infile and in Proc Step Using PROC IMPORT. Also we will see how to read data by assigning libraries how to sort the data in ascending or descending order using PROC SORT. And also Removing Duplicate rows Using PROC SORT. We will also see Filtering the data Using WHERE Expression with Operators
- 2.1READING DATA USING INFILE
- 2.2READING DATA USING PROC IMPORT PART
- 2.3Exporting data using PROC EXPORT
- 2.4READING THROUGH ASSIGNING LIBRARIES
- 2.5Sorting Data in Ascending or Descending Order using Proc Sort
- 2.6Removing Duplicate rows Using Proc Sort
- 2.7Filtering data By WHERE Expresiion Using Basic Operators
- 2.8Filtering Data by WHERE Expression Using Special Operators
- WEEK 3-MANIPULATING OF DATA,CONDITIONAL PROCESSING OF DATA7 ItemsIn this section we will see how to manipulate data using functions(Numeric and Character functions) and also to Perform conditional processing on data using Do loop, Do While Loop, Do Until Loop, Nested Do Loop, etc..
- WEEK 4- SUMMARIZING OF DATA, BY GROUP PROCESSING,ANALYZING DATA, MAKING CUSTOM FORMATS7 ItemsIn this section we will see Summarizing of data Using Accumulating columns. we will also see By Group Processing using By columns and Analyzing of data using PROC FREQ, PROC MEANS, PROC UNIVARIATE. Also we will see Generating custom Formats using PROC FORMAT.
- WEEK 5-GENERATING TABLES, TRANSPOSING DATA AND VALIDATION OF DATA4 ItemsIn this section we will see generating Tables using PROC TABULATE. we will also see Transposing of data Using PROC TRANSOSE. Finally we will See Validating of data using PROC COMPARE.
- WEEK 6-GENERATING REPORTS, ODS, MISCELLANEOUS PROCEDURES4 ItemsIn this section we will see Generating Reports Using PROC REPORT and ODS. We will also see Miscellaneous procedures such as PROC RANK and PROC COPY.
- WEEK 7-SAS ADVANCE MACROS6 ItemsIn this section we ae going to deal with Advance SAS which Includes Macro Programming where we will see writing reusable Macro Programs,
- 7.1Basics of Macro Programming, Types of Macro variables, Generating Macro Program
- 7.2Performing Arithmetic Operations Using Eval and Sysevalf functions in Macros
- 7.3Macro Functions and Macro Conditional Processing
- 7.4Using SAS procedures in Macro program
- 7.5Generating Macro variable in data step
- 7.6Macro Debugging
- WEEK 8- SAS ADVANCE SQL And Arrays10 ItemsIn this section we will see SQL in SAS by using PROC SQL where we will see creating, Altering, Updating and joining tables. And also we will study how to use Arrays to store data and perform iterative tasks.
- 8.1Creating, Altering ,Updating tables
- 8.2Inserting Data into a table, copying old table into new table, Renaming and assigning labels
- 8.3Numeric and Character functions in SQL
- 8.4Joining Tables by concatenation in SAS language
- 8.5Joining Tables by merging in SAS language
- 8.6Joining Tables by concatenation Using Sets Operators in SQL
- 8.7Joining Tables by Merging Using Joins in SQL
- 8.8Joining Tables by joins, generating macro variables in SQL
- 8.9Arrays Introduction And Types of Arrays
- 8.10Application of Arrays
Arrays Introduction And Types of Arrays
Prev
