Date:         Wed, 13 Aug 1997 18:00:08 -0400
Reply-To:     Jamie Christopher Michael Beu <jcb20544@PEGASUS.CC.UCF.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Jamie Christopher Michael Beu <jcb20544@PEGASUS.CC.UCF.EDU>
Organization: University of Central Florida
Subject:      Q: Calculations w/o copying datasets
Content-Type: TEXT/PLAIN; charset=US-ASCII

I'm quite new to SAS, and have the daunting task of moving all of our data
from MS Access format to SAS format. My problem is that I don't quite know
how to do calculations for a gchart w/o using the set command on a new
dataset. I'll explain a little further.
 
I have a dataset already imported, and I want to do graphs of various
mathematical manipulations (ratios and deltas between fields to start).
How do I do something like that without doing the following:
 
        data SASUSER.TABLE2;
           set SASUSER.TABLE1;
           RATIO = VAR1 / VAR2;
 
        proc gchart data=SASUSER.TABLE2;
           vbar RATIO /
              freq
              maxis=axis1
              raxis=axis2
              width=6
              type=FREQ;
             where
              PARAM = 1
           ;
        run; quit;
 
Originally, I had hoped to simply put in the line:
 
          vbar (VAR1 / VAR2) /
 
and use only my first table (TABLE1). I realize that I could do all the
calculations when the data is first imported, but there will be a great
number of reports available for the end-user, and I would rather be able
to calculate the values for each of those reports individually /
on-the-fly, instead of taking up a great deal of time (and resources)
doing potentially unnecessary calculations up-front.
 
Thank you for your time and patience with me. The demo of SAS looked good,
and I would like to learn how to use it effectively and efficiently, but
the learning curve seems awfully steep here at the beginning.
 
Jamie Beu (jcb20544@pegasus.cc.ucf.edu) Univ. of Central Florida, Orlando, FL
        "He (Christ) is risen! Alleluia!" (numerous places in the Bible)
                "I'm back on my e-mail again. Praise be to God!"