SPSSX Discussion

Issues with SAVE TRANSLATE /Type=XLS (using v15.0.1)

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

Issues with SAVE TRANSLATE /Type=XLS (using v15.0.1)

Dennis Deck
I am trying to create XLS spreadsheets with values included from various sources - example follows:

SAVE TRANSLATE Outfile=  's:\Healthy Schools\Schools info\OnlineSchools.xls'
  /Type= XLS   /Fieldnames  /Cells= Labels
  /Keep= SchlCode  SchlName DistName City State      
         LEVEL LoGr HiGr Enroll AmInd Asian Hispanic Black White
         InvDate Policy Meals Foods HlthEd PhysAct Staff PhysEd AftrSchl Total
         FirstName LastName Email                    
         MStreet MState MCity MZip MZip4 Phone
  /Replace  /Map .

While this core SAVE TRANSLATE works, I am having trouble making refinements:

 1) I specified /Cells=Labels to convert numeric variables to their labels but this command is ignored
    (as a workaround I could create text versions of the numeric variables but would it would be more efficient if /Cells worked).

 2) I tried saving to later formats of XLS to see if this would help in getting /Cells=Labels to work
     but specifying /Version causes SAVE TRANSLATE to fail altogether (I tried each of the 3 Versions for XLS files).

I am currently using SPSS v15.0.1

Any ideas?

Dennis Deck, PhD
RMC Research Corporation
111 SW Columbia Street, Suite 1200
Portland, Oregon 97201-5843
voice: 503-223-8248 x715
voice: 800-788-1887 x715
fax:  503-223-8248
[hidden email]

====================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
Oliver, Richard
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Issues with SAVE TRANSLATE /Type=XLS (using v15.0.1)

Oliver, Richard
Using 15.0.1, the following simple example seems to work correctly:

data list free /var1 (f ) var2 (f) var3 (a).
begin data
1 2 a
2 1 b
end data.
value labels var1 var2 1 "One" 2 "Two"
  /var3 "a" "AAA" "b" "BBB".
save translate outfile="c:\temp\temp.xls"
  /type=xls /version=8 /fieldnames /cells=labels
  /replace /map.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Dennis Deck
Sent: Tuesday, May 06, 2008 12:48 PM
To: [hidden email]
Subject: Issues with SAVE TRANSLATE /Type=XLS (using v15.0.1)

I am trying to create XLS spreadsheets with values included from various sources - example follows:

SAVE TRANSLATE Outfile=  's:\Healthy Schools\Schools info\OnlineSchools.xls'
  /Type= XLS   /Fieldnames  /Cells= Labels
  /Keep= SchlCode  SchlName DistName City State
         LEVEL LoGr HiGr Enroll AmInd Asian Hispanic Black White
         InvDate Policy Meals Foods HlthEd PhysAct Staff PhysEd AftrSchl Total
         FirstName LastName Email
         MStreet MState MCity MZip MZip4 Phone
  /Replace  /Map .

While this core SAVE TRANSLATE works, I am having trouble making refinements:

 1) I specified /Cells=Labels to convert numeric variables to their labels but this command is ignored
    (as a workaround I could create text versions of the numeric variables but would it would be more efficient if /Cells worked).

 2) I tried saving to later formats of XLS to see if this would help in getting /Cells=Labels to work
     but specifying /Version causes SAVE TRANSLATE to fail altogether (I tried each of the 3 Versions for XLS files).

I am currently using SPSS v15.0.1

Any ideas?

Dennis Deck, PhD
RMC Research Corporation
111 SW Columbia Street, Suite 1200
Portland, Oregon 97201-5843
voice: 503-223-8248 x715
voice: 800-788-1887 x715
fax:  503-223-8248
[hidden email]

=======
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
Dennis Deck
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Issues with SAVE TRANSLATE /Type=XLS (using v15.0.1)

Dennis Deck
Thanks
That verifies that /Version and /Cells should work as expected.
There must be something about the specifics of this job or data set that
causes both features to fail.

Dennis.

-----Original Message-----
From: Oliver, Richard [mailto:[hidden email]]
Sent: Tuesday, May 06, 2008 11:11 AM
To: Dennis Deck; [hidden email]
Subject: RE: Issues with SAVE TRANSLATE /Type=XLS (using v15.0.1)

Using 15.0.1, the following simple example seems to work correctly:

data list free /var1 (f ) var2 (f) var3 (a).
begin data
1 2 a
2 1 b
end data.
value labels var1 var2 1 "One" 2 "Two"
  /var3 "a" "AAA" "b" "BBB".
save translate outfile="c:\temp\temp.xls"
  /type=xls /version=8 /fieldnames /cells=labels
  /replace /map.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Dennis Deck
Sent: Tuesday, May 06, 2008 12:48 PM
To: [hidden email]
Subject: Issues with SAVE TRANSLATE /Type=XLS (using v15.0.1)

I am trying to create XLS spreadsheets with values included from various
sources - example follows:

