Superior quality training is an integral part of UBN Qtech commitment to its Students. We realize that an investment in training is designed to do one thing -- increase your productivity. And we're committed in helping you realize the full value of its investment.

We deliver on that promise with:

• We deliver up-to-date content that is of the highest quality.
• SAS instructors that often stand as thought leaders in their fields.

Multiple delivery methods designed to meet your time, budget and education needs .

When you invest in SAS Education, our technical training specialists work closely with SAS software developers to facilitate your learning experience and to develop a course and a learning path that suits the needs of the individuals using the software application. But we don't stop there. If you have a special need, UBN Qtech Education account representatives will provide a training assessment and will work with you to customize solutions to help you.

Qtech-sol offer following sas package:

• FSP- Financial credit card SAS Package
• DSP-Data Validation SAS package
• MSP-Modeling SAS Package
• CSP- Clinical Sas Package

QtechSol provides different training programs emphasizing the following:

Training Classes Offered at Qtech-Sol

SAS FUNDAMENTALS WORKSHOP

This is the course to begin with!!! It is designed to provide programming personnel and analysts with the skills necessary to produce simple reports and data sets as well as providing an understanding of how SAS manipulates and views data. The focus of the course is to consider SAS in the data processing environment and provide a strong background for programmers to tackle advanced SAS programming skills such as macros, SQL code and various procs. Practice in the application of the SAS concepts will be gained through the coding and testing of solutions to sample workshop problems. Both Batch and interactive programming will be covered. This course assumes that the student understands the basics of data processing and the use of their system editor. This course parallels the SAS Intermediate Workshop, it should not be taken as a follow-up course to the SAS Intermediate course.

Course objectives:

Upon completion, the student will be able to:

AGENDA

SAS PROGRAMMING WORKSHOP

This course is designed to provide programming personnel with all the skills necessary to access and manipulate data, summarize data and produce reports. SAS efficiency will also be discussed. The focus of the course is to consider SAS in the data processing environment. Practice in the application of SAS concepts will be gained through the coding and testing of solutions to sample workshop problems. This course is designed for programming personnel.

Course objectives:
Upon completion, the student will be able to:

• Define and access various file types
• Define standard and nonstandard
• (e.g. Packed, binary, date etc.) input data
• Understand the SAS methodology
• Select data
• Sequence data
• Merge files
• Manipulate data with PROCs and functions
• Produce formatted and customized reports
• Produce summary reports
• Create extract files

AGENDA

SAS MACRO WORKSHOP

Macros allow for more efficient coding of repetitive tasks and add significant flexibility to SAS code. This course is designed to provide the experienced SAS programmer with the skills necessary to define and call SAS Macros, define Macro variables and use automatic and user defined Macro variables. The class will also cover the use of Macro functions and Macro programming statements. A variety of practical examples of Macros will be presented and solved in a lecture/workshop environment.

Course Objectives:
Upon completing the course the participant will be able to:

• Understand the uses of the SAS Macro language
• Use automatic and user defined Macro variables
• Define and call Macros
• Understand global and local referencing environments
• Conditionally execute SAS programs using Macro programming statements
• Use Macro functions
• Create Interactive Macros

AGENDA

Optional One Day

SAS ADVANCED PROCESSING WORKSHOP

This course is designed for the experienced SAS programmer who needs to solve more complex problems. The course builds upon the concepts presented in the SAS FUNDAMENTALS course. Emphasis is placed on efficient data manipulation in the Data Step using SAS functions and SAS programming statements. Data will be summarized both in the Data Step and through the use of PROC SUMMARY. This course also introduces macro variables. A variety of practical examples will be presented and solved in a lecture/workshop environment.

Course Objectives:
After completing the course the participant will be able to:

• Use SAS software to read complex files
• Read and process multiple files
• Understand advanced data step techniques
• Use arrays
• Use DO LOOPS
• Understand advanced formats
• Read, merge and update SAS data sets
• Use functions to manipulate data
• Use the data step to summarize data
• Use PROC SUMMARY to summarize data
• Understand Macro Variables
• Write efficient programs

AGENDA

SAS REPORT WRITING WORKSHOP

This course is designed for pc-SAS users creating sophisticated reports that can be used enterprise wide. The power Proc Report capabilities will covered as will as the new output delivery system under version eight; ODS w/HTML. Practice in the application of these concepts will be gained through the coding and testing of sample exercises.

Course objectives:
Upon completion the student will be able to:

• Produce detail and summary reports
• Produce summary SAS datasets
• Produce reports for Internet and Intranets
• Understand and use Proc Report

Prerequisites and Audience:
Programmers or Business users that need to design complex reports and have completed a fundamentals of SAS workshop or have experience in the SAS language.

AGENDA

SAS AF/SCL WORKSHOP

This course is designed for the application developer with basic SAS skills who needs to design and create interactive menu driven systems. Emphasis will be on creating a point and click application to access SAS data sets and submit SAS code in the SCL programming language. A variety of practical examples will be presented and solved in a lecture/workshop environment.

Course Objectives:
After completing the course the participant will be able to:

• Prompt for and validate user input
• Submit SAS code based on user input
• Branch to menus and windows
• Design the system to meet user needs with push buttons and pull down menus

Who should attend:
Application developers with SAS experience.

Prerequisites:
The SAS Fundamentals Workshop or an understanding of SAS programming basics under the SAS Display Manager System.

AGENDA

SAS OS 390 Efficiencies WORKSHOP

This course is designed to provide programming personnel with the skills necessary to improve their understanding of how SAS views and manipulates data. Students will learn to manage and format the Data Libraries created using SAS. The focus of the course is to consider SAS in the data processing environment. Practice in the application of SAS concepts will be gained through the coding and testing of solutions to sample workshop problems.

Course Objectives:
After completing the course the participant will be able to:

• Define and access various file types
• Understand SAS Libraries
• Write Efficient programs in the Batch environment
• Who Should Attend:
• SAS Programmers with a firm knowledge of SAS Fundamentals or have completed the
• SAS Fundamentals workshop, and system editor familiarity

Prerequisites:
This course assumes that the student understands the basics of SAS, data processing or has successfully completed the SAS Fundamentals Workshop. Knowledgeable use of the system editor is also required.

AGENDA

• Review
  • Creating SAS datasets
  • Reading and Writing SAS datasets
  • Enhancing SAS Output
  • SAS Date Values
  • Accumulating SAS totals
  • SAS datasets Compilation
  • Creating the PDV.
  • Debugging Tools
    
• SAS Data Libraries
  • What is a SAS Library
  • Storing SAS Data Sets
  • Managing SAS Data Libraries
  • SAS Format Libraries
    
• Efficiencies
  • Basic Efficiencies
  • Indexes, Stored Program Facility
  • Combining AND's with OR's
  • Where to use WHERE
    
• Extract Files &Transferring Data

Back to Top

---

 

USING SQL IN SAS PROGRAMMING

Structured Query Language (SQL) has been added to the base SAS system in order to take advantage of this standardized structured coding language. No additional purchase is necessary for you to use this tool. PROC SQL is a natural for individuals who are already familiar with SQL coding as well as new users to whom it would be valuable to learn this emerging language. SQL allows ready access to many different file types and databases with the same general metaphor of relational design and data representation of tables of rows and columns. This language also has the particular advantage in SAS of both a simpler and more efficient alternative to the match-merge.

This course focuses on using Structured Query Language (SQL) for data retrieval within SAS programs from SAS datasets. Emphasis will be placed on extracting and manipulating data from multiple files or tables with simple and concise queries.

Course objectives:
Upon completion, the student will be able to perform queries on data using:

• Column and row selection
• Use column calculations and functions
• Summarize data
• Retrieve data from multiple sources using
• JOINs, UNIONs and other methods
• Create views, tables and indices
  

Prerequisites:
Knowledge of basic SAS programming including:

• Submitting SAS programs on your operating system
• Creating and accessing SAS datasets
• Invoking SAS Procedures
• Using arithmetic, comparison, and logical operations

Employment with Qtech Solutions Inc.

QtechSol provides a comprehensive range of technical services to industry leaders.
The following are just a few types of opportunities we have to offer at QtechSol:

• SAS Application Developers.
• SAS Business/Systems/Functional Analysts.
• SAS Project Managers.
• SAS Database & System Administrators.
• SAS Programmers.
• SAS Data Warehouse Specialists.
• SAS UNIX Programmers.
• SAS PC Programmers.
• SAS Technical Writers & Trainers.
• SAS Application & System Testers.
• SAS Mainframe & Midrange Programmers.
• SAS Application & System Architects.
• SAS Quality Assurance Specialists.
• SAS Data Validation Specialists.
• SAS Clinical Researchers & Biostatisticians.
• SAS Clinical Trial Programmers.
  

Back to Top