many tables in SPSS output to xls worksheet

[Juris Breidaks]

Hello,

I have many tables in SPSS output. How can I save all this tables in one book, but in different worksheets!

Juris

[Peck, Jon]

You can find a Basic script for this on Developer Central (www.spss.com/devcentral) in the Downloads section. It prompts you in a dialog for the specification and creates either separate Excel files for each table or makes them separate sheets in one file.

 

Look for Excel Export.  It is helpful to click "Single-Page View" at the top of the list.

 

HTH,

Jon Peck

 

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Juris Breidaks
Sent: Thursday, February 05, 2009 6:38 AM
To: [hidden email]
Subject: [SPSSX-L] many tables in SPSS output to xls worksheet

 

Hello,

I have many tables in SPSS output. How can I save all this tables in one book, but in different worksheets!

Juris

[Melissa Ives]

This is something I can really use, however, when I try to run it (v17) I get the following error.

(16210) The interpreter for the script is not set. Cannot run the script.

Help topics doesn't have information on what The interpreter is or how to set it.

Melissa Ives

[hidden email]
voice: 309-451-7819

 

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Peck, Jon
Sent: Thursday, February 05, 2009 12:14 PM
To: [hidden email]
Subject: Re: [SPSSX-L] many tables in SPSS output to xls worksheet

You can find a Basic script for this on Developer Central (www.spss.com/devcentral) in the Downloads section. It prompts you in a dialog for the specification and creates either separate Excel files for each table or makes them separate sheets in one file.

 

Look for Excel Export.  It is helpful to click "Single-Page View" at the top of the list.

 

HTH,

Jon Peck

 

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Juris Breidaks
Sent: Thursday, February 05, 2009 6:38 AM
To: [hidden email]
Subject: [SPSSX-L] many tables in SPSS output to xls worksheet

 

Hello,

I have many tables in SPSS output. How can I save all this tables in one book, but in different worksheets!

Juris

---

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at [phone] for assistance.

[parisec]

Hi all,

 

Is there a more efficient set of syntax to use that will do the same thing as the following?

 

compute Nevar=$sysmis.

    if (oldvar1=0 OR oldvar2=0....OR oldvar25=0) newvar=0.

    if (oldvar1=1 OR oldvar2=1....OR oldvar25=1) newvar=1.

 

I have to start with a $sysmis because some of the oldvars are actually missing.

 

Thanks.

Carol

[Arthur Burke]

Carol ... Is this what you wanted?

 

DO IF MIN(oldvar1 TO oldvar25) = 0.

   COMPUTE NEWVAR=0.

ELSE.

   COMPUTE NEWVAR=1.

END IF.

EXECUTE.

 

Art

---

From: Parise, Carol A. [mailto:[hidden email]]
Sent: Thursday, February 05, 2009 2:52 PM
To: [hidden email]
Subject: more efficient syntax?

Hi all,   Is there a more efficient set of syntax to use that will do the same thing as the following?   compute Nevar=$sysmis.     if (oldvar1=0 OR oldvar2=0....OR oldvar25=0) newvar=0.     if (oldvar1=1 OR oldvar2=1....OR oldvar25=1) newvar=1.   I have to start with a $sysmis because some of the oldvars are actually missing.   Thanks. Carol

[ViAnn Beadle]

Use the ANY function as in if any(0,oldvar1 to oldvar25) newvar=0.

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Parise, Carol A.
Sent: Thursday, February 05, 2009 3:52 PM
To: [hidden email]
Subject: more efficient syntax?

 

Hi all,

 

Is there a more efficient set of syntax to use that will do the same thing as the following?

 

compute Nevar=$sysmis.

    if (oldvar1=0 OR oldvar2=0....OR oldvar25=0) newvar=0.

    if (oldvar1=1 OR oldvar2=1....OR oldvar25=1) newvar=1.

 

I have to start with a $sysmis because some of the oldvars are actually missing.

 

Thanks.

Carol

[parisec]

yes

 

 this and an off list response of:

COUNT    newvar = oldvar1 TO oldvar25 (1).         << provided consecutive in file

RECODE newvar (1 THRU HI=1)(ELSE=0).

 

both work for what i'm trying to do with much less code.

 

i appreciate the help.

 

carol

---

From: Arthur Burke [mailto:[hidden email]]
Sent: Thursday, February 05, 2009 3:26 PM
To: Parise, Carol A.; [hidden email]
Subject: RE: more efficient syntax?

