- Home
- Account
- Basket
- Checkout
- Contact Us
- Educational Portal
- SAS Software
- Consultancy
- Data Science
-
SAS Training
-
SAS Courses & Bookings
- Fast Track Fundamentals and Programming
- SAS Fundamentals
- Fundamental Report Writing with SAS
- SAS Programming
- Advanced Report Writing with SAS
- SAS Macro
- SAS Enterprise Guide
- Advanced SAS Programming
- Fundamental SAS SQL
- Advanced SAS SQL
- Fundamental ODS Graphics
- Advanced ODS Graphics
- Fundamental Business Statistics for SAS
- Regression for Predictive Analytics
- Time to Event Data Analysis
- SAS Fundamentals CPD Revision Webinar
- SAS Programming CPD Revision Webinar
- SAS Macro CPD Revision Webinar
- Live Webinar: Using the SAS ODS Graphics Designer
- Workshop: Fundamental SAS Platform Administration
- SAS Studio
- Advanced SAS Macro
- Workshop: Fundamental SAS Visual Analytics
- On-Demand: Using SAS to Create Microsoft Excel Reports
- On-Demand SAS Macro
- On-Demand: Descriptive Statistics with Base SAS
- Public SAS Training
- On-Site SAS Training
- On-Demand SAS Training
- Training Prices
- On-Site Prices
-
SAS Courses & Bookings
- Managed Services
- Graduate Placement
- About Amadeus
-
News
- Free Visual Analytics Seminar
- Online Payments Now Accepted
- Celebrating 25 Years With a New Office
- Visualising Big Data
- Meet Amadeus at the SAS Professionals 2014
- Prime Minister David Cameron Visits Amadeus
- Meet Amadeus at the PhUSE Annual Conference 2014
- Senior Consultant Required
- An Introduction to SAS Visual Analytics for the Health Care Sector
- 2015 SAS Training Dates Published
- Meet Amadeus in Dallas, USA
- New for 2015: Time to Event Data Analysis
- 10% Discount Code On-Demand Training
- Amadeus Software Appointed Crown Commercial Service Supplier
- Presenters Wanted - PhUSE 2015
- SAS Visual Analytics Certified Consultants
- Are You Ready to Modernise Your SAS Platform?
- Amadeus Software Signs SAS Reseller Agreement
- Take Our Survey and Win Amazon Vouchers
- Join Our Team
- 2016 Public SAS Training Schedule
- Graduates Wanted
- Customer Satisfaction Survey Results
- SAS Certified Business Analytics Platform Deployment Consultants
- New Manchester Office
- Amadeus - UK SAS Delivery Partner of the Year
- Amadeus Delivers Global, Business-Critical Training Programme
- Save the Date - SAS Forum UK 2016
- Your Secure, Performant and Scalable SAS Platform
- Building Excel Reports Using SAS Software - Survey
- Amadeus Supports University to Improve Academic Performance
- Live On-Stand Demonstrations at the SAS UK Forum 2016
- Thank You For Visiting Our Stand - SAS Forum UK
- On-Demand SAS Macro Offer
- 2017 Public SAS Training Schedule
- Amadeus Satisfaction Survey 2016
- 20% Off Amadeus Public SAS Training Courses
- Amadeus Software Earns Specialisation in SAS Customer Intelligence
- Join Us at the 2017 SAS Global Forum
- Host Your SAS Environment in the Cloud with Amadeus Software
- Dig Deeper Into Your Data with SAS Software
- Why Upgrade and Migrate Your SAS System?
- Blog: Master Data Management – The Trusted Customer View
- Blog: What is Modernisation?
- Top Ten Reasons for Attending SAS Global Forum
- Blog: SAS Viya
- Amadeus Technical Team Awarded SAS Data Management Competency Badge
- Five Common Challenges Faced by CDOs
- Amadeus Achieves SAS Visualisation Competency
- Transform Your Marketing Campaigns with SAS Customer Intelligence
- Amadeus Launches a Brand New Graduate Placement Programme
- SAS® Viya™: Unifying SAS Usage via Hybrid Analytics
- Identifying the Optimal Pricing Strategy for Your Organisation
- In.Form: The Data Entry Solution from the Experts in SAS
- Amadeus Adds to Awards with Specialisation in Analytic Modernisation
- What is Analytics?
- SAS Forum UK 2017
- Modernise Your Analytics to Maximise Returns
- Key Notes from the SAS Forum UK 2017
- Amadeus Survey 2017 - Share Your Thoughts Here
- Approachable Analytics: What it is, How to Achieve it and Why You Want to
- Openness: SAS Embraces Open Source to Deliver an Integrated Enterprise Analytics Platform
- Amadeus to Present at SAS® Global Forum ‘18
- Scale: Balancing your Compute Capability Against Demand
- Amadeus Software Survey 2017 – Results
- Futureproofing Your Organisation’s SAS Usage Through Optimised Processes
- How and Why Identify Personal Data Within SAS®?
- What is Data Visualisation and How Can it Support My Organisation?
- SAS Forum UK – 18 – 19 June 2018
- Are You Struggling to Maintain Data Quality?
- Amadeus Business Update: We’ve Moved!
- AI in the Analytics Industry: Takeaways from SAS Forum UK
- Join Amadeus as We #PassOnPlastic
- Explore the New Amadeus Head Office
- Embracing Open Source within Amadeus’ Graduate Placement
- SAS Global Forum: Call for Content
- SAS User Group UK and Ireland – Get Involved
- Team Building in the Brecon Beacons!
- Cloud: The Future of Analytics and Data Science
- Amadeus Software: Technology Partner of Amazon Web Services
- Data Analytics: the Right Information to the Right People at the Right Time
- Data Management for Data Science
- Have Your Say: 2018 Amadeus Satisfaction Survey
- Join Amadeus at London’s SAS User Group on December 6th
- PhUSE 2018 - Graduate Placement Presentation
- SAS Global Forum 2019, Dallas – Join Us
- Amadeus Satisfaction Survey: The Results
- John Dalton Joins Amadeus Software as Managing Director
-
Tips
- Using the COLUMNS=Option with ODS RTF and PDF Destinations
- The COMPBL Function for Compressing Embedded Blanks
- Useful String Functions: strip, scanq, substrn
- The Enhanced COMPRESS Function
- LARGEST and SMALLEST Functions
- Returning the Right Length
- Time Shifting
- Getting the Most out of the INTNX Function
- Incrementing Character Values
- Reading Backwards!
- Finding a Words Start Position
- Precision Floors and Ceilings!
- Find and Replace in SAS
- Let SAS Help You Plan Your Next Holiday
- Using Proc METACLEANSE
- Distributing Options to Groups of Enterprise Guide Users
- Creating Custom DI Transformations Using Macro Variables
- Code Formatting in SAS Enterprise Guide
- Automatic Code Execution with SAS Enterprise Guide
- Reconnect Enterprise Guide Query Nodes to New Input Data
- Code Storage Options for SAS DI Studio Custom Transformations
- Convert Your SAS Programs into Enterprise Guide Projects
- Using Regular Expressions When Editing Code in Enterprise Guide
- Proc IOMOPERATE
- Convert Your SAS Enterprise Guide Project into a Stored Process
- Using the LinkTo Feature in Enterprise Guide
- Mass Re-Deployment of Troops
- Using Excel as the Input Parameter to a Stored Process
- Using Proc SUMMARY to Produce Multiple Tables with Varying Statistics
- Using the SELECT Statement
- Transactional Updates with NOMISSINGCHECK
- Using the %DS2CSV Macro
- Syntax Checking SAS Programs
- Moving Data Between Libraries
- Advanced Uses of the Colon Modifier
- Using the ‘PRESORTED’ Option with Proc SORT in SAS 9.2
- Manage Division by Zero
- Zero Filling
- SYSTASK: The Spawn of SAS Programmers
- Managing Division by Zero Exceptions Using the DIVIDE Function
- Using the EXTENDSN Option with Proc CIMPORT
- Removing Unwanted Characters from Text Strings
- Using Proc OPTMODEL to Produce MPS Tables
- Using Proc OPTMODEL to Solve Linear Programming Problems
- How to Keep Secret Code Secret
- Using the IN Operator with the Macro Language in SAS 9.2
- Macro Loops by Month
- Conditionals in Macros
- Stored Macros Where's the Source?
- Viewing the Values of All Current Macro Variables
- Deleting Macro Variables
- How to Pass a Varying List of Parameters to a Macro
- Resolve to Gain Total Control of Macro References
- Outputting Macro Generated Code to a File Using MPRINT
- Validating Macro Parameters for Blind Users with Blind Quoting
- Using the ANY and ALL Operators in Proc SQL
- How to Improve SQL Merges
- Using Database-Specific SQL Features in SAS
- Automatic Filtering of User Data
- When Comments Go Bad
- What Does SAS Stand For?
- Using Formatted PUT Statements when Debugging Code
- Beware of the "<>"!
- Referencing BY Group Values Within Titles
- Using Boolean Values for Variables
- Creating a Stratified Sample of Data Using Proc SURVEYSELECT
- Dates In Foreign Languages
- Reading a File List into a Data Set
- Simulating Proc FREQ Counts with Preloaded Formats
- Returning the Libname String for OLE DB and ODBC
- A Simple Technique for Outputting a Data Set to a CSV File
- Before and After Line Plots with Proc SGPLOT
- Creating a Grouped Bar Chart with Proc SGPANEL
- Dealing with Duplicate Keys
- Useful Library Reference Names
- Organise Your Calendar With SAS
- Turning Off Autoscroll to Improve Run Times
- Removing "Variable is Uninitialized" NOTE Messages
- The End of the World As We Know It?
- 50 Shades of Grey
- Basic Differences Between Proc MEANS and Proc SUMMARY
- Solving Equations Using Proc FCMP
- WHERE as an Output Data Set Option
- The Length Statement and Character Variables
- Getting Previous Values of the Same Variable
- The INDSNAME Option
- Rounding Your Formats
- How Do I Build a Format from a Dataset?
- The GROUPFORMAT Option
- Procedure Titles
- PDF Security
- Naming Excel Worksheets with BY Group Values
- Distributing Connection Profiles to Enterprise Guide Users
- Outputting Formulae to Microsoft Excel
- Producing Enhanced HTML Reports using the ODS TABLEEDITOR Tagset
- Promoting Consistency for ODS Graphics Designer Users
- Creating a Format from a Data Set in SAS Enterprise Guide
- Improving Performance with the SASFILE Statement
- Controlling SAS System Options with GETOPTION
- Using Proc SCAPROC to Analyse the Inputs & Outputs of SAS Programs
- Using the Macro IN Operator
- Creating a Basic Dashboard
- SAS Statistical Graphics Episode 1 - SG Procedures
- Defining Your Own Functions with Proc FCMP
- How to Renew your SAS License
- SAS Statistical Graphics Episode 2 - Introduction to Graph Template Language (GTL)
- Concatenating Strings in SAS 9
- Conditional Processing in SAS Enterprise Guide
- Using Abbreviations
- Working with Dictionary Tables
- Defining Your Own Functions with Proc FCMP Episode 2
- Metadata Functions Part 1
- Creating a UK Region Map with SAS Visual Analytics
- Sorting Variable Names Alphabetically
- Creating Spreadsheets Using the ExcelXP Tagset
- Creating Spreadsheets Using the Excel Libname Engine
- Structuring Code in SAS Enterprise Guide
- Using the IFC and IFN Functions
- Creating Analyses That Can Then be Applied to Any Data Set
- Change Your Default File Path
- Creating an External File in the SAS Workspace
- Creating Derived Variables on the Fly
- Creating Professional Reports Using Proc TABULATE
- Displaying Absent Combinations of Classification Variables with Proc SUMMARY
- Dynamic Currency Converting Formats
- Handling Case with an Informat
- Including an Existing Format Within a Format Definition
- The Monotonic() Function
- How Will The Interest Change Affect Your Mortgage Payment?
- Outputting a List of Values to a Series of Macro Variables
- File Manipulation in SAS Macro
- Proc SQL Merge
- Regular Expressions in Proc SQL
- Sorted
- Two Nations Divided by Uncommon Date Formats
- You May Very Well Think That…
- Using the SAS Code Analyser Procedure
- The USER Library
- The Versatile Colon
- Undo Append
- Using the COLUMNS=Option with ODS RTF and PDF Destinations
- Writing Efficient Testing Conditions
- Customising Your SAS Log
- Creating an Output Data Set from a Format
- Proc PHREG - Random Statement
- Using the FILENAME PIPE Option to Run DOS Commands
- Using the MPRINTNEST Option
- Vector-Valued Formats Using the SCAN Function
- Interactively Generating a Data Query in SAS Studio
- Using the SAS Enterprise Guide Program History Feature
- Concatenating Strings
- Linguistic Sorting
- Listing Files in a Directory
- New Uses for WORK Space
- Translating SAS Visual Analytics Reports to Foreign Languages
- Exporting SAS Data to a ZIP File
- Using Macros to Input Multiple CSV Files into a Data Set
- Creating Pop-Up Windows in SAS Visual Analytics with Info Windows
- Reading from a ZIP File
- Cascading Dependencies in Report Prompts
- Formatting with Style
- Job Name and Step Number in DI Studio
- Paste Special and Replace Table in DI Studio
- Piping Operating System Commands
- Display the Current Date in a SAS Visual Analytics Report
- Retrieving Files from an SFTP Site
- Plotting and Shading Maps with ODS Graphics
- Data Mining: Replacing Missing Values
- Exploring SAS Metadata
- Conditional Execution in DI Studio
- Does the Metadata Match the Physical Table?
- Reading Data from a Website
- Data Mining - Sampling Data
- Grid Enabling SAS Programs
- Recursive User-Written Functions
- Man, Woman, Couple or Company?
- Restoring a Backup from a SAS Metadata Cluster
- Running the Cleanwork Utility
- Using the SASHELP Library and the DICTIONARY Tables in DS2
- Subsetting Data Using the MOD Function
- Execute SQL Server Agent Jobs Using SAS
- Getting the FINFO from Your Files
- Executing SQL Stored Procedures Using PROC SQL
- Prevent a SAS Session from Connecting to a SQL Database Until Required
- Using the INFOMAPS LIBNAME Engine
- Data Mining: Removing Variables
- Passing Parameters into a SAS Visual Analytics Report
- Creating SAS Environment Manager Saved Charts
- Using Proc FCMP to Create User Defined Functions for Use in SAS® Visual Analytics
- DOSUBL, Macros and Gini Coefficients
- Directed Data Mining: Simple Linear Regression
- Data Mining: Transforming Variables
- Model Comparison with SAS® Visual Statistics
- Using Lua Instead of SAS® Macro Language
- Clustering in SAS® Visual Statistics
- Concatenating WORK Library Locations
- Data Management Studio – Performing Tasks on Multiple Variables
- SAS® Viya™: Starting a CAS Session
- SAS® Viya™: What is a Caslib?
- SAS® Viya™: Viewing Active Caslibs
- SAS® Viya™: Load SAS Data from a Libname to a Caslib
- Looking for Patterns in Data
- Maps in ODS Graphics – Proc SGMAP
- SAS® Viya™: Load a CSV File to a Caslib
- SAS® Viya™: Viewing CAS Tables Within SAS Studio
- DataFlux: Output a Job Log When Executed from SAS® DI Studio
- Visual Analytics: LASR Memory Utilisation & Table Reporting
- Where in the World Are You With SAS® Visual Analytics?
- Why is the RAND function better than RANUNI and RANNOR?
- Maintaining Application Debug Information using Log4J and Log4net
- The SCD Type 1 Loader in SAS® Data Integration Studio
- Starting a Windows SAS® Web Application Service with Debug Logging
- Cleaning Up Your Web Logs to Improve Start-Up Times for Web Applications
- Partition Your Data for Predictive Modelling
-
Technical Papers
- Rich Handsome & Successful
- A Comparison of SAS versus Microsoft Excel and Access
- The Perl in the Crown: Regular Expressions in SAS
- Twenty-Six Characters in Search of a Function
- Get Funky with %SYSFUNC
- An Introduction to the Macro Facility
- Hashing Performance Time with Hash Tables
- Proc SCAPROC - SAS Logging Unleashed
- The SAS System in the Pharmaceutical Industry
- To ODS RTF and Beyond
- What NOT to Code
- An Introduction to Proc Report
- Here We Go Loopy Do
- Methods of Exporting Data to ASCII or EBCDIC
- Proc Format Uncovered
- Proc Print To Be Proud Of
- SAS9 Reporting in For Business
- They SQL Here They SQL There
- Development and Implementation of a Statistical Programming Environment
- My Enterprise Guide
- Making ODS Graphics Templates Generic
- A Visual Revolution - Statistical Graphics in SAS 9.2
- Annotating SAS Graphs
- Cool Screen Backgrounds Using SAS Graph
- Customising SAS OQ to Provide Business Specific Testing of SAS Installations and Updates
- New Light though Old Windows - Delivering Real Time Information with Windows 7 Desktop Gadgets
- Metadata for SAS9 Programmers
- Exploring the Metadata Family Tree
- From Tiers to Intelligence
- Migrating 4GL SAS Code
- Solving Performance Problems in the SAS Environment with Solid State Drives
- Solving the Source Control Issue
- Managing Complex SAS Upgrades
- Modernise your SAS Platform
- SAS Big Brother
- Analytics of Things: Golf a Good Walk Spoiled?
- Unleashing the Power Behind Stored Processes
- Auditing in SAS® Visual Analytics
- Mind-Map the Gap - Sentiment Analysis of Public Transport
- SAS® and Python: The Perfect Partners in Crime
- Come On, Baby, Light my SAS® Viya®: Programming for CAS
- Troubleshooting your SAS® Grid Environment
- Resources
- Careers
- Ts&Cs and Privacy Policy
- Checkout
- Redirect SAS Training