Hi All,

I was about to get a desktop analytics pro licence when I noticed I
might need to get the SAS/ACCESS=AE Interface to ODBC too. My budget
doesn't allow for this and I'm a little frustrated that a separate
addon is need just to connect to an ODBC source. grrrrrrrrrr

Is this totally necessary? I wouldn't be need to do much more than
link to single tables to pull into SAS for analysis. The cost of this
seem total overkill.

Does anyone know if the base option has sufficient ability to link to
an odbc source (sql server).

Many thanks.
Dave

You can generate a text file from SQL then import that into SAS if this 
table is not updated too often but otherwise there's no way around it.  I 
often had to write my own codes to import Excel into SAS because my client 
did not have SAS/ACCESS but I don't there's anything you can do to get 
around ODBC.

Welcome to SAS.

"dave"  wrote in message 
news:54da3ea9-4c88-4dd7-8755-3d9a8d7ed785@w29g2000vba.googlegroups.com...

Hi All,

I was about to get a desktop analytics pro licence when I noticed I
might need to get the SAS/ACCESS� Interface to ODBC too. My budget
doesn't allow for this and I'm a little frustrated that a separate
addon is need just to connect to an ODBC source. grrrrrrrrrr

Is this totally necessary? I wouldn't be need to do much more than
link to single tables to pull into SAS for analysis. The cost of this
seem total overkill.

Does anyone know if the base option has sufficient ability to link to
an odbc source (sql server).

Many thanks.
Dave 

On Jan 18, 6:27=A0pm, "Kenneth M. Lin" <kenneth_m_...@sbcglobal.net>
wrote:
> You can generate a text file from SQL then import that into SAS if this
> table is not updated too often but otherwise there's no way around it. =
=A0I
> often had to write my own codes to import Excel into SAS because my clien=
t
> did not have SAS/ACCESS but I don't there's anything you can do to get
> around ODBC.
>
> Welcome to SAS.
>
> "dave" =A0wrote in message
>
> news:54da3ea9-4c88-4dd7-8755-3d9a8d7ed785@w29g2000vba.googlegroups.com...
>

Ok, the confirmation is much appreciated if not quite what I was
hoping for.

Cheers