[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Re: Data Manipulation

From: John Darrington
Subject: Re: Re: Data Manipulation
Date: Thu, 28 Jun 2012 19:01:47 +0000
User-agent: Mutt/1.5.18 (2008-05-17)

On Thu, Jun 28, 2012 at 07:50:09PM +0400, Michele Mor wrote:
     Hi John,

     I did not explained myself properly.
     I am referring to the SPSS equivalent of the JOIN command that it is used 
for SQL.
     At my company we use SPSS to join different data sources using a common 
key field.
     You can join 2 data files using one of them as a lookup table, or join 
records from both data files.
     Hope that this clarifies what I have meant.

I see. 

The "Join" command is not an SPSS command per se.  It is an SQL statement which 
SPSS passes to the connected
database engine, which is then processed by the database's SQL interpreter.  
PSPP does the same. However,
at the moment it can only connect to databases via PSQL.  ODBC is not yet 
supported.  See the section in the
      > Adding cases can be done, for example, using the ADD FILES command, or 
     Not aware of this.
     Any chance that you'll add a nice GUI menu for it? :-)
It's on the list of things to be done.
Feel free to add a comment there.  It might help raise its priority somewhat.


PGP Public key ID: 1024D/2DE827B3 
fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
See or any PGP keyserver for public key.

Attachment: signature.asc
Description: Digital signature

reply via email to

[Prev in Thread] Current Thread [Next in Thread]