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
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
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 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
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
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
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
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
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
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