How to change the order of variables within a dataset is one of the most frequently asked questions in the SAS world.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 2017
by
Amadeus Technical Team
5 for the price of 1! The colon has several uses in SAS, all of them worth knowing about.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 2017
by
Amadeus Technical Team
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
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