Delete variable

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

Delete variable

Eric Janssen
Dear list

How may I delete variables in a base using a syntax when using and old SPSS
version? For instance, syntaxes like:

delete variable VAR1 .
del var VAR to VARx .

are not working on SPSS 11 and previous version.
Any idea appreciated.
Eric
Reply | Threaded
Open this post in threaded view
|

Re: Delete variable

Marta Garcia-Granero
Hi Eric:

Use:

MATCH FILES FILE=*
 /DROP="variable to delete".
> How may I delete variables in a base using a syntax when using and old SPSS
> version? For instance, syntaxes like:
>
> delete variable VAR1 .
> del var VAR to VARx .
>
> are not working on SPSS 11 and previous version.
Regards,
Marta Garcia-Granero
Reply | Threaded
Open this post in threaded view
|

Re: Delete variable

Florio Arguillas
In reply to this post by Eric Janssen
Eric,

Look into the SAVE OUTFILE command.  Something like this works:

SAVE OUTFILE 'c:\eric\myfile.sav' /DROP = VAR1 TO VAR10  VARX VARY VARZ .

In the above example, the command saves the file to
c:\eric\myfile.sav and that file will only contain those variables
that you did not specify in the drop subcommand.

Best regards,

Florio


At 05:40 AM 9/5/2007, Eric Janssen wrote:

>Dear list
>
>How may I delete variables in a base using a syntax when using and old SPSS
>version? For instance, syntaxes like:
>
>delete variable VAR1 .
>del var VAR to VARx .
>
>are not working on SPSS 11 and previous version.
>Any idea appreciated.
>Eric
Reply | Threaded
Open this post in threaded view
|

Re: Delete variable

Oliver, Richard
If you don't want to save the file, yuo can drop variables with ADD FILES:

add files file=* /drop var1 to var10.

I think DELETE VARIABLES was added in release 12.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Florio Arguillas
Sent: Wednesday, September 05, 2007 8:02 AM
To: [hidden email]
Subject: Re: Delete variable

Eric,

Look into the SAVE OUTFILE command.  Something like this works:

SAVE OUTFILE 'c:\eric\myfile.sav' /DROP = VAR1 TO VAR10  VARX VARY VARZ .

In the above example, the command saves the file to
c:\eric\myfile.sav and that file will only contain those variables
that you did not specify in the drop subcommand.

Best regards,

Florio


At 05:40 AM 9/5/2007, Eric Janssen wrote:

>Dear list
>
>How may I delete variables in a base using a syntax when using and old SPSS
>version? For instance, syntaxes like:
>
>delete variable VAR1 .
>del var VAR to VARx .
>
>are not working on SPSS 11 and previous version.
>Any idea appreciated.
>Eric