Date: Fri, 8 Aug 2008 11:58:28 -0400
Reply-To: Richard Ristow <firstname.lastname@example.org>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Richard Ristow <email@example.com>
Subject: Re: Extracting data using SPSS
In-Reply-To: <CDACAA61C633BB48AD6453DD9FC2F1E3012D71F5@OANHSS-EX.oanhss. org>
Content-Type: text/plain; charset="us-ascii"; format=flowed
At 09:22 AM 8/8/2008, Genevieve Thompson wrote:
>I am trying to extract data from an ODBC Database using SPSS. I
>started by opening a new database, selecting the ODBC Data source
>and selecting the needed variables. When I try to retrieve the data
>I'm looking for, the Data view tab only shows the list of variables
>I selected. The data fields are not populated.
Could it be as simple as that the command has been executed, but has
not yet carried out the data retrieval?
SPSS's is 'lazy' in data retrieval (and running transformations).
That is, it doesn't carry out the operation until the results are
'needed', which means a procedure command or a SAVE. It can do a lot
for efficiency, but it can be confusing if you're running interactively.
Try selecting menu
Transforms > Run Pending Transforms
1. 'Run Pending Transformations' runs an EXECUTE; EXECUTE is a
procedure. This is probably what gave the widespread (inaccurate)
impression that you must run EXECUTE for the results of
transformations to be available. (You must run a procedure for the
results to be *visible*, but that's different.)
2. It's often wise to run CACHE after an ODBC retrieval, or other
retrieval that may take a lot of resources.
-Good luck to you,
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
For a list of commands to manage subscriptions, send the command