Date: Tue, 27 Feb 2007 16:01:07 +0000
Reply-To: Cardiff Tyke <firstname.lastname@example.org>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Cardiff Tyke <email@example.com>
Subject: Using multiple datasets/SQL
Content-Type: text/plain; charset=iso-8859-1
I'm currently manipulating an SPSS dataset and now I need to multiply a variable in my current dataset by a value in another dataset (or in a SQL database). Can anyone enlighten me on how to do this?
I am multiplying 84 variables - M1 * 1, M2 * 2 ... M84 * 84
I can extract the variables from the SQL database into a second dataset (called Untitled2 [Allocation] ) using syntax. It would be advantageous if I could reference the variables directly from a SQL table known as tblDrgData but I'm not sure if this is possible or not.
Thanks in advance,
New Yahoo! Mail is the ultimate force in competitive emailing. Find out more at the Yahoo! Mail Championships. Plus: play games and win prizes.