SAS Training Services SAS Courses Submit SAS Questions SYS-ED SYSED CETi


SAS Training *Services*	Bookmark this page

Submit SAS Questions

Contact You

SAS Skillset Assessment

Contact You

Enrollment

SAS Training
from SYS-ED®

Grow Your Own
Programmers

Mainframe

Internet Programming

Web Servers

Internetworking

SAS Training Experts	Learning Paths	Knowledge Transfer Experts
Courseware for Teaching	Grow Your Own SAS Programmers	Caveat Emptor
Why SYS-ED for SAS Training	Value Added SAS Training	Consultancy Derived SAS Courses
SAS Training Roadmap	SAS Training in New York	Technology Exchange Websites
Technology Driven IT Training	Delivery Medium	Web-based Training Services

SAS Courses
New York Schedule

Cost
Analysis

Sitemap

SAS Training Services

Business Intelligence Software

Over the past decade, there has been a huge increase in collected data by organizational enterprise. The information has been generated both from traditional sources such as computerized systems for tracking operations, customers and sales and new data sources such as web site visits, social network chatter and public records accessible over the Internet in digital form. This data explosion is an untapped asset at most organizations which lack the tools and skills to exploit it. The challenge is to use data for fine-grained analysis of markets, customer behavior and operations, and transform business operations more toward evidence-based decision-making. This market is a huge opportunity for software companies.

For the better part of 40 years, SAS Institute SAS software has been the leader in the business intelligence software. Historically this has been a niche market where SAS software is used to analyze huge data sets and generate predictive statistical models for large corporations and government agencies. According to leading market research firms, over ninety percent of the largest companies 100 worldwide use SAS software. Developed in response to industry specific operational requirements, SAS has a significant advantage in its software technology, programming language, and tools.

SAS has always invested heavily in research and development. The SAS stronghold is advanced analytics and predictive modeling software which uses historical and current data to model and predict future outcomes. However, SAS comparative advantage has been for the most part derived from the legacy world of statisticians and programmers. The challenge facing SAS is to transition and develop software for deployment to IT and business professionals in a global market. Towards that end, SAS has been moving toward the Internet model of software delivery as a service that customers tap into over the web; some initial products have been launched.

Business intelligence software has become increasingly mainstream; there are now both free open source and proprietary alternatives to SAS emerging in the market. Until recently SAS has been slow to recognize the challenge from free, open-source alternatives to some of its products. The R programming language is a free programming language and set of software tools for statistical computing; it has become increasingly popular at universities and labs. Programs written with R work seamlessly with SAS technology and there is a long-term commitment from management at SAS to work with the open-source community.

In response to the growth and success of SAS' software new competition is emerging from major software companies to gain market share with lower prices and substitute technology. Oracle, SAP, Microsoft, and especially, IBM have invested considerable resources in bringing competitive business intelligence software to market. SAP bought Business Objects and Oracle bought Hyperion. In the summer of 2009, IBM bought SPSS, a maker of predictive modeling software, and prior to that had purchased Cognos. IBM has placed SPSS and Cognos into a new business analytics and optimization group. That business will be supported by 200 scientists, and the company has said it will retrain or hire 4,000 consultants and analysts to work in the group. IBM has stated that business intelligence software is part of its strategy for growth.

SAS Training Experts

SAS software has evolved and been upgraded for utilization in a comprehensive range of operating systems, systems software, and industry-specific environments. It is utilized by a substantial and diverse client base of Fortune 1000 companies, government municipalities, and healthcare providers. SAS is important mainstream software and utilized in combination with a variety of databases and operating systems - mainframe, MS Windows, and UNIX-variants.

SYS-ED's multi-platform SAS training teaches the new Base SAS Procedures and the language enhancements.

CALLRFC	Invoking RFC-Remote Function Call or RFC-compatible functions on an SAP System from a SAS program.
FCMP	Creating, testing, and storing SAS functions and subroutines before using them in other SAS procedures.
JAVAINFO	Provides information to the user about the Java environment that SAS is using.
PROTO	Registering in batch mode, external functions that are written in the C or C++ programming languages.
SCAPROC	Specifying a filename or fileref that will contain the output of the SAS Code Analyzer, and to write the output to the file.
SOAP	Reads XML input from a file that has a fileref and writes XML output to another file that has a fileref.
HTTP Procedure	The HTTP procedure invokes a Web service that issues requests.

Since 1980, SYS-ED has been providing consultancy services and training on SAS software. Our fast-track SAS courses teach industry standard subject matter and educational consultancy in interrelated information technology required for efficient data management, data mining, and report generation such as:

Credit card companies for detecting unusual buying patterns in real time, and spotting potentially fraudulent charges.
Retail chains for tailoring pricing and product offerings down to the store level.
Telecommunications companies for identifying the few thousand customers, among millions, that are most likely to switch to another cellphone carrier.
Energy companies parsing sensor signals from oil rigs and combining that information with weather and structural data, to predict failure of parts.

