MURAL - Maynooth University Research Archive Library



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


    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.

    [img]
    Preview
    Download (217kB) | Preview


    Share your research

    Twitter Facebook LinkedIn GooglePlus Email more...



    Add this article to your Mendeley library


    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:

    Repository Staff Only(login required)

    View Item Item control page

    Downloads

    Downloads per month over past year