Mooney, Peter and Winstanley, Adam C. and McDonagh, Conor
(2006)
Processing Large Environmental Datasets With SAS – Writing Robust and Dynamic Macro Code.
In: SUGI 31 Thirty-first Annual SAS ® Users Group International Conference, March 26-29, 2006, San Francisco, California.
Abstract
We discuss the application of SAS to a number of environmental datasets. Usually reports, graphical visualizations,
summary statistics, and subset or aggregate datasets must be generated from one or more of these datasets. A
library of SAS macros was developed while building a reporting system for several large and complex environmental
datasets. This paper discusses a number of SAS code segments from these macros that may be easily extended to
other similar projects. The intended audience is the SAS macro programmer and concentrates on several key areas:
· Using the DATASTEP to generate CSV and XML file output corresponding to data used by GPLOT and
GCHART;
· Augmenting basic GOPTIONS and CHART options to produce graphical output (JPEG) for several different
variables in time-series datasets;
· Using local macro variables to generate dynamic AXIS statements (for graphics) and WHERE statements
(for DATASTEP).
The SAS code is contained within macro definitions and offers maximum opportunity for code reuse
| Item Type: |
Conference or Workshop Item
(Paper)
|
| Keywords: |
Large Environmental Datasets; SAS; Macro Code; SAS macros; |
| Academic Unit: |
Faculty of Science and Engineering > Computer Science |
| Item ID: |
8102 |
| Depositing User: |
Dr. Adam Winstanley
|
| Date Deposited: |
30 Mar 2017 14:33 |
| Refereed: |
Yes |
| Funders: |
Environmental Protection Agency (EPA) |
| URI: |
|
| Use Licence: |
This item is available under a Creative Commons Attribution Non Commercial Share Alike Licence (CC BY-NC-SA). Details of this licence are available
here |
Repository Staff Only(login required)
 |
Item control page |
Downloads per month over past year
Origin of downloads
Altmetric
Altmetric