Date: Tue, 24 Apr 2007 22:37:45 -0400
Reply-To: "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
Organization: Internet News Service
Subject: Re: filemaker pro
"Dennis G. Fisher, Ph.D." wrote:
> We have data in a filemaker pro 6.0 database. Does anyone have an
> example of how to read this into SAS? TIA
> Dennis Fisher
If you have SAS/Access to ODBC, use the Filemaker Pro ODBC driver to read
the tables of interest.
With Control Panel/Admin/Data Sources make a Data Source connected to your
FMP database -- suppose you name it "DGF FMP"
In SAS you only need a simple libref
LIBNAME MyFMP ODBC DATASRC='DGF FMP';
Proc Print MyFMP.TableXYZ;
If you are doing lots of exploratory or repetitive analytics, you will
probably get better performance by using Proc COPY to replicate the data in
native sas tables.
libname STUDY "<some path>";
Proc COPY inlib=MyFMP outlib=STUDY;
proc summary data=study.whatever;....
Later you can use STUDY as the libref to the FMP data, and the code will run
exactly the same.
If you don't have SAS/Access, the easiest way might be to do a CSV export
from FMP and in SAS do a File/Import Data to read it in.
Richard A. DeVenezia