home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral Soft skills Introduction to HW & SW TracksOperating systems MVS - z/OS UNIX - Linux - AIX Mac OS X iPad and iPhone iOSDatabases, transaction systems and middleware DB2 for z/OS DB2 UDB for Linux, UNIX and Windows Oracle SQL Server MySQL IMS CICS WebSphere MQ WebSphere Application Server Data warehouse, business analytics and big dataApplication development Methods and techniques TOGAF PRINCE2 Agile development and Scrum Programming languages Internet development Object Oriented systems Java IBM development tools SAS XML SOA & web servicesSystems management ITIL SecuritybalkjePractical informationRegistration 
SAS programming part 1: fundamentals

Intended for

Analysts, programmers, info-center support and experienced end-users. The course is suitable for both mainframe and PC users. Although "SAS on mainframe" is used in the labs, "SAS on Windows" is available for those delegates that never work in a mainframe terminal session. The statements and commands, as well as the context discussed are the same on all platforms.

Background

PC and/or terminal experience and experience with program structures are required.

Training method

Instruction using overhead visuals combined with terminal demonstrations. Exercises take up much of the time.

Course leader

Koen De Backer, Sandy Schillebeeckx.

Duration

3 days.

Schedule

datelanguageplacepriceremarks
28/04/2014 Leuven1290 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

Objectives

This course is designed for those who are going to use SAS to analyze data and build applications. It will meet the needs of users entirely new to SAS and of those with some SAS experience. The SAS/base product will be covered in detail. The course content and level make the course version independent, version 9 for SAS on mainframe is used in the labs.

At the end of the course, the students will be able to write SAS programs that can be executed interactively as well as in batch. This is not a 'point 'n click' course; participants will write their own coding. In this respect the course teaches the "classic" approach to SAS, using the typical building blocks of a SAS program. SAS programming part 1: fundamentals explains the essentials for understanding and writing SAS code, SAS programming part 2: digging deeper adds SAS Base features (SQL in SAS, using database tables, what is ODS, ...) that in most companies are very often used. Those of you that are interested in building reusable code, should also attend SAS programming part 3: macro essentials that explains the SAS Macro Language.

Main topics

  • Introduction: SAS features and possibilities • SAS products • program use.
  • SAS Display Manager: interactive development of SAS code • Display Manager navigation • SAS standard data libraries.
  • SAS language • syntax • variables • SAS dataset • working concept.
  • SAS code: Data Step • SAS instructions • SAS expressions • program logic • dataset processing: merge, subset.
  • Date expressions in SAS.
  • SAS functions, overview and use.
  • SAS analysis and reporting, the Proc Step:
  • standard reporting (SORT, PRINT, FORMAT).
  • statistics and summary tables on Base SAS level (MEANS, FREQ).
  • SAS Utility Procedures: COPY • CONTENTS • DATASETS.
  • INPUT/PUT: reading data into SAS and writing data from SAS.
  • Dataset manipulations: APPEND, MERGE, subset(IF, WHERE) and UPDATE.
  • Macro variables in a SAS program: what it is and why/how to use them.
  • Additional procedures - UNIVARIATE - PLOT - CHART.