In SAS 9.2 Proc SORT the 'PRESORTED' option has been added; we can use this option if we believe that our data is already sorted, causing SAS to simply verify...
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
January, 2017
by
Amadeus Technical Team
The usual method of issuing an operating system command is via the X statement (or a similar facility such as CALL SYSTEM, %SYSEXEC or SYSTASK).
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
System Commands;
Posted
January, 2017
by
Amadeus Technical Team
In data step code it is common practice to use an IN operator in place of lots of OR statements, this allows you to write code that is concise and...
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
IN Operator;
Posted
January, 2017
by
Amadeus Technical Team
Here is a line of code from a macro definition. It is supposed to be issuing a Unix command to delete a file. Spot the deliberate mistake!
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
Macros;
Posted
January, 2017
by
Amadeus Technical Team
Here's a macro which executes some code for each month in an interval. Months are assumed to be specified in the format YYYYMM.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
January, 2017
by
Amadeus Technical Team
Until V9, there was a potential shortcoming when using compiled stored macros; only the compiled form was stored by SAS, so that you had to make sure you didn't lose...
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
January, 2017
by
Amadeus Technical Team
Various techniques are available. We are going to demonstrate several of them by looking at the problem of removing multiple commas from strings containing lists.
Read more...
Posted in
SAS Programming;
Tagged
Text Strings,
SAS Programming;
Posted
January, 2017
by
Amadeus Technical Team
Arguably one of the most common arithmetic calculation headaches that most programmers encounter in their programming life is the division by zero scenario.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
DIVIDE function;
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