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

The SCD Type 1 Loader in SAS® Data Integration Studio

SAS Data Integration Studio’s ordinary “Table Loader” – which is categorised as an “Access” transformation – can handle load styles of “replace”, “append” and “insert/update”. Read more...

Posted in SAS Data Management; Tagged SAS Data Management, DI Studio, Data Management; Posted October, 2018 by Amadeus Technical Team

DataFlux: Output a Job Log When Executed from SAS® DI Studio

This SAS tip describes the steps required to output a DataFlux job log, when a DataFlux job has been called and executed from SAS DI Studio. Read more...

Posted in SAS Data Management; Tagged SAS Data Management, Data Management Studio, DMS, DataFlux Integration Server, Scheduled DataFlux Job Log, DI Studio DataFlux Job Log; Posted June, 2018 by Amadeus Technical Team

Looking for Patterns in Data

With the General Data Protection Regulation (GDPR) effective from this year, it is important to be able to identify personal information in data. Read more...

Posted in SAS Data Management; Tagged SAS Data Management, DataFlux, DQ, QKB, PRX, GDPR; Posted May, 2018 by Amadeus Technical Team

Data Management Studio – Performing Tasks on Multiple Variables

Data jobs within SAS Data Management Studio allow users to perform a whole raft of data processing tasks on data items, these include applying business rules and monitoring data. Read more...

Posted in SAS Data Management; Tagged SAS Data Management, DataFlux, Data job, Process job, Custom metrics, Business rules; Posted February, 2018 by Amadeus Technical Team

Man, Woman, Couple or Company?

Suppose we want to work out for each name in our contacts database whether it refers to a company or a man or woman – or perhaps multiple people. Read more...

Posted in SAS Data Management; Tagged SAS Data Management, SAS Data Quality, DQINDENTIFY function; Posted April, 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

Paste Special and Replace Table in DI Studio

There are ways in DI Studio to modify a job so that it uses a different table. Read more...

Posted in SAS Data Management; Tagged SAS Data Management, SAS DI Studio; Posted January, 2017 by Amadeus Technical Team

Using the EXTENDSN Option with Proc CIMPORT

SAS Transport files are used when there is a need to move or copy SAS files between different platforms. For example, SAS data sets and catalogs used in a Windows... Read more...

Posted in SAS Data Management; Tagged SAS Data Management; Posted January, 2017 by Amadeus Technical Team

Zero Filling

There are many occasions when it is desirable to create a template data set containing variables initialised to zero. Read more...

Posted in SAS Data Management; Tagged SAS Data Management; Posted January, 2017 by Amadeus Technical Team

Transactional Updates with NOMISSINGCHECK

If we need to update a master table with a transaction table an UPDATE statement can be appropriate. Read more...

Posted in SAS Data Management; Tagged SAS Data Management, UPDATE statement, NOMISSINGCHECK option; Posted January, 2017 by Amadeus Technical Team

1 2