SYS-ED's staff of system consultant instructors average 30 years experience in information technology and provide insights required for effective maintenance coding and web based utilization of SAS data. Our SAS courses provide results oriented training and ongoing support for the questions that our client’s routinely ask (which we encourage!) after a course is over. Tailored course offerings are conducted on-site at client locations. Few independent training companies have been providing SAS training longer or better than SYS-ED.

Interelated Information Technology

SAS Training Courses

Technology Driven IT Training

SYS-ED courses utilize a combination of industry standard text books (which we review for technologist entrepreneurs and industry leading text book publishers) and our own consultancy derived courseware and training aids. The classic principles of adult learning are applied to interpreting and translating subject matter into performance objectives, narrative descriptions, and diagrams which trace the design, architecture, and program logic to industry- and client-specific examples. The courseware utilizes a variety of presentation formats: textual, tabular, and diagrammatic, bullet point, and code snippets. SYS-ED's SAS courseware has been incrementally augmented, revised, and maintained. It is highly respected in evolutionary information technology.

Review our Courseware

Consultation Prior to Accepting a Training Assignment
or Enrolling an Employee in a SYS-ED Course
It is standard operating procedure to schedule a telephone consultation with our Director of Education or Curriculum Manager. As part of this process we will review the subject matter, sample programs, workshops, and installation standards and provide a training plan in writing. For organizations evaluating whether to send an employee to a SYS-ED course, we will require that a profile form be completed and submitted both by the manager and the employee who will be trained. It is our prerogative to ensure that the employee has the prerequisite background for the training. Not everyone is allowed to enroll in a SYS-ED course.

Learning Paths

SAS MS Networks and
Operating Systems

UNIX Web Design

Mainframe Databases

DB2 Oracle

Advanced search

In order to review and print course topics, prices, and dates, invoke the Search button.

Tailored SAS Training

Consultancy Experience

Grow Your Own SAS Programmers

Over the past year, we have had a number of inquiries regarding whether SYS-ED still offered SAS courses for business and IT professionals.

The typical comments were:

1. That there is a scarcity of fast-track SAS courses, 5 or fewer days in duration, geared to Fortune 1000 corporations, government municipalities and their employees.

Portfolio of SAS Clients

2. That it is extremely difficult to find tailored SAS training with the specialized skills requirements needed for querying and managing data.

3. That SAS “educational consulting” were a key component in helping Fortune 1000 companies and government municipalities meet their informational technology operational requirements.

In response to these questions:		Caveat Emptor Prior to scheduling a SAS course from SAS Institute, contact SYS-ED and compare the quality of training service that we offer: Review our SAS learning paths. Read the technology assessments and CFAQs - course frequently asked questions. Examine the content in our courseware and training aids. Utilize our SAS skillset assessments. Interview our system consultant/instructor.
	Yes, SYS-ED offers multiple levels of SAS training across a comprehensive range of operating environments and platforms.
	Yes, since the early 1980’s, SYS-ED’s system consultant instructors have taught the SAS language and we offer a coordinated sequence of SAS courses.
	Yes, we have the flexibility and resources to conduct courses for small groups; with a minimum class size as few as three employees.

Why SYS-ED for SAS Training?

Get on the Fast Track .......

	Hands-on training	Web-based Training Services
	Superb courseware and training aids
	Mainframe New York Schedule
	Resources to accommodate small groups
	Tailored private courses - North America and Europe
	Warranty of Service
	Satisfied customers and industry testimonials
	Qualified training consultant for needs analysis and skills inventory
	Distance and e-learning

Mainframe

Value Added SAS Training

SAS Technology Update

SYS-ED SAS courses have been developed in accordance with the classic principles of adult learning theory. The content and presentation of subject matter reflects our longstanding role as system analysts, application programmers, and webmasters.

Transitioning from older versions of the SAS software to the new web based model.	Migrating and upgrading applications to the emerging service oriented architecture standard.
Logical and physical design and performance optimization.	Design of the interface and presentation format.
Explanation of the protocols serving as the foundation of web services and its utilization with SAS.	Guidance on web development utilizing open source and proprietary frameworks.

Consultancy Derived SAS Courses

These courses have been developed in response to requests by our clients. SYS-ED SAS courses will be tailored to address the specific training needs and operational objectives of the target audience.

SAS Courses for Business Professionals

SAS: Processing Database and Spreadsheet Data with SAS/ACCESS Software

SAS: Report Writing:
A Programming Approach

SAS: Macro Language

SAS Programming Concepts -
Introduction

You will learn:

accessing data in relational database or MS Excel workbook.
using the SAS/ACCESS LIBNAME statement.
using the SQL pass-through facility.
working with joined tables.
importing and exporting PC file data.
creating and updating SAS/ACCESS and view descriptors.

You will learn:

producing reports with the macro facility.
using the DATA step in conjunction with the REPORT procedure.
creating detail, summary, and tabular reports.
using the ODS - Output Delivery System.
creating HTML output.

You will learn:

the operation of the macro facility and the macro language.
the syntax used in the macro language.
defining macro variables and passing macro parameters.
utilize the different macro referencing environments and scopes.
the phases of execution when macro statements are present.
how to develop and call SAS macros.
referencing SAS macro functions and automatic macro variables.
using macro statements within SAS macros.

