The media is full of interest rate changes at the moment, leading to lots of questions – will it go down? What does this mean for my savings? How will...
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 2017
by
Amadeus Technical Team
The DATA step environment has an internal counter that takes the form of an automatic variable named _N_.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
Monotonic() Function;
Posted
February, 2017
by
Amadeus Technical Team
When defining a format, you can include an existing format as part of the definition, as shown in the following example.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 2017
by
Amadeus Technical Team
The UPCASE function is often used to compare variables against a value in a consistent case or convert existing data to upper case.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
Informat;
Posted
February, 2017
by
Amadeus Technical Team
Proc SUMMARY with the NWAY option will produce a summary of a dataset based on all the combinations of the CLASS variables found in the data.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
Proc SUMMARY;
Posted
February, 2017
by
Amadeus Technical Team
SAS Consultant Andrew Williams will explore the new functions introduced into SAS 9 for concatenating strings together.
Read more...
Tagged
SAS Programming;
Posted
February, 2017
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
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
