Course Highlights:6.5 hours 49 video-formatted lectures This course can help prepare you for the following certification exam: SAS Certified Clinical Trials Programmer Using SAS 9step by step/ code by code explanationsdownloadable data and SASprograms used in the course (the course materials are ONLYfor practice, they are protected by copyright)QuizzesPlease be considerate and sincere when you provide ratings. This will encourage me providing more contents to the course and better service to you! Course Description: As a SAS programmer/data analyst at any level, you need to generate reports and tables to summarize your analytical results in a presentable and understandable way. Sometimes you are required to present a report to senior managements, other times you need to present a table in an easy-to-understand way to the clients. This course is designed to help you fulfill your daily report and table generating tasks using SAS. This course can also help prepare you for the following certification exam: SAS Certified Clinical Trials Programmer Using SAS 9.Course includes 4 sections: 6.5 hours and 49 video-formatted lectures Produce Detail Reports with the PRINT Procedure: Proc Print: OverviewProc Print: create simple reportsProc Print: create enhanced reportsProc Print: continue on create enhanced reportsProc Print: Customize a ReportProc Print: easy change/update your reports with SAS MacroCreate Summary tables using Proc Tabulate: Proc Tabulate: OverviewProc Tabulate: One dimension tableProc Tabulate: Two dimension tableProc Tabulate: Three dimension tableProc Tabulate: Create Multiple tables in one Proc Tabulate stepProc Tabulate: Cross Elements within one DimensionProc Tabulate: Identify/Include Missing Values/Categories for Class VariablesProc Tabulate: format output tablesProc Tabulate: report on multiple statisticsProc Tabulate: Reduce Code and Apply a Single Label to Multiple ElementsProc Tabulate: Get Summaries for All Class VariablesProc Tabulate: Define Labels to make table more understandableProc Tabulate: calculate Total percentages using default statisticsProc Tabulate: calculate Column percentages using default statisticsProc Tabulate: calculate Row percentages using default statisticsProc Tabulate: calculate Page percentages using default statisticsProc Tabulate: calculate percentages using denominator definitionsCreate Detail and Summary Reports with Proc REPORT: Proc Report: OverviewProc Report: Define Statement Usages: DisplayProc Report: Define Statement Usages: Order & GroupProc Report: Define Statement Usages: AnalysisProc Report: Define Analysis: create multiple stats on same var using AliasProc Report: Define Analysis: create multiple stats on same var using ColumnProc Report: Define Statement Usages: AcrossProc Report: Break and Rbreak StatementsProc Report: Compute Block: Compute Values and Generate ColumnsProc Report: Compute Block: add text and change formatProc Report: Calculate PercentagesProc Report: handle missing valuesProc Report: create output data setGenerate and Customize SAS Outputs Using the Output Delivery System (ODS): ODS overview with examples creating PDF, RTF, PowerPoint outputsODS: Creating HTML Output with OptionsODS: Creating HTML Output with a Table of ContentsODS: Changing the Appearance of HTML OutputODS: Creating Excel Output with multiple worksheetsODS: Selecting and Excluding Program OutputsODS: Creating a SAS Data Set using ODS OUTPUT statementODS: Customizing Outputs with Styles in Proc PrintODS: Customizing Outputs with Styles in Proc TabulateODS: Customizing Outputs with Styles in Proc ReportReferences: SAS certification prep guide: base programming for SAS 9 SAS 9.4 Output Delivery System: User’s Guide, Fourth Edition Base SAS 9.4 Procedures Guide, Sixth Edition Step-by-Step Programming with Base SAS(R) 9.4, Second EditionNote: The course was created with SAS softwarelicensefor the SAS University Edition (the downloadable SASstudio version).The course is also suitable to use with SASOnDemand for Academics (the web-based SASstudio version). The software interface/appearance and functionalities in the two SAS studio versions are the same. Section 2 has all the details for using SASOnDemand for Academics with this courses.