You will learn:

data processing terminology.
the steps involved in programming.
how to use the components of a SAS program.
how to use the SAS programming facility.
handling raw data.
using the Proc step.
creating and using variables.
how to use conditional statements.

SAS Courses for IT Professionals

SAS: Programming I:
Essentials

SAS: Programming II:
Manipulating Data with the DATA Step

SAS Programming III:
Advanced Techniques

SAS Programming

You will learn:

writing and maintaining SAS programs which produce reports.
reading and writing temporary and permanent SAS datasets.
PRINT, FREQ, MEANS, FORMAT and CONTENT procs.
how to use and work with temporary and permanent SAS data sets.

You will learn:

how to use the DATA step for controlling SAS data set input and output.
how to combine SAS data sets.
summarizing data.
processing data iteratively with DO loops and arrays.
performing data manipulations and transformations.

You will learn:

creating and ordering datasets.
combining data with common variables.
combining data with an index.
combining a dataset vertically.
the TRANSPOSE procedure.
lookup tables.
how to use the SPD engine.
how to modify SAS datasets.

You will learn:

SAS PROCS.
SAS language statements.
working with SAS datasets.
creating outputs and reports.
how to submit SAS jobs.
how to perform statistical analysis.
plotting charts.

SAS Training Roadmap

Integrated Training Programs

Integrated Training Programs - 3 to 6 Weeks in Duration

Mainframe	Internet Programming
Operations and System Programming	WebSphere MQ
Mainframe Training	Java
Legacy Programming Languages	Oracle
CICS	.NET

Evolving IT: Interrelated Technologies

Web Servers

WebSphere MQ Middleware

Internet Programming

There are new web server and web enabling technologies which in many cases will require integration with the existing mainframe systems and enterprise databases.

SYS-ED trained a significant number of first generation mainframe DP personnel in the 1980’s. And look forward to the opportunity and challenge of training their successors in the 21st century. Albeit, with a more comprehensive set of delivery options for conducting the training and a hybrid mix and match set of software choices.

Select a Development Platform.

Selecting/invoking a course category or related area will provide the course offerings, audiences, and major topics.
SAS Course Category	Database Engine
SAS Fundamentals	DB2 UDB	ORACLE
SAS Programming	IMS	SQL Server
SQL

Operating Environment / Development Platform
Mainframe	MS Windows	Java
Client/Server	UNIX	.NET

SAS Training in New York

SAS Courses
SYS-ED's SAS courses are tough, but they're worth it. Our challenging "hands-on" training draws upon our extensive library of sample programs and case studies to explain, demonstrate, and implement real-world applications. This will provide the foundation and experience to design, develop, and update SAS applications.

Courseware
SYS-ED courseware and training aids have been designed to compliment the class lecture and provide a framework for coding and debugging SAS programs. They also serve as a reference source after a course is over.

Teaching is Our Only Business
Most computer training companies are divisions of large software or consulting companies. Not SYS-ED. Our only goal is to provide quality computer training for highly motivated business and information technology professionals - no more and no less. Because we're independent, we're free to concentrate on teaching - and we do it very well.

Our Teachers Know How to Teach
SYS-ED instructors combine teaching skills with broad practical experience as consultants. And they know to teach. We teach not only "how to" but "why", building a solid foundation in fundamentals and specialized SAS capabilities. After a course, our staff remains available to answer questions.

Enrollment - SYS-ED SAS Courses are NOT for Everyone
No one is allowed to enroll in a SYS-ED SAS course, without a consultation with our Director of Education. We review the operational objectives and project specifications for the organization evaluating whether to send its employee for the training. The employee is only allowed to register if they have the appropriate background corresponding to the correct learning path.

SAS Training in New York, at Your Office, or via the Web
SYS-ED SAS courses are held at our modern, fully equipped training center in Manhattan and in conjunction with technology partners in North America and Europe. Our SAS training is conducted in conjunction with training partners in North America and Europe. If you prefer, we'll arrange tailored SAS training on-site at your organization’s facilities inclusive of mobile computer classroom set-up. On-site courses can include the identical workshops, case studies, and hands-on approach as the SAS training we offer in New York.

For additional information including outlines, availability of private courses, references, and course customization, contact David Shapiro at our New York office at 212-564-9147 or register online.

Technology Exchange Websites
SYS-ED's technology exchange websites compile, organize, and present software specific and established operational categorizations of information technology. They provide a framework for assessing knowledge transfer: learning paths, classroom instruction with a subject matter expert, web-based training, courseware, training aids, and validation assessment.
http://www.sastrainingbysysed.us/commquests.htm
www.programmingbysysed.us	www.databasetrainingbysysed.us	www.crystalreportstrainingbysysed.us
www.mainframetrainingbysysed.us	www.db2trainingbysysed.us	www.oracletrainingbysysed.us

Footnote 1:

SYS-ED’s core SAS curriculum are being prepared for submission to the New York State Department of Education - Bureau of Proprietary School Supervision for technical review and licensing.