A very efficient way of defining Formats and Informats is to use an Input Control Data Set with Proc Format, rather than writing VALUE or INVALUE statements.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 2017
by
Amadeus Technical Team
Suppose we run the following code, PRODGRP being a new variable not present in SASHELP.SHOES:
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 2017
by
Amadeus Technical Team
When using 'by group' processing to output reports, the #byval function can be used to include the name of the 'by group' within the title.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 2017
by
Amadeus Technical Team
Often it is the case that it is unknown what attributes to specify when creating a libname statement when connecting to a database.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 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
When debugging a program, it is often helpful to include PUT statements within a DATA step, in order to list the values of one or more variables in the log window.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
PUT Statements;
Posted
February, 2017
by
Amadeus Technical Team
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
A new procedure was introduced with SAS 9.3 that allows SAS Intelligence Platform Administrators to programmatically interact with various types of SAS server. Consider the following example.
Read more...
Posted in
SAS Business Analytics;
Tagged
SAS Business Intelligence;
Posted
February, 2017