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 | Creating an External File in the SAS Workspace

It can sometimes be useful to create a temporary flat file that is specific to your SAS session. If you create the file inside your SAS workspace, no-one else can see it or overwrite it, so you don't have to worry much about what name to...
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 Derived Variables on the Fly

JMP software provides users with the ability to derive new variables through the formula editor window.  However, it is also possible to create variables on the fly, making it easier for users to explore their data from every perspective...
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 | How Will The Interest Change Affect Your Mortgage Payment?

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 it affect me? One of the biggest questions people want the answer to is “How...
Read more...

SAS SQL

Latest Tip | Outputting a List of Values to a Series of Macro Variables

There are a number of possible ways to extract values from a dataset and store themin a numbered list of macro variables. The following macro demonstrates a technique to achieve this using Proc SQL. proc sql noprint; ...
Read more...

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