How to delete the variables which don't have the data

[Rajesh A]

Dear All,

For Example:

SAVE TRANSLATE OUTFILET="Path\Error.XLSX"
/KEEP=err1 TO err600
/TYPE=XLSX
/VERSION=12
/MAP
/REPLACE
/FIELDNAMES
/CELLS=VALUES.

In the above syntax, in err1 to err60 Variables - we don't have the data for all the variables. I need only applicable variables which we have data.

Is there any possibility to get the valid variables.

Thanks in Advance!

-AR

[Maguin, Eugene]

You can not do what you want within a save translate command. You have to read the dataset in and then operate on it.
So, read it in using save translate.

Identify variables with complete data.
Descriptives err1 to err60.

Why this? You know how many cases are in your dataset. By default and in very compact table, Descriptives lists the valid N for each variable.

You may want to use this also: Identify cases with complete data on all variables.
Count nmiss=err1 to err60(missing).
Frequencies nmiss.
Select if (nmiss eq 0).
Execute.

Gene Maguin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Rajesh A
Sent: Tuesday, February 23, 2016 5:40 AM
To: [hidden email]
Subject: How to delete the variables which don't have the data

Dear All,

For Example:

SAVE TRANSLATE OUTFILET="Path\Error.XLSX"
/KEEP=err1 TO err600
/TYPE=XLSX
/VERSION=12
/MAP
/REPLACE
/FIELDNAMES
/CELLS=VALUES.

In the above syntax, in err1 to err60 Variables - we don't have the data for all the variables. I need only applicable variables which we have data.

Is there any possibility to get the valid variables.

Thanks in Advance!

-AR



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/How-to-delete-the-variables-which-don-t-have-the-data-tp5731585.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

[Jon Peck]

This program, which requires the Python Essentials including the spssaux2.py module, will delete all the empty variables.

begin program.

import spssaux2

spssaux2.FindEmptyVars(delete=True)

end program.

On Tue, Feb 23, 2016 at 3:39 AM, Rajesh A <[hidden email]> wrote:

Dear All,

For Example:

SAVE TRANSLATE OUTFILET="Path\Error.XLSX"
/KEEP=err1 TO err600
/TYPE=XLSX
/VERSION=12
/MAP
/REPLACE
/FIELDNAMES
/CELLS=VALUES.

In the above syntax, in err1 to err60 Variables - we don't have the data for
all the variables. I need only applicable variables which we have data.

Is there any possibility to get the valid variables.

Thanks in Advance!

-AR



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/How-to-delete-the-variables-which-don-t-have-the-data-tp5731585.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

[Jignesh Sutar]

If you use python you can use the function FindEmptyVars. 

BEGIN PROGRAM .
import spssaux2
spssaux2.FindEmptyVars(delete=True)
END PROGRAM

On 23 February 2016 at 10:39, Rajesh A <[hidden email]> wrote:

Dear All,

For Example:

SAVE TRANSLATE OUTFILET="Path\Error.XLSX"
/KEEP=err1 TO err600
/TYPE=XLSX
/VERSION=12
/MAP
/REPLACE
/FIELDNAMES
/CELLS=VALUES.

In the above syntax, in err1 to err60 Variables - we don't have the data for
all the variables. I need only applicable variables which we have data.

Is there any possibility to get the valid variables.

Thanks in Advance!

-AR



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/How-to-delete-the-variables-which-don-t-have-the-data-tp5731585.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

[Bruce Weaver]

From the archives of this list:

http://spssx-discussion.1045642.n5.nabble.com/Deleting-Variables-with-Missings-Values-td5713534.html

Rajesh A wrote

Dear All,

For Example:

SAVE TRANSLATE OUTFILET="Path\Error.XLSX"
/KEEP=err1 TO err600
/TYPE=XLSX
/VERSION=12
/MAP
/REPLACE
/FIELDNAMES
/CELLS=VALUES.

In the above syntax, in err1 to err60 Variables - we don't have the data for all the variables. I need only applicable variables which we have data.

Is there any possibility to get the valid variables.

Thanks in Advance!

-AR

[Rajesh A]

Thanks for the Replies