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
Comments: To: sas-l@uga.edu

"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;
run;

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;
    run;

    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
http://www.devenezia.com/