Hi,
I assume you're using SAVE TRANSLATE to save it to the
access database? Please make sure you make a *BACKUP*
before you try the code fragment below. Perhaps
CASE-WHEN-THEN is also possible, not sure.
SAVE TRANSLATE
/ CONNECT = {connect string}
....
....
/sql = 'UPDATE newenroll
SET var1=some_value, var2=some_value, {etc}
WHERE term = 2081'
perhaps you could create a copy by first using
/ sql = 'select * from newenroll into newenrollcopy'
Cheers!!
Albert-Jan
--- "Lombardo, Barbara" <
[hidden email]>
wrote:
> You would need to do an UPDATE rather than an
> APPEND.
>
> Barbara Lombardo
>
> -----Original Message-----
> From: SPSSX(r) Discussion
> [mailto:
[hidden email]] On Behalf Of Keval
> Khichadia
> Sent: Wednesday, May 14, 2008 12:04 PM
> To:
[hidden email]
> Subject: appenidng table in access
>
> Hi,
> I am trying to append a table in acess. I need to
> replace data which has term = 2081.
> /table = newenroll
> /append.
> Would this syntax just add data to the exisiitng
> table
> I am afraid if I put / replace the entire table will
> be replaced. I only need to replace data with term =
> 2081.
> Thanks.
>
>
>
>
> =======
> To manage your subscription to SPSSX-L, send a
> message to
>
[hidden email] (not to SPSSX-L), with no
> body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send
> the command
> INFO REFCARD
>
> =====================
> To manage your subscription to SPSSX-L, send a
> message to
>
[hidden email] (not to SPSSX-L), with no
> body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send
> the command
> INFO REFCARD
>
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
