SAS ACT Users Group l SAUSAG
  Chair's Message  |  Presentations  |  Registration | Tips
   

2010

 
11 February 2010    
Softscape Solutions Jerry le Breton

Reporting from your SAS BI Metadata

SAS metadata repository contains a wealth of information – if you know how to get at it. This presentation shows how to extract and report on this valuable resource.

Department of Human Services Christine Evans EG 4.2 Tips
Making the most of your windows space.
Department of Education, Employment and Workplace Relations Michael Thompson EG, SQL & Graphs
SAS has come a long way since the 90s and a lot of the time we are not taking advantage of better and easier ways to get our work done. This presentation will show a few techniques you can use tomorrow to help get through more of that mountain of work.
Department of Education, Employment and Workplace Relations Doug Gordon Quality Assurance with SAS
This presentation will discuss some techniques for using SAS STAT to provide Quality Assurance on large tables.

2009

 
19 November 2009    
Altis Consulting Pty Ltd Simon McAlister

Regular expressions for business and pleasure

Using regular expressions to match, substitute and extract text data. Creative uses of regular expressions for non-text data. A chance to put your knowledge to use in a word-find challenge.

Australian Bureau of Agricultural & Resource Economics Walter Shafron Turtles all the way? - SAS recursive macros
A desire to document the derived variables in ABARE's database led to recursive macros which, if doable, would be the most elegant solution.
SAS Institute Jim Watson Geo Coding
Producing SAS Map Graphics
 
20 August 2009    
Department of Human Services Christine Evans

EG4.2 Tips

Enterprise Guide 4.2 Tips

Australian Bureau of Statistics John Moore Enterprise Miner
SAS Enterprise Miner to Find Factors Associated with 2006 Census Non-Response
SAS Institute Travis Murphy BI 9.2
What’s coming in SAS9.2 BI
SAS Institute Jim Watson SAS Foundation 9.2
What's coming in SAS9.2 Foundation
 
14 May 2009    
Kohlbahdin Brian Watts

SPDE Tips and Tricks

Exploring the SAS Scalable Performance Data Engine for rapid data delivery

Australian Taxation Office Fuchun Luan Counting Files with SAS
A sequel to the last SAUSAG presentation by Jim Watson - using SAS to scan directories, counting (number, size, type etc) and processing multiple files, and clear disk hogs!
Softscape Solutions Jerry Le Breton Dynamic parameter values for stored processes
Dynamic parameter values for stored processes, and how to hack your metadata
SAS Institute Jim Watson Finding missing data with SAS
How to impute rows and values that don't exist
 
12 February 2009    
Altis Consulting Pty Ltd Simon McAlister

DI Studio: iterative jobs to process all files in a directory

Iterative DI studio jobs to automatically find and process all files in a directory

Department of Human Services Walter Shafron Tree and Constellation Macros
Using the %ds2tree & %ds2const to create tree and constellation interactive java applets
SAUSAG Committee Doug Gordon Using OLEDB in Enterprise Guide
Using EG4.1 to develop input for OLEDB connection strings for base SAS
SAS Institute Jim Watson Finding files with SAS
Using SAS code to scan directories, process multiple files, and find disk space hogs!

2008

 
20 November 2008    
SAS Institute Jim Watson

Enterprise Guide for Programmers

How to best utilise your coding skills within SAS Enterprise Guide

The Analytics Group Grish Stromov To Code or not to Code
A Question of DI
SAUSAG Committee Chris Evans Finding a needle in a haystack
Finding some code in a big messy Enterprise Guide project
 
22 May 2008    
Softscape Solutions Fred Wensing

"Selling" SAS Enterprise Guide

Selling SAS Enterprise Guide to people who write their own SAS

SAS Institute Jim Watson Reporting with Style
How to improve the appearance of your output using PROC REPORT
 
21 February 2008    
SAS Institute Jim Watson

Having a good time with SAS

Exploring dates and time in SAS: the way they are stored and how to use them.

FaCSIA Doug Gordon Technical Tips
ODS and the TableEditor tagset; the Data step debugger; playing music with SAS!  
Softscape Solutions Jerry Le Breton A Brief History of SAUSAG
After 50 meetings, how did we start and what have we been up to?  

2007

 
15 November 2007    
SAS Institute Jim Watson

Data Quality Solution - latest updates

The latest on the SAS Data Quality Solution.

Softscape Solutions Jerry Le Breton Technical Tips
Handling duplicate records; IN Operator & integer ranges; IFN/IFC functions; DEQUOTE function; MONOTONIC function.  
   
 
16 August 2007    
FaCSIA David Lawrence

Data Repackaging – Tall and Thin to Short and Fat

Creating a single record with recurring groups from data with a single line per observation.

