Skip to main Content

Home  >  SAS Training  >  Tips and Techniques

Tips and Techniques


Data Visualisation

Latest Tip | 50 Shades of Grey

If your sensibilities were offended by a book with this title fear not, what follows is a demonstration of requesting any shade of grey on a graph. Actually in SAS we are not limited to 50, we can easily request any of 256 shades of...
Read more...

Installing and Maintaining SAS

Latest Tip | Metadata Functions Part 1

Principal Consultant Elena Muriel demonstrates how to use metadata data step functions to extract information from the metadata server. ...
Read more...

SAS Application Development

Latest Tip | Building Dynamic Menus with Proc PMENU

This tip demonstrates how to build pull-down menus for SAS/AF, SAS/FSP or even the data step windowing environments. The inspiration for this tip was a question raised on Twitter, with a need to create the menus dynamically. A link to...
Read more...

SAS Business Analytics

Latest Tip | Creating a UK Region Map with SASŪ Visual Analytics

SAS Visual Analytics has very powerful geographical presentations, including regions inside countries. In order to work with geographical maps, the data that we are trying to present needs to contain some variables defined with a...
Read more...

SAS Business Intelligence

Latest Tip | Structuring Code in SAS Enterprise Guide

Traditionally SAS programmers were responsible for structuring their code in a logical and efficient manner.  This included the proper use of indentation and spacing to improve the clarity of programs. Across an organisation,...
Read more...

SAS Data Management

Latest Tip | Returning the Libname String for OLE DB and ODBC

Often it is the case that it is unknown what attributes to specify when creating a libname statement when connecting to a database. When connecting via OLE DB it is possible to be prompted by a Data Link Wizard for certain attributes...
Read more...

SAS Macro

Latest Tip | Using the IN Operator with the Macro Language in SAS 9.2

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 less repetitive. In addition the code also runs more efficiently as SAS no longer needs to...
Read more...

SAS Programming

Latest Tip | Creating Spreadsheets Using the Excel Libname Engine

Senior Consultant Andrew Beggs describes how the Excel Libname Engine can be used to output data from SAS to Excel.  It covers the syntax used and demonstrates how the technique makes use of Excel named ranges, in order to manage and...
Read more...

SAS SQL

Latest Tip | Working with Dictionary Tables

Principal Consultant Elena Muriel describes the use of SAS Dictionary tables within the Proc SQL procedure and the Data Step environment. Examples and a discussion of advantages and disadvantages from using both methods is also included....
Read more...

 
Terms & Conditions  |  Site Map  |  Copyright © Amadeus Software 2014