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 | Proc PHREG - Random Statement

The PHREG procedure now fits frailty models with the addition of the RANDOM statement. The (Proportional Hazards Regression) PHREG semi-parametric procedure performs a regression analysis of survival data based on the Cox...
Read more...

SAS Macro

Latest Tip | Using the MPRINTNEST Option

The MPRINT option is an essential tool when developing macros allowing you to see the SAS code generated by a macro within the log. If however one macro makes a call to another which then generates SAS code, this cannot easily be seen and...
Read more...

SAS Programming

Latest Tip | Vector-Valued Formats Using the SCAN Function

The drawback of using a format, rather than a dataset merge, is that you are only (in effect) adding one new column to your original dataset, rather than several. However, a little cunning can overcome this.   Let us take as an...
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