The ODS TABLEEDITOR tagset enables us to produce sophisticated HTML reports which exhibit similar characteristics to reports created using Microsoft Excel or Visual Basic .NET.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
TABLEEDITOR Tagset,
HTML Reports,
ODS;
Posted
January, 2017
by
Amadeus Technical Team
The ExcelXP tagset is a popular method of outputting data to Microsoft Excel from SAS. Writing data values is straightforward, but can we output an Excel formula? The answer is...
Read more...
Posted in
SAS Analytics;
Tagged
SAS Analytics,
Microsoft Excel;
Posted
January, 2017
by
Amadeus Technical Team
Deploying a new version of Enterprise Guide across an organisation can be challenging, with pre-requisite installation requirements and compatibility of current EG projects as important considerations.
Read more...
Posted in
SAS Analytics;
Tagged
SAS Analytics,
SAS Enterprise Guide;
Posted
January, 2017
by
Amadeus Technical Team
Many SAS users know about the ODS TAGSETS.EXCELXP destination used to create Excel Workbooks from SAS output.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
January, 2017
by
Amadeus Technical Team
SAS 9.2 introduces security options for creating PDF documents with ODS statements. The options allow you to password protect a PDF file and control if copying from the document is allowed.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
January, 2017
by
Amadeus Technical Team
To remove the procedure title, for example: "The FREQ Procedure" from the output window you can use the ODS statement:
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
January, 2017
by
Amadeus Technical Team
The GROUPFORMAT option can be used in the data step to apply by-group processing to formatted ranges of values.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
January, 2017
by
Amadeus Technical Team
The introduction of SAS 9.2 has seen a number of new data step options added that provide simple solutions to common programming problems. The INDSNAME option provides a convenient way...
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
January, 2017
by
Amadeus Technical Team
In SAS 9.2, Proc FCMP can be used to define functions and subroutines that can be used in data steps. Within Proc FCMP itself, several special functions are available.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
January, 2017
by
Amadeus Technical Team
Proc SUMMARY and Proc MEANS are essentially the same procedure. Both procedures compute descriptive statistics. The main difference concerns the default type of output they produce.
Read more...
Posted in
SAS Analytics;
Tagged
Proc SUMMARY,
Proc MEANS;
Posted
January, 2017
by
Amadeus Technical Team