David,
We have nearly all sql scripts now embedded in SPSS syntax, many of them
are lengthy joins and we have both oracle and MS sql tables we are
using. It can be diffucult to use the SPSS gui or wizard to construct
sql statements, especially when they involve complex joins. Instead we
use syntax having the old (but still supported) GET CAPTURE command,
which I learned from several members on this list. You can still use
the gui/wizard to get your CONNECT string but then the rest is easy.
Below is basic syntax structure minus your sql statements, hope this
helps.
GET Capture ODBC
/CONNECT='DSN=PROD;UID=Y254K946;PWD=(t&I,\/k$L/f,.!&;SRVR=PROD'
/SELECT (place your sql here)
.
CACHE.
EXECUTE.
David Wright
On Thu, Apr 22, 2010 at 8:45 AM, David wrote:
> Hi all,
>
> I am brand new to SPSS and find it very difficult to perform more than
> 2
> table joins from an Oracle DB. Does anyone know if there is
> literature out
> there that would show me what SPSS is capable of in terms of the GUI
> area or
> the syntax portion. When I tried to put SQL into the syntax, it
> couldn't
> handle a nested query. I guess I am expecting something similar to
> what I
> do in oracle - is that possible with SPSS?
>
> Any thoughts would be greatly appreciated.
>
> David.
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
