Date:         Fri, 7 Aug 1998 14:38:56 -0500
Reply-To:     "Boylan, Dave" <dboylan@UTILICORP.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Boylan, Dave" <dboylan@UTILICORP.COM>
Subject:      Proc Access
Content-Type: text/plain

I'm having trouble figuring out some SAS code I've acquired.  The PROC
ACCESS does seem to work, but I don't fully understand what is happening.
I've looked through the documentation, but I still can't figure out what the
following lines do:
 
        create Work.Map.access;
        list all;
        create Work.Map.view;
        select all;
 
Will someone briefly explain?
 
Thanks in advance!
 
 
========================
Code Snippet:
========================
PROC ACCESS dbms=xls;
    create Work.Map.access;
    path="K:\UMS\FORECAST\DATA\BILLSTAT\WESTPLNS\RateRevMap.xls";
    worksheet='Value';
    range='CORate';
    getnames=No;
    type 'var0'=c 'var1'=c;
    assign=yes;
    list all;
    create Work.Map.view;
    select all;
Data CRatMap;
    *format Var0 z2.;
    set Work.Map;
    var0=upcase(var0);
    var1=upcase(var1);
    Rename Var0=RateCd Var1=OldRate;
    State='CO';
Run;
========================
--------------------------------------
David Boylan
Corporate Forecasting
UtiliCorp United, Inc.
816.467.3062
--------------------------------------