MURAL - Maynooth University Research Archive Library



    Processing Large Environmental Datasets With SAS – Writing Robust and Dynamic Macro Code


    Mooney, Peter, 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.

    [thumbnail of AW-Processing-2006.pdf]
    Preview
    Text
    AW-Processing-2006.pdf

    Download (217kB) | Preview

    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)
    Related URLs:
    URI: https://mural.maynoothuniversity.ie/id/eprint/8102
    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
    Item control page

    Downloads

    Downloads per month over past year

    Origin of downloads