indexing variables

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

indexing variables

C Kirkman
Working on a SQL server you can index variables. This speeds up processing
time. Instead of reading each case, the index points to just those cases
that need to be read, based on specified criteria.

Is there a comparable function in SPSS? As far as I can tell, with the
select function each case is still read to determine if it meets the
criteria.
Reply | Threaded
Open this post in threaded view
|

Re: indexing variables

Richard Ristow
At 11:07 AM 1/3/2007, C Kirkman wrote:

>Working on a SQL server you can index variables. This speeds up
>processing time. Instead of reading each case, the index points to
>just those cases that need to be read, based on specified criteria.
>
>Is there a comparable function in SPSS? As far as I can tell, with the
>select function each case is still read to determine if it meets the
>criteria.

I'm afraid the answer is, no, SPSS files can't have indices; and yes,
every case is read and matched against the selection criteria.

SAS does have dataset indices, so it wouldn't surprise me if indexing
turns up in some SPSS release. You might want to submit it as a
suggestion.

You can probably think of the work-arounds yourself, but they include
saving separate files with the subsets of the data you commonly use.