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 | Paste Special and Replace Table in DI Studio

There are ways in DI Studio to modify a job so that it uses a different table. One simple and convenient way of doing this is to right-click on the table, and choose “Replace”. Thus the following little job …    ...
Read more...

SAS Business Analytics

Latest Tip | Data Mining: Sampling Data

Data preparation is a large part of the data mining process.  A large part of data preparation includes creating representative samples within the data to speed up the data mining process.  SAS Enterprise Miner™ software has a large...
Read more...

SAS Business Intelligence

Latest Tip | Retrieving Individual Objects from a SAS Enterprise Guide Project

File Extension Manipulation SAS Enterprise Guide projects often contain embedded items such as SAS Code, log files, results files, graphs and more.  Users may wish to separate these items from a SAS Enterprise Guide project and...
Read more...

SAS Data Management

Latest Tip | Conditional Execution in DI Studio

DI Studio V4.8 includes, for the first time, facilities to allow parts of a job to be executed conditionally. Previously, conditional execution had to be done either at a lower level (typically within a user-written code node) or at a...
Read more...

SAS Macro

Latest Tip | Using Macros to Input Multiple CSV Files into a Data Set

This tip highlights how simple it can be to read in multiple CSV files and output them as a single SAS Data Set utilising the FILENAME command and the PIPE device-type keyword. The PIPE device-type keyword in the FILENAME statement...
Read more...

SAS Programming

Latest Tip | Retrieving Files from an SFTP Site

In an age where secure transfer of data becomes increasingly important, we regularly find ourselves being asked to retrieve data via Secure File Transfer Protocol (SFTP). To do this via SAS we could go down the route documented on the SAS...
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 2017