SAVE TRANSLATE Outfile=  's:\Healthy Schools\Schools
info\OnlineSchools.xls'
  /Type= XLS   /Fieldnames  /Cells= Labels
  /Keep= SchlCode  SchlName DistName City State
         LEVEL LoGr HiGr Enroll AmInd Asian Hispanic Black White
         InvDate Policy Meals Foods HlthEd PhysAct Staff PhysEd AftrSchl
Total
         FirstName LastName Email
         MStreet MState MCity MZip MZip4 Phone
  /Replace  /Map .

While this core SAVE TRANSLATE works, I am having trouble making
refinements:

 1) I specified /Cells=Labels to convert numeric variables to their
labels but this command is ignored
    (as a workaround I could create text versions of the numeric
variables but would it would be more efficient if /Cells worked).

 2) I tried saving to later formats of XLS to see if this would help in
getting /Cells=Labels to work
     but specifying /Version causes SAVE TRANSLATE to fail altogether (I
tried each of the 3 Versions for XLS files).

I am currently using SPSS v15.0.1

Any ideas?

Dennis Deck, PhD
RMC Research Corporation
111 SW Columbia Street, Suite 1200
Portland, Oregon 97201-5843
voice: 503-223-8248 x715
voice: 800-788-1887 x715
fax:  503-223-8248
[hidden email]

=======
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
Dennis Deck
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Issues with SAVE TRANSLATE /Type=XLS (using v15.0.1)

Dennis Deck
With test files I can get it to work as it should.
Now I will have to see if I can recreate the setting in which it failed.


  Dennis

-----Original Message-----
From: Hal 9000 [mailto:[hidden email]]
Sent: Tuesday, May 06, 2008 11:48 AM
To: Dennis Deck
Subject: Re: Issues with SAVE TRANSLATE /Type=XLS (using v15.0.1)

Dennis, what error do you get when you specify version and the save
fails? I wonder if its a driver issue (?)...

-Gary

On Tue, May 6, 2008 at 11:36 AM, Dennis Deck <[hidden email]> wrote:

> Thanks
>  That verifies that /Version and /Cells should work as expected.
>  There must be something about the specifics of this job or data set
> that  causes both features to fail.
>
>  Dennis.
>
>
>
>  -----Original Message-----
>  From: Oliver, Richard [mailto:[hidden email]]
>  Sent: Tuesday, May 06, 2008 11:11 AM
>  To: Dennis Deck; [hidden email]
>  Subject: RE: Issues with SAVE TRANSLATE /Type=XLS (using v15.0.1)
>
>  Using 15.0.1, the following simple example seems to work correctly:
>
>  data list free /var1 (f ) var2 (f) var3 (a).
>  begin data
>  1 2 a
>  2 1 b
>  end data.
>  value labels var1 var2 1 "One" 2 "Two"
>   /var3 "a" "AAA" "b" "BBB".
>  save translate outfile="c:\temp\temp.xls"
>   /type=xls /version=8 /fieldnames /cells=labels
>   /replace /map.
>
>  -----Original Message-----
>  From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf

> Of  Dennis Deck
>  Sent: Tuesday, May 06, 2008 12:48 PM
>  To: [hidden email]
>  Subject: Issues with SAVE TRANSLATE /Type=XLS (using v15.0.1)
>
>  I am trying to create XLS spreadsheets with values included from
> various  sources - example follows:
>
>  SAVE TRANSLATE Outfile=  's:\Healthy Schools\Schools
> info\OnlineSchools.xls'
>   /Type= XLS   /Fieldnames  /Cells= Labels
>   /Keep= SchlCode  SchlName DistName City State
>          LEVEL LoGr HiGr Enroll AmInd Asian Hispanic Black White
>          InvDate Policy Meals Foods HlthEd PhysAct Staff PhysEd
> AftrSchl  Total
>          FirstName LastName Email
>          MStreet MState MCity MZip MZip4 Phone
>   /Replace  /Map .
>
>  While this core SAVE TRANSLATE works, I am having trouble making
>  refinements:
>
>   1) I specified /Cells=Labels to convert numeric variables to their
> labels but this command is ignored
>     (as a workaround I could create text versions of the numeric
> variables but would it would be more efficient if /Cells worked).
>
>   2) I tried saving to later formats of XLS to see if this would help
> in  getting /Cells=Labels to work
>      but specifying /Version causes SAVE TRANSLATE to fail altogether
> (I  tried each of the 3 Versions for XLS files).
>
>  I am currently using SPSS v15.0.1
>
>  Any ideas?
>
>  Dennis Deck, PhD
>  RMC Research Corporation
>  111 SW Columbia Street, Suite 1200
>  Portland, Oregon 97201-5843
>  voice: 503-223-8248 x715
>  voice: 800-788-1887 x715
>  fax:  503-223-8248
>  [hidden email]
>
>  =======
>  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
Free forum by Nabble Edit this page