f



Re: Using SAS with large datasets (linking SAS and Access)

I have very little experience with using this but I have found that if you
have SAS Access for PC Products licensed,   just as you can issue a libname
statement pointing to an Excel workbook, you can also issue one for an
Access database. Try doing this and then look at your SAS explorer window
where you will see an icon for the Access file and will then be able to
look at the Access tables as if they were SAS data sets.

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



             ben.powell@CLA.CO
             .UK
             Sent by: "SAS(r)                                           To
             Discussion"               SAS-L@LISTSERV.UGA.EDU
             <SAS-L@LISTSERV.U                                          cc
             GA.EDU>
                                                                   Subject
                                       Re: Using SAS with large datasets
             06/23/2008 06:01
             AM


             Please respond to
             ben.powell@CLA.CO
                    .UK






If you haven't already, export the data out of Access asap as mdb
operations tend to be several orders of magnitude slower than SAS. Export
to tab or csv and import into SAS. The export procedure from Access is
relatively painless. If you've already done that and are still facing
problems you should provide more info on variable formats and code used as
what you're doing should by no means represent a problem for SAS.

Rgds


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.
0
6/23/2008 11:47:51 AM
comp.soft-sys.sas 142827 articles. 4 followers. Post Follow

0 Replies
887 Views

Similar Articles

[PageSpeed] 46

Reply: