LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2007, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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/


Back to: Top of message | Previous page | Main SAS-L page