How to set condition for save tranlate

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

How to set condition for save tranlate

alps-2
SAVE TRANSLATE TYPE=ODBC /CONNECT=
 'DSN=final;UID=;APP=SPSS For Windows;WSID=TELEBIZ-
7F018C2;DATABASE=my_table;Trusted_Connection=Yes'
  /table="after"
 /unselect=retain
  /FIELDNAMES
  /append
  /map.


--> above is my syntax. my database is ms sql server. Can i set the
condition for the syntax like one of the column the predict need to >=0
then only can save into database?
Reply | Threaded
Open this post in threaded view
|

Re: How to set condition for save tranlate

Jason Burke
TEMPORARY .
SELECT IF value >= 0 .

SAVE TRANSLATE TYPE=ODBC
 /CONNECT= 'DSN=final;UID=;APP=SPSS For Windows;WSID=TELEBIZ-
7F018C2;DATABASE=my_table;Trusted_Connection=Yes'
  /TABLE = "after"
  /UNSELECT = retain
  /FIELDNAMES
  /APPEND
  /MAP .