Sas Programing On Reports And Tables Generating

Create reports and tables using Proc Report, SAS Proc Tabulate, SAS Proc Print and SAS ODS

What you'll learn
Produce Detail Reports with the PRINT Procedure: overview; create simple & enhanced reports; Customize a Report; easy change/update your reports with SAS Macro
Create Summary tables using Proc Tabulate
Create Detail and Summary Reports with Proc REPORT
Generate and Customize SAS Outputs Using the Output Delivery System (ODS)

Requirements
know basic SAS programming skills, such as finishing my SAS programming for beginners or equivallent

Description
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 SAS programs used in the course (the course materials are ONLY for 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 Edition

Note: The course was created with SAS software license for the SAS University Edition (the downloadable SAS studio version).The course is also suitable to use with SAS OnDemand for Academics (the web-based SAS studio version). The software interface/appearance and functionalities in the two SAS studio versions are the same. Section 2 has all the details for using SAS OnDemand for Academics with this courses.

Who this course is for:
Students and professionals who wants to generate high quality and presentable reports and be successful in their career,Students and professionals who wants to learn hignly demanded report generating skills using SAS