Credential(s) Offered
Industry certification, Secondary school diploma, Employment, Measurable Skill Gain Leading to a Credential
Method of Delivery
Hybrid or blended
When offered
Daytime Hours
Instructional Program (CIP)
Computer Programming/Programmer, General.
110201
Description
- Course Overview
- This course teaches you how to create tabular reports using the REPORT and TABULATE procedures. You also learn how to enhance your reports using the Output Delivery System (ODS). Skills Gained Create PROC TABULATE summary tabular reports.Create PROC REPORT detail and summary tabular reports.Send.
Skills Gained
Create PROC TABULATE summary tabular reports.
Create PROC REPORT detail and summary tabular reports.
Send report output to SAS and third-party ODS destinations.
Enhance reports using ODS options, statements, and procedures. - Audience
- SAS programmers, data managers, report writers, and analysts who want to generate reports using Base SAS procedures and who are familiar with basic SAS procedure syntax
Prerequisites
- SAS programmers, data managers, report writers, and analysts who want to generate reports using Base SAS procedures and who are familiar with basic SAS procedure syntax
- Introduction to Reporting and the Output Delivery System
- Setting up for this course.
- Introduction to reporting.
- Introduction to the Output Delivery System.
- Getting Started with the TABULATE Procedure
- Introduction to the TABULATE procedure.
- Creating the structure of tables.
- Adding overall summarizations.
- Adding additional statistics.
- Doing More with the TABULATE Procedure
- Enhancing with labels, formats, and options.
- Adding trafficlighting and style attributes.
- Getting Started with the REPORT Procedure
- Introduction to the REPORT procedure.
- Creating detail reports.
- Creating summary reports.
- Computing additional columns.
- Doing More with the REPORT Procedure
- Adding summary lines.
- Adding trafficlighting and style attributes.
- Using the CALL DEFINE statement.
- Doing More with the Output Delivery System
- Doing more with the EXCEL destination.
- Doing more with other destinations.
- Using ODS ESCAPECHAR.
- Using ODS LAYOUT.
- Using SG procedures (ODS GRAPHICS).
- Creating a complex report.
Details
Program Length (Weeks)
1
Hours
35
Entrance Requirements
Combination of Education and Course(s)
School
WIOA Approved Program
Yes
Curriculum Competency Based
https://vtec.org/courseoutlines?id=19206#:~:text=SAS(R)%20Report%20Writing
Training Location(s)
343 Gorham Rd South Portland, ME
Local WIB
4 - Coastal Counties Local Area 4
Type of Attainment:
Not available
Name of Credential
SAS(R) Report Writing
Type of financial aid offered or have access to
N/A
Refund Policy
https://vtec.org/About/Cancellation/
Is the proposed curriculum currently certified by an accrediting agency or similar national standardization program?
Yes - Tableau
Is this proposed curriculum considered a nontraditional program of training services for women?
No
Is this proposed curriculum considered a nontraditional program of training services for men?
No
Cost Items
Books (Estimated)
$250.00
In-State Tuition
$2,495.00 5 Day Course 55366 - Querying Microsoft SQL Server with Transact-SQL
Total In-State Program Cost
$2,745.00
Demand Occupation(s)
15-1251.00Computer Programmers
$24.00 per hour
