Date: Mon, 14 Dec 2009 09:27:41 -0500
Reply-To: "Gerstle, John (CDC/CCID/NCHHSTP)" <yzg9@CDC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Gerstle, John (CDC/CCID/NCHHSTP)" <yzg9@CDC.GOV>
Subject: Re: New SAS tools for importing all of the sheets in a workbook
or tables in a MDB
In-Reply-To: <966B4B225F74914599E617416969BF1A459559CE4F@DOM-MBX02.mbu.ad.dominionnet.com>
Content-Type: text/plain; charset=us-ascii
The Excel libname engine is another route to go, if you have the time.
Once you assign the libname to an Excel file, in the SAS explorer, it
will list all the tabs like SAS datasets. Then you can use the
dictionary tables to pull this info out. Two things about the engine
that are note worthy - need to clear the libname after you use it so
that the excel file is closed and the syntax reading in the tabs are a
little different than the usual way.
John Gerstle
Scientific Information Specialist
Centers for Disease Control and Prevention
NCHHSTP\DHAP-SE\QSDMB\Data Management Team
Phone: 404-639-3980
Fax: 404-639-8642
Email: yzg9 at cdc dot gov
Socrates, proclaimed: "I came to know one thing; that I know nothing".
>>-----Original Message-----
>>From: owner-sas-l@listserv.uga.edu
[mailto:owner-sas-l@listserv.uga.edu] On
>>Behalf Of Nathaniel Wooding
>>Sent: Monday, December 14, 2009 9:15 AM
>>To: 'SAS-L@LISTSERV.UGA.EDU'
>>Subject: RE: New SAS tools for importing all of the sheets in a
workbook or tables
>>in a MDB
>>
>>John
>>
>>Good catch on the date. As I said, I have not tested these yet myself
but I do see
>>that at least one will give you a file with a list of the sheets. The
explorer window
>>will give you some of this information also, of course.
>>
>>My impression was that the tools would automate global imports which
we
>>otherwise have been having to do via macros.
>>
>>I'm not sure when I will have a chance to test them but if and when I
do, I'll report
>>back to the group.
>>
>>Nat
>>
>>-----Original Message-----
>>From: Gerstle, John (CDC/CCID/NCHHSTP) [mailto:yzg9@cdc.gov]
>>Sent: Monday, December 14, 2009 9:06 AM
>>To: Nathaniel Wooding (Services - 6); SAS-L@LISTSERV.UGA.EDU
>>Subject: RE: New SAS tools for importing all of the sheets in a
workbook or tables
>>in a MDB
>>
>>Nat,
>>Just did a quick look at the first SAS program - it's dated 2004.
Plus,
>>the info at the bottom of the page suggests these are for v9.1.3. Hmm.
>>Are these programs/tools really that new? Why not use the Excel
libname
>>engine instead? Just my two cents...
>>
>>John Gerstle
>>Scientific Information Specialist
>>Centers for Disease Control and Prevention
>>NCHHSTP\DHAP-SE\QSDMB\Data Management Team
>>Phone: 404-639-3980
>>Fax: 404-639-8642
>>Email: yzg9 at cdc dot gov
>>Socrates, proclaimed: "I came to know one thing; that I know nothing".
>>
>>>>-----Original Message-----
>>>>From: owner-sas-l@listserv.uga.edu
>>[mailto:owner-sas-l@listserv.uga.edu] On
>>>>Behalf Of Nathaniel Wooding
>>>>Sent: Monday, December 14, 2009 7:34 AM
>>>>To: SAS-L@LISTSERV.UGA.EDU
>>>>Subject: New SAS tools for importing all of the sheets in a workbook
>>or tables in a
>>>>MDB
>>>>
>>>>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.
>>
>>
>>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.
| 