FaCSIA Doug Gordon Technical Tips
Clearing user macros; saving and restoring user options; setting/using DMS function keys.  
   
 
17 May 2007    
SAS Institute Gavin Goh

Excel with SAS

The different ways to access and interact with SAS within Excel (and Word and Powerpoint).

Australian Taxation Office Fuchun Luan Optimizing Case Selection with Base SAS
Just like its 3GL cousins such as C and C++, Base SAS can be used to program powerful in-depth analytical applications.  
   
 
15 February 2007    
SAS Institute Jim Watson

Creating Multi-Sheet Excel Workbooks with ODS

How to create formatted, multi-sheet Excel reports using the SAS9 Output Delivery System.

e-sens Juliette Bryan Saving time with the FORMAT Procedure
Using proc format to do table lookups, identify unexpected values, avoid large table joins, create variables and use the overlapping ranges feature. 
SAS Institute

Stacey Costello

SAS Versions

The latest releases of SAS software and some of the upcoming features in SAS 9.2

 

FaCSIA Doug Gordon Tech Tips
A few quick tips for the techos: using physical file names in programs; the COMPRESS function;  outputting to Excel. 
   

2006

 
14 November 2006    
SAS Institute Jim Watson

Using SAS Hash Objects in SAS9

How to use the new SAS9 Hash Objects to increase the efficiency of your joins.

ABARE Walter Shafron SAS's links with HTML through Proc Tabulate
Hot links in Proc Tabulate output offered a neat solution to a data editing project, but could it be done? If so, how? Answers to these questions and more. 
SAS Institute

Gavin Goh

Staying Up-to-date with SAS9 Software and Documentation

 

Centrelink Debra Birkby Not another functional review .....
A look at the resolve function and some other new functions in SAS 9.. 
   
 
17 August 2006    
SAS Institute Jim Watson

Perl Regular Expressions

More string handling functions in SAS9.

Australian Tax Office Ray Lindsay Extending SAS/Enterprise Miner – a user’s experience
SAS/Enterprise Miner can be extended with customised SAS Code nodes. Nodes that can assist in variable selection, and model selection will be described. 
SAUSAG Committee

Jerry Le Breton

Gavin Goh

Tech Tips from the Committee

Tips include: using environment variables; changing variable types with EG; creating a program to recreate a dataset.

   
 
18 May 2006    
SAS Institute Gavin Goh

Enterprise Guide 4

The latest features and enhancements for the new version of Enterprise Guide.

Sierra Information Services Andrew Karp Getting in to the Picture Format
A look at an under utilised feature of PROC FORMAT: the PICTURE format.  Create customised display templates for numbers and dates; even a currency converter. 
SAUSAG Committee

Jerry Le Breton

Chris Evans

Gavin Goh

Tech Tips from the Committee

Tips include: cascading autoexec's; finding all your formats; and more.

   
 
22 February 2006    
IBM Global Services Australia Doug Lean, IBM What does my Data Step do?
An introduction to the program that SAS writes for you when you write a Data Step for SAS.
SAUSAG Committee

Jerry Le Breton

Chris Evans

Doug Lean

Tech Tips from the Committee

2005

 
17 November 2005    
Department of Family and Community Services Doug Gordon Developing Enterprise Guide customised add-ins with C# using SAS templates 
SAS Institute Jim Watson Getting value out of SAS indexing
 
18 August 2005    
DEST Chris Evans Click in your macro parameters in Enterprise Guide
Department of Family and Community Services Doug Gordon What are the Options??  A synopsis of data step line options
SAS Institute Gavin Goh Stored Processes with SAS9
Softscape Solutions Jerry Le Breton Live the Dream: Automatically Document SAS Programs
 
19 May 2005    
SAS Institute Neil Doody "I've Only Got a Browser - What Can SAS Do For Me?" (Answer: Web Report Studio 2.1)
Department of Health and Aging Debra Birkby From CSV to ODS & DDE
ESRI Australia Nigel Connolly The SAS Bridge to ESRI
Softscape Solutions Jerry Le Breton Emailing with SAS
 
17 February 2005    
SAS Institute Neil Doody SAS Integration Technologies
Department of Family and Community Services Doug Gordon Peculiar PROCS
Centrelink Fernando Figueiredo Using Fast Lookups, Hash Tables in SAS 9
Canberra Hospital Dr Bruce Shadbolt Improving Health Outcomes & Decision Making through New Web-Services Software