Carol ... Is this what you wanted?

 

DO IF MIN(oldvar1 TO oldvar25) = 0.

   COMPUTE NEWVAR=0.

ELSE.

   COMPUTE NEWVAR=1.

END IF.

EXECUTE.

 

Art

---

From: Parise, Carol A. [mailto:[hidden email]]
Sent: Thursday, February 05, 2009 2:52 PM
To: [hidden email]
Subject: more efficient syntax?

Hi all,   Is there a more efficient set of syntax to use that will do the same thing as the following?   compute Nevar=$sysmis.     if (oldvar1=0 OR oldvar2=0....OR oldvar25=0) newvar=0.     if (oldvar1=1 OR oldvar2=1....OR oldvar25=1) newvar=1.   I have to start with a $sysmis because some of the oldvars are actually missing.   Thanks. Carol

[Art Kendall]

It is not a good idea to set  a variable to $sysmis.  The value of newvar is missing because you decided it would be missing under certain circumstances.  In this instance newvar defaults to -1 unless at least 1 of the variables has a 1 or a 2. 

compute newvar = -1.
missing values newvar(-1).
if any(oldvar1 to oldvar25,1) newvar=0.
if any(oldvar1 to oldvar25,2) newvar=1.
value labels newvar
  -1 'no variable has a zero or a one.'
   0 'at least 1 zero and no 2s'
   1 'at least one 1 and unknown # of 1s'.

count any_zero = any(oldvar1 to oldvar25,0).
count any_one  = any(oldvar1 to oldvar25,1).
crosstabs tables = any_zero by any_one.


Art Kendall
Social Research Consultants




Parise, Carol A. wrote:

Hi all,

 

Is there a more efficient set of syntax to use that will do the same thing as the following?

 

compute Nevar=$sysmis. <*****

    if (oldvar1=0 OR oldvar2=0....OR oldvar25=0) newvar=0.

    if (oldvar1=1 OR oldvar2=1....OR oldvar25=1) newvar=1.

 

I have to start with a $sysmis because some of the oldvars are actually missing.

 

Thanks.

Carol

[Peck, Jon]

Setting the interpreter is not something you do.  Please contact Technical Support to diagnose the cause.  There is something wrong with your scripting setup.

 

Note also that w V 17, the OUTPUT EXPORT command can be used to export tables or other objects and control the sheet and even the cell range for the export.

 

HTH,

Jon Peck

 

---

From: Melissa Ives [mailto:[hidden email]]
Sent: Thursday, February 05, 2009 3:09 PM
To: Peck, Jon; [hidden email]
Subject: RE: [SPSSX-L] many tables in SPSS output to xls worksheet

 

This is something I can really use, however, when I try to run it (v17) I get the following error.

(16210) The interpreter for the script is not set. Cannot run the script.

Help topics doesn't have information on what The interpreter is or how to set it.

Melissa Ives

[hidden email]
voice: 309-451-7819

 

 

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Peck, Jon
Sent: Thursday, February 05, 2009 12:14 PM
To: [hidden email]
Subject: Re: [SPSSX-L] many tables in SPSS output to xls worksheet

You can find a Basic script for this on Developer Central (www.spss.com/devcentral) in the Downloads section. It prompts you in a dialog for the specification and creates either separate Excel files for each table or makes them separate sheets in one file.

 

Look for Excel Export.  It is helpful to click "Single-Page View" at the top of the list.

 

HTH,

Jon Peck

 

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Juris Breidaks
Sent: Thursday, February 05, 2009 6:38 AM
To: [hidden email]
Subject: [SPSSX-L] many tables in SPSS output to xls worksheet

 

Hello,

I have many tables in SPSS output. How can I save all this tables in one book, but in different worksheets!

Juris

 

---

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at [phone] for assistance.

[news]

Carol,
You might do a count on all the ifs and if the count variable newvar has
at least one valid value newvar = 1. The tricky thing is to distinguish
between missing and a valid 0 for newvar = 0.

Regards
-ft

Parise, Carol A. wrote:

> Hi all,
>
> Is there a more efficient set of syntax to use that will do the same
> thing as the following?
>
> compute Nevar=$sysmis.
>     if (oldvar1=0 OR oldvar2=0....OR oldvar25=0) newvar=0.
>     if (oldvar1=1 OR oldvar2=1....OR oldvar25=1) newvar=1.
>
> I have to start with a $sysmis because some of the oldvars are
> actually missing.
>
> Thanks.
> Carol

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

