Date:         Thu, 6 Jul 2006 18:54:19 -0400
Reply-To:     Wensui Liu <liuwensui@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Wensui Liu <liuwensui@GMAIL.COM>
Subject:      Re: Can I create a MYSQL database from SAS data
Comments: To: David Fickbohm <davefickbohm@yahoo.com>
In-Reply-To:  <20060706224727.71592.qmail@web82504.mail.mud.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

I think it is possible give the information you provided. MySQL db can be
accessed directly  in SAS9.1.

something like following:
libname mylib *mysql* user=root password=*** server=localhost database=***;

On 7/6/06, David Fickbohm <davefickbohm@yahoo.com> wrote:
>
> People,
> I have been asked to create a MYSQL database from SAS data.  Is this
> possible ?    I have base SAS, PC files SAS, and ODBC SAS.   I am running
> sas9.1.3 in a windows XP environment.
> Thanks
> Dave
>
> Dave Fickbohm
>
> Use Technology to the Fullest
> 1250 45th st suite 200
> Emeryville, CA, 94608
> 510 594 4151 voice
>



--
WenSui Liu
(http://spaces.msn.com/statcompute/blog)
Senior Decision Support Analyst
Health Policy and Clinical Effectiveness
Cincinnati Children Hospital Medical Center