Tips and Techniques
-
A to Z of Data Step Functions
Latest Tip
Finding a Words Start Position October 2011
The SCAN function provides a flexible way of finding the nth word in a character string, by allowing searches to be conducted in either direction along the string and through ... Read Full Article
-
Business Intelligence Platform
Latest Tip
Using Proc METACLEANSE March 2010
Proc METACLEANSE is a procedure in SAS 9 that allows you to clean up repositories. Read Full Article
View all Tips & Techniques in Business Intelligence Platform
-
Data Transformations
Latest Tip
The INDSNAME Option January 2012
The INDSNAME option provides a convenient way of capturing the name of the SAS table which is contributing to the current observation being read into the data step. Read Full Article
-
General
Latest Tip
Organise Your Calendar With SAS December 2011
There are many calendar applications available, such as Microsoft Outlook, Google Calendar, Lotus Notes, iCal, the list goes on! Read Full Article
-
Macro
Latest Tip
Deleting Macro Variables August 2011
Each SAS session has a finite amount of memory allocated to for macro variables Read Full Article
-
Output Delivery System (ODS)
Latest Tip
Outputting Formulae to Microsoft Excel December 2011
The ExcelXP tagset is a popular method of outputting data to Microsoft Excel from SAS. Writing data values is straightforward, but can we output an Excel formula? The answer i... Read Full Article
-
SAS Formats
Latest Tip
The GROUPFORMAT Option January 2012
The GROUPFORMAT option can be used in the data step to apply by-group processing to formatted ranges of values. Read Full Article
-
SQL
Latest Tip
Using Database-Specific SQL Features in SAS May 2011
Pass-through mode in Proc SQL is most often used to improve efficiency, but that is not the only benefit it can bring. It can also make available to the SAS user SQL syntax wh... Read Full Article
