Date:         Tue, 27 Feb 2007 16:01:07 +0000
Reply-To:     Cardiff Tyke <cardifftyke@yahoo.co.uk>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Cardiff Tyke <cardifftyke@yahoo.co.uk>
Subject:      Using multiple datasets/SQL
Content-Type: text/plain; charset=iso-8859-1

Hi,

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,
JC


	
	
		
___________________________________________________________ 
New Yahoo! Mail is the ultimate force in competitive emailing. Find out more at the Yahoo! Mail Championships. Plus: play games and win prizes. 
http://uk.rd.yahoo.com/evt=44106/*http://mail.yahoo.net/uk