is there any tool to import data from sql database to spss file format (.sav) ?

[Imran]

I m having data in sql database. I want to import data from database to
spss file format (.sav)programmatically.

Is there any third party component exist, using which i can do this
job? if yes, then which?

i want to automate this process:
1. Select data from database using sql query
2. import selected data in to SPSS file format
3. use .sav file for further processing

Any help is appreciated.

Thanks in Advance

Regards,
Imran Panjewale

[Feyo]

You can do a simple select statement to your sql database to get the
data you need into spss. The syntax is like so:

GET DATA /TYPE=ODBC /CONNECT=
'DRIVER=SQL
Server;UID=username;PWD=password;Network=DBMSSOCN;DATABASE=databasename;APP=MIcrosoft
Open Database Connectivity;SERVER=ip address and socket of server'
/SQL = 'Select * from t_any_table'.

[Imran]

Thanks for your reply Feyo. But I am not having any spss statistical
software. so I can't use above statement!!!

I am only having SQL database. And I want to fetch data from my
database, and port it in to SPSS file format. I want to do it
programmatically (e.g. using ASP.NET). For this I am searching a third
pary tool which I can use to port data in to SPSS file format (.sav).

Is there any such tool available?

[JKPeck]

There is a dll that operates independently of the SPSS product that you
can use programmatically to create an SPSS sav file. Look for it on
the downloads or support section of www.spss.com (I don't recall
exactly where it lives).

There are also commerical tools like StatTransfer that can create these
files

Regards,
Jon Peck
SPSS

[anlay1...@gmail.com]

> > I m having data in sql database. I want to import data from database to
> > spss file format (.sav)programmatically.
> >
> > Is there any third party component exist, using which i can do this
> > job? if yes, then which?
> >
> > i want to automate this process:
> > 1. Select data from database using sql query
> > 2. import selected data in to SPSS file format
> > 3. use .sav file for further processing
> >
> > Any help is appreciated.

And Could you give me the example please.
Thank in advance.
ÁN LAY