2004

 
18 November 2004    
SAS Institute Alison Morris Text Mining: What's up .doc
Department of Family and Community Services Doug Gordon SAS9 Functions
SAS Institute Falko Schulz Customising and Extending Enterprise Guide
19 August 2004    
Department of Family and Community Services Bob Rehling ASP .NET and SAS
Department of Family and Community Services Doug Gordon SAS9 - First Impressions
SAS Institute Neil Doody Enterprise Guide 3
DEST
Softscape Solutions
Christine Evans
Jerry Le Breton
Technical Tips & Traps - Merge traps and interesting variable names
20 May 2004    
Department of Family and Community Services Bob Rehling .NETing Your SAS Data
Bureau of Tourism Research Phil Carter Publishing surveys results as HTML with ODS
SAS Institute Jim Watson How to Get SAS9!
Softscape Solutions Jerry Le Breton Technical Tips: INTNX funtion
26 Feb 2004    
ABARE Ray Lindsey Using the VIM Editor with SAS
Department of Family and Community Services Doug Gordon A Simple SAS Program Documentation Method
SAS Institute Greg Wood Time Series Forecasting with SAS
Softscape Solutions Jerry Le Breton More Programming Secrets from the Dark Side

2003

4 Dec 2003    
SAS Institute Neil Doody Under the Covers of SAS 9.1
Department of Family and Community Services Doug Gordon Graphing with SAS - simplicity and beauty
SAS James Redman ETL Studio
IBM Global Services Australia Doug Lean IF I only knew WHERE
21 Aug 2003    
SAS Neil Doody Heart of Darkness
Softscape Solutions Jerry Le Breton Programming on the Dark Side - Obfuscation Codified
Department of Family and Community Services Doug Gordon The Ways and Means of Proc Summary
Reality Training Alan Davies & Mick Glasson Effective Use of Web Technology
22 May 2003    
SAS Jarmo Rasi The SAS Strategic Performance Management system
Softscape Solutions Jerry Le Breton Technical Tips
SAS Jim Watson Technical Tips (Exotic Data Types)
Reality Training Alan Davies & Mick Glasson How to stay ahead of the Pack - Useful tips, tricks and training aids
27 February 2003    
Department of Family and Community Services Doug Gordon Web Resources for SAS Programmers
Australian Bureau of Statistics Fred Wensing Preparing SAS code in a data step for later execution - two solutions
SAS Brian Watts Tips from Technical Support

2002

28 November 2002    
SAS Timothy Reed Introduction
Independent SAS Consultant Jerry Le Breton What's In It For Me? -- A V9 Overview
IBM Global Services Australia Doug Lean Do Your Data Steps Look Like This?
22 August 2002    
SAS Rodney Andriolo SUGA 2002 - The Power of Intelligence
Department of Education, Science & Training Christine Evans Everything You Never Wanted To Know About Postcodes But Should
(Not be Afraid to) Ask
* (*apologies to Woody Allen)
Australian Bureau of Agricultural and Resource Economics Sepideh Helali AgSurf - Farm Surveys Data On The Web
Qual IT Services Michael Matthews Macro Magic III
23 May 2002    
Department of Family & Community Services Doug Gordon Look it up in the dictionary
Centrelink Timothy Reed Reverse Engineering: Building a Software Component Map
Independent SAS Consultant Jerry Le Breton Merging Data Sets - Tricks & Traps
SAS Michael Dixon Technical Tips
28 February 2002    
Health Insurance Commission Arthur Witerall An Introduction to ODS Markup and Tagsets
Scorpio Software Services Alan Davies Distributed Data
SAS Dev Mookerjee SAS Design Time Controls

2001

15 November 2001    
Australian Federal Police John Blake The use of SAS for Resource Management at the AFP
SAS Neil Doody What a Long Strange Trip it's Been
SAS Doug Campbell Enterprise Marketing Automation (EMA)
16 August 2001    
Medibank Private Chris Raymond Formatting Web output using SAS: SAS styles vs Cascading Style Sheets vs XML + XSL - The pros and cons of each approach
Independent SAS Consultant Jerry Le Breton Data Step or SCL - or Both
SAS Emma Poulakas WebHound
SAS Paula Mathers SUGA 2001
24 May 2001    
Australian Bureau of Statistics Fred Wensing To code or not to code
Health Insurance Commission Mick Glasson Getting the most from V8 on MVS
SAS Stacey Costello Introducing the i-Layer
22 February 2001    
Australian Bureau of Agricultural Resource & Economics Ray Lindsay Using SAS to visualise vast amounts of complex electricity supply data
SAS Jacek Kucieba What's New in V8.2 and DataFlux
SAS Jamie Watson Fun with SAS: 5 Things you probably didn't know you could do in SAS

2000

All 2000    
Australian Institute of Health & Welfare Gerard Fitzsimmons Advocating the use of SAS-GRAPH in Report Production based on past experiences
Rationale Jerry Le Breton New Tricks for Untangling Strings in Version 8
SAS Jamie Watson Efficient Access to Large SAS Tables
SAS Emma Poulakas AppDev Studio
SAS Stuart Gregory Technical Update
SAS Tim Charlesworth Integration Technologies
SAS Ronnie Chan Adding e-Intelligence into web based processes
 

Back to SAUSAG