Date:         Mon, 27 Oct 2003 12:11:24 -0500
Reply-To:     "F. J. Kelley" <jkelley@UGA.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "F. J. Kelley" <jkelley@UGA.EDU>
Subject:      Re: SAS and MySQL
Comments: To: Cargeoff <colin.carmichael@RESULTSEUROPE.COM>
Content-Type: text/plain; charset=us-ascii

ODBC should be sufficient.  I assume you have downloaded
MyODBC and performed the ODBC admin stuff.  One thing, the
variable names in MySQL are case-insensitive, but the tables
are not.  Here is a sample that uses CONTENTS to list the
tables:

libname WIN_cnct odbc
       user=JohnDoe
       password='John*D11'
       datasrc=MySQL_DB1 ;

proc contents
    data=WIN_cnct._ALL_ nods ;
run;
title "Data From MySQL Database";
proc print   data=WIN_cnct.Contig ;
run;
proc print
    data=WIN_cnct.Sequences ;run;


---- Original message ----
>Date: Mon, 27 Oct 2003 08:54:24 -0800
>From: Cargeoff <colin.carmichael@RESULTSEUROPE.COM>
>Subject: SAS and MySQL
>To: SAS-L@LISTSERV.UGA.EDU
>
>I am trying to import a SAS file into MySQL but having
difficulties.
>Has anybody attempted to do this before? I would rather not
have to
>rely on creating Text files before I import them.
>
>I only have the local SAS ODBC license with Base SAS to do
this.
>
>I have tried using MySQL FrontEnd software and importing it
this way
>but it fails to recognise the tables. A message saying "ODBC
does not
>support the requested properties".
>
>Cheers
>
>Colin