Skip to main Content

Home  >  SAS Training  >  Tips and Techniques

Tips and Techniques


Data Visualisation

Latest Tip | Using the COLUMNS=Option with ODS RTF and PDF Destinations

In SAS 9, you can use the COLUMNS= option with ODS RTF and PDF destinations to split output across a specified number of columns.  This is particularly useful when you are generating lengthy output that consists of only a few columns, as...
Read more...

Installing and Maintaining SAS

Latest Tip | The USER Library

A one-level dataset name does not have to default to the WORK library. You can use the USER option to assign your default library somewhere else.   If you do this, SAS will still use WORK for its own temporary datasets (such as those...
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 | Two Nations Divided by Uncommon Date Formats

Does 12/06/2004 mean the 12th of June or December 6th? It depends which side of the pond you happen to be sitting.   With V9, SAS introduced new informats ANYDTDTE, ANYDTDTM and ANYDTTME to handle the input of respectively dates,...
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 | Undo Append

This tip is a utility macro that allows a proc append to be re-run without adding the same data again. This is particularly useful if the appended data is found to have errors after the first run and we want to ‘undo’ the original append...
Read more...

SAS Programming

Latest Tip | The Versatile Colon

5 for the price of 1! The colon has several uses in SAS, all of them worth knowing about.   In a “name prefix list” of variables   In contexts where a list of variables is required, the colon is a wildcard...
Read more...

SAS SQL

Latest Tip | Regular Expressions in Proc SQL

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. Now you can select records that match regular expressions. This first example is...
Read more...

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