[SPSS Support]

Melissa,

Please check your clientscriptingcfg.ini file, which should be in the installation directory. This file may have been corrupted. If all of the parameters are on a single line, that's the case. If you've used the default installation setup, the contents of this file should read as follows:

[SUPPORTED_LANG]
LANGUAGES=Basic,Python

[Basic]
EPI_LOGUE=
PRO_LOGUE=
STOP_EMBEDDED_X=Uninitialize_SaxBasic
EXECUTE_EX=
FILE_EXTS=wwd;sbs
EXECUTE_X=Execute_SaxBasic
INIT_EMBEDDED_X=Init_Embedded_SaxBasic
EDITOR_ARGS=
EDITOR_PATH=C:\Program Files\SPSSInc\Statistics17\SPSSWinWrapIDE.exe
INTERPRETER_ARGS=
INTERPRETER_PATH=C:\Program Files\SPSSInc\Statistics17\WWBProcessor.exe
LIB_NAME=InvokeSaxBasic

[Python]
EXECUTE_EX=Execute_Python_Ex
FILE_EXTS=py;pyc
EPI_LOGUE=
PRO_LOGUE=
STOP_EMBEDDED_X=
EXECUTE_X=Execute_Python
INIT_EMBEDDED_X=Init_Embedded_Python
EDITOR_ARGS=C:\Python25\Lib\idlelib\idle.pyw
EDITOR_PATH=C:\Python25\pythonw.exe
INTERPRETER_ARGS=-u
LIB_NAME=InvokePython
INTERPRETER_PATH=C:\Python25\python.exe

[VERSION]
INVOKEX_VERSION=17.0.0.0


You can copy and paste these commands over what's in there now if you've used the default installation setup. If not, you would need to make sure that the paths matched those for your installation of SPSS and Python.

David Nichols

________________________________

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Peck, Jon
Sent: Thursday, February 05, 2009 6:25 PM
To: [hidden email]
Subject: Re: [SPSSX-L] many tables in SPSS output to xls worksheet



Setting the interpreter is not something you do.  Please contact Technical Support to diagnose the cause.  There is something wrong with your scripting setup.



Note also that w V 17, the OUTPUT EXPORT command can be used to export tables or other objects and control the sheet and even the cell range for the export.



HTH,

Jon Peck



________________________________

From: Melissa Ives [mailto:[hidden email]]
Sent: Thursday, February 05, 2009 3:09 PM
To: Peck, Jon; [hidden email]
Subject: RE: [SPSSX-L] many tables in SPSS output to xls worksheet



This is something I can really use, however, when I try to run it (v17) I get the following error.

(16210) The interpreter for the script is not set. Cannot run the script.

Help topics doesn't have information on what The interpreter is or how to set it.

Melissa Ives

[hidden email]
voice: 309-451-7819





________________________________

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Peck, Jon
Sent: Thursday, February 05, 2009 12:14 PM
To: [hidden email]
Subject: Re: [SPSSX-L] many tables in SPSS output to xls worksheet

You can find a Basic script for this on Developer Central (www.spss.com/devcentral) in the Downloads section. It prompts you in a dialog for the specification and creates either separate Excel files for each table or makes them separate sheets in one file.



Look for Excel Export.  It is helpful to click "Single-Page View" at the top of the list.



HTH,

Jon Peck



________________________________

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Juris Breidaks
Sent: Thursday, February 05, 2009 6:38 AM
To: [hidden email]
Subject: [SPSSX-L] many tables in SPSS output to xls worksheet




Hello,

I have many tables in SPSS output. How can I save all this tables in one book, but in different worksheets!

Juris



________________________________

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at [phone] for assistance.

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

[Guerrero, Rodrigo]

I am running some analysis of call data and trying to predict conversion rates by agent.  I ran a CURVEFIT for Quadratic, Cubic, Growth and Exponential models and got good results.  I decided on the Cubic model for all my agents, but when I rerun the CURVEFIT for just the Cubic model, my coefficients and R-square are different (although not by much) than when I run it in conjunction with the other models.  Does anyone know how or why this happens?  I am not changing anything except what models I run within CURVEFIT.

 

Thanks in advance.

 

Rodrigo Guerrero

The information transmitted is intended only for the addressee(s) and may contain confidential or privileged material, or both. Any review, receipt, dissemination or other use of this information by non-addressees is prohibited. If you received this in error or are a non-addressee, please contact the sender and delete the transmitted information.