Date:         Thu, 11 Nov 1999 17:07:56 -0700
Reply-To:     Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject:      Re: Use perl with SAS and MS Access?
Comments: To: jkort@WIMBERLEY-TX.COM
Content-Type: text/plain; charset=us-ascii

If the SAS datasets are small, you could download the free SAS System Viewer, and cut&paste the data into an Access table.  I think the limit of observations you can copy at one time is in the thousands, but not unlimited.

Another possibility is the SAS Universal ODBC Driver, which lets you read SAS datasets through ODBC.  It's read-only, but it doesn't sound like that's a problem for your usage.

A third possibility is DBMS/Copy, which can convert SAS 6.12 for Windows datasets into various other formats.  It can also read transport files, and a few non-PC native formats.




--
JackHamilton@FirstHealth.com
Development Manager, Technical Group
METRICS Department, First Health
West Sacramento, California USA


>>> <jkort@WIMBERLEY-TX.COM> 11/11/1999 3:23 pm >>>
I need to compare SAS datasets to MS Access tables.  Can't afford SAS
license, so doing this in SAS is not an option, and I'd rather not use
VB.  Does perl, with ODBC connections, offer me a way to hit against
both data sources?  If yes, can you please point me to some good
documentation for this?

Many thanks!
Jack Ort


Sent via Deja.com http://www.deja.com/
Before you buy.