Date:         Mon, 14 Dec 2009 13:12:58 +0000
Reply-To:     goladin@gmail.com
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Murphy Choy <goladin@GMAIL.COM>
Subject:      Re: New SAS tools for importing all of the sheets in a workbook
              or             tables in a MDB
Comments: To: Nathaniel Wooding <nathaniel.wooding@DOM.COM>
Content-Type: text/plain

Hi Nat,

Many thanks for sharing this.

------Original Message------
From: Nathaniel Wooding
Sender: SAS(r) Discussion
To: SAS-L@LISTSERV.UGA.EDU
ReplyTo: Nathaniel Wooding
Subject: New SAS tools for importing all of the sheets in a workbook or             tables in a MDB
Sent: Dec 14, 2009 8:34 PM

The SAS Tech Report sent out a week or so ago has a link to a usage note that lists new SAS tools that speed up the process of importing Excel workbooks or Access data bases. The title of the note is

Usage Note 13348: Using SAS(r) autoimporterv9 programs to automatically import all worksheets in a Microsoft Excel workbook
And the url is

http://support.sas.com/kb/13/348.html

So far, I have not tried these tools which have to be downloaded from the SAS Institute site.


Nat Wooding
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977
Cel Phone: 804-205-0752



CONFIDENTIALITY NOTICE:  This electronic message contains
information which may be legally confidential and or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect.  The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized.  If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful.  If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it.  Thank you.


Sent from my BlackBerry Wireless Handheld

--
Regards,
Murphy Choy

Certified Advanced Programmer for SAS V9
Certified Basic Programmer for SAS V9