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