LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (August 1998, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 --------------------------------------


Back to: Top of message | Previous page | Main SAS-L page