JMP software provides users with the ability to derive new variables through the formula editor window.
Read more...
Posted in
SAS Analytics;
Tagged
SAS Analytics,
Derived Variables,
JMP Software;
Posted
February, 2017
by
Amadeus Technical Team
Proc TABULATE is a very powerful procedure used for producing reports. It can generate detailed cross-tabulations of data, and has a number of inbuilt statistics to choose from.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
Proc TABULATE,
CLASS Statement,
VAR Statement;
Posted
February, 2017
by
Amadeus Technical Team
Converting currencies in SAS can often be a struggle. We can create our own formats that use up to date exchange rates to convert between any currencies worldwide.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 2017
by
Amadeus Technical Team
There are a number of possible ways to extract values from a dataset and store them in a numbered list of macro variables.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
Proc SQL;
Posted
February, 2017
by
Amadeus Technical Team
This may be easier than you thought - though you will find yourself using %SYSFUNC rather a lot.
Read more...
Posted in
SAS Programming;
Tagged
SAS Macro,
SAS Programming,
%SYSFUNC;
Posted
February, 2017
by
Amadeus Technical Team
Among the functions you can use in Proc SQL is PRXMATCH. At a single stroke, this increases the power of the SELECT statement quite dramatically.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
SELECT Statement,
Proc SQL;
Posted
February, 2017
by
Amadeus Technical Team
Here are some assorted tips related to Proc SORT. First, let’s look at the detection of duplicates.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
Proc SORT;
Posted
February, 2017
by
Amadeus Technical Team
Does 12/06/2004 mean the 12th of June or December 6th? It depends which side of the pond you happen to be sitting.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 2017
by
Amadeus Technical Team
… they’re a waste of time, but I couldn’t possibly not comment!
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 2017
by
Amadeus Technical Team
A very useful feature available in SAS9.2 and later is the SCAPROC procedure, which captures information about inputs and outputs to a separate log file whilst a SAS job is...
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 2017
by
Amadeus Technical Team