Amadeus cookies policy - you'll see this message only once.

Amadeus use cookies on this website. They help us to know a little bit about you and how you use our website, which improves the browsing experience and marketing - both for you and for others. They are stored locally on your computer or mobile device. To accept cookies, continue browsing as normal. Or, go to the privacy policy for more information.

Accept and close

Using Proc FCMP to Create User Defined Functions for Use in SAS® Visual Analytics

Proc FCMP has been available to DATA step programmers since SAS version 9.2 and is recognised as a very valuable procedure for generating user defined functions. Read more...

Posted in SAS Analytics; Tagged SAS Analytics, SAS Visual Analytics, Proc FCMP, Proc SQL; Posted October, 2017 by Amadeus Technical Team

Prevent a SAS Session from Connecting to a SQL Database Until Required

If your SAS environment regularly interacts with SQL databases via ODBC/OLE DB pre-assigned libraries, a common complaint may arise from your SQL DBA team.  By default, when a SAS user... Read more...

Posted in SAS Administration; Tagged SAS SQL, SAS Administration, Proc SQL, Database Connection Management; Posted August, 2017 by Amadeus Technical Team

Executing SQL Stored Procedures Using PROC SQL

The following examples demonstrate the basic syntax required to run a SQL Stored Procedure using SAS PROC SQL. Read more...

Posted in SAS Programming; Tagged SAS SQL, Proc SQL, Stored Procedure; Posted August, 2017 by Amadeus Technical Team

Execute SQL Server Agent Jobs Using SAS

There may be occasions where it is necessary to execute a SQL server agent job from SAS. Before this can be achieved, the following prerequisites need to be met: Read more...

Posted in SAS Programming; Tagged SAS Programming, SAS SQL, Proc SQL, SQL Server Agent, SQL; Posted July, 2017 by Amadeus Technical Team

Proc SQL Merge

Merging data sets can sometimes be easier using an SQL join, particularly when you have more than two tables to merge. Read more...

Posted in SAS Programming; Tagged SAS Programming, Proc SQL; Posted February, 2017 by Amadeus Technical Team

Working with Dictionary Tables

Principal Consultant Elena Muriel describes the use of SAS Dictionary tables within the Proc SQL procedure and the DATA step environment. Read more...

Posted in SAS Programming; Tagged Proc SQL, SAS Dictionary Tables, SAS Programming; Posted February, 2017 by Amadeus Technical Team

Using Database-Specific SQL Features in SAS

Pass-through mode in Proc SQL is most often used to improve efficiency, but that is not the only benefit it can bring. Read more...

Posted in SAS Data Management; Tagged SAS Data Management, Proc SQL; Posted February, 2017 by Amadeus Technical Team

Using the ANY and ALL Operators in Proc SQL

The ANY and ALL operators are Proc SQL operators which can be used to compare the result of a query expression against either ANY or ALL of the results returned... Read more...

Posted in SAS Programming; Tagged SAS Programming, Proc SQL; Posted February, 2017 by Amadeus Technical Team

Outputting a List of Values to a Series of Macro Variables

There are a number of possible ways to extract values from a dataset and store them in a numbered list of macro variables. Read more...

Posted in SAS Programming; Tagged SAS Programming, Proc SQL; Posted February, 2017 by Amadeus Technical Team

Regular Expressions in Proc SQL

Among the functions you can use in Proc SQL is PRXMATCH. At a single stroke, this increases the power of the SELECT statement quite dramatically. Read more...

Posted in SAS Programming; Tagged SAS Programming, SELECT Statement, Proc SQL; Posted February, 2017 by Amadeus Technical Team