SPSS 13.0

[Stella Vasquez]

In SPSS 12.0 there was an option to freeze variables, I believe it was called "pin" in SPSS, Is this option available in SPSS 13.0?
 
 
 
 
Stella Vasquez, Planner II
AZ Department of Juvenile Corrections
1624 West Adams
Phoenix, AZ 85007
[phone]


Did I do a good job, in helping you?  
Please take a few minutes and rate my performance.

Website:  
http://intranet.azdjc.gov/Surveys/CustomerServiceSurvey.asp

[Michael A. Herradora Q.]

Dear Stella:

This option is not avaible more. And it is one of the most important
lost option of SPSS.

Really, really sorry.

Michael.

Stella Vasquez wrote:

> In SPSS 12.0 there was an option to freeze variables, I believe it was called "pin" in SPSS, Is this option available in SPSS 13.0?
>
>
>
>
> Stella Vasquez, Planner II
> AZ Department of Juvenile Corrections
> 1624 West Adams
> Phoenix, AZ 85007
> [phone]
>
>
> Did I do a good job, in helping you?
> Please take a few minutes and rate my performance.
>
> Website:
> http://intranet.azdjc.gov/Surveys/CustomerServiceSurvey.asp
>
>
>

[Beadle, ViAnn]

I don't think that is true--I know that the UI for pinning changed at some point but can't remember when. Try searching Help.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Michael A. Herradora Q.
Sent: Wednesday, February 28, 2007 10:12 AM
To: [hidden email]
Subject: Re: SPSS 13.0

Dear Stella:

This option is not avaible more. And it is one of the most important
lost option of SPSS.

Really, really sorry.

Michael.

Stella Vasquez wrote:

> In SPSS 12.0 there was an option to freeze variables, I believe it was called "pin" in SPSS, Is this option available in SPSS 13.0?
>
>
>
>
> Stella Vasquez, Planner II
> AZ Department of Juvenile Corrections
> 1624 West Adams
> Phoenix, AZ 85007
> [phone]
>
>
> Did I do a good job, in helping you?
> Please take a few minutes and rate my performance.
>
> Website:
> http://intranet.azdjc.gov/Surveys/CustomerServiceSurvey.asp
>
>
>

[Beadle, ViAnn]

OK, I fired up SPSS and for 15, you can pin rows by dragging the horizontal handle just above the right scroll bar down. To pin columns, you drag the little vertical handle just to the right of the bottom scroll bar.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Michael A. Herradora Q.
Sent: Wednesday, February 28, 2007 10:12 AM
To: [hidden email]
Subject: Re: SPSS 13.0

Dear Stella:

This option is not avaible more. And it is one of the most important
lost option of SPSS.

Really, really sorry.

Michael.

Stella Vasquez wrote:

> In SPSS 12.0 there was an option to freeze variables, I believe it was called "pin" in SPSS, Is this option available in SPSS 13.0?
>
>
>
>
> Stella Vasquez, Planner II
> AZ Department of Juvenile Corrections
> 1624 West Adams
> Phoenix, AZ 85007
> [phone]
>
>
> Did I do a good job, in helping you?
> Please take a few minutes and rate my performance.
>
> Website:
> http://intranet.azdjc.gov/Surveys/CustomerServiceSurvey.asp
>
>
>

[Mariajose Romero]

Hi:

I use SPSS 15 in the office and SPSS 9 at home;  is there a way to open
in SPSS 9 output files generated in SPSS 15?

Your help is appreciated.  Thanks.

MJR


Mariajosé Romero, Ph.D.
Associate Research Scientist
National Center for Children in Poverty
Mailman School of Public Health
Columbia University
215 W 125th Street, 3rd Floor
New York, NY 10027
Direct:  646.284.9641
Fax: [phone]
[hidden email]
www.nccp.org
www.childcareresearch.org

[Michael A. Herradora Q.]

You could follow this way but it doesn't work like pinning.

Sometimes if you click in one variable (to see the variable view
information of this specific variable) after when you return to the data
view you could find that the pinning variables have changed to the
revised variable.

Michael.

Beadle, ViAnn wrote:

> OK, I fired up SPSS and for 15, you can pin rows by dragging the horizontal handle just above the right scroll bar down. To pin columns, you drag the little vertical handle just to the right of the bottom scroll bar.
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Michael A. Herradora Q.
> Sent: Wednesday, February 28, 2007 10:12 AM
> To: [hidden email]
> Subject: Re: SPSS 13.0
>
> Dear Stella:
>
> This option is not avaible more. And it is one of the most important
> lost option of SPSS.
>
> Really, really sorry.
>
> Michael.
>
> Stella Vasquez wrote:
>
>> In SPSS 12.0 there was an option to freeze variables, I believe it was called "pin" in SPSS, Is this option available in SPSS 13.0?
>>
>>
>>
>>
>> Stella Vasquez, Planner II
>> AZ Department of Juvenile Corrections
>> 1624 West Adams
>> Phoenix, AZ 85007
>> [phone]
>>
>>
>> Did I do a good job, in helping you?
>> Please take a few minutes and rate my performance.
>>
>> Website:
>> http://intranet.azdjc.gov/Surveys/CustomerServiceSurvey.asp
>>
>>
>>
>>
>
>
>

[zstatman]

Except for the viewer (spool) file all are usable (data & syntax), however,
some specific syntax might not be backward compatible

HTH

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Mariajose Romero
Sent: Wednesday, February 28, 2007 1:37 PM
To: [hidden email]
Subject: Re: SPSS 13.0

Hi:

I use SPSS 15 in the office and SPSS 9 at home;  is there a way to open in
SPSS 9 output files generated in SPSS 15?

Your help is appreciated.  Thanks.

MJR


Mariajosé Romero, Ph.D.
Associate Research Scientist
National Center for Children in Poverty
Mailman School of Public Health
Columbia University
215 W 125th Street, 3rd Floor
New York, NY 10027
Direct:  646.284.9641
Fax: [phone]
[hidden email]
www.nccp.org
www.childcareresearch.org

[Graham Wright-2]

Has anyone had trouble in the past with really weird data corruption
when opening an excel file in SPSS? There is an excel file I have
(generated originally from perseus survey solutions) that, if you just
try to open it in SPSS it looks fine but has some really weird
corruption in it: If the variable blah does not already exist and you go

if goreg=1& fulltime=1 blah=1.

one would suspect that the only possible value for the new variable blah
would be 1. However, instead when I do a frequency count of the new
variable I get a number of different answers, ranging from 0 to 12. This
happens with a number of different variables in the dataset, and its not
stable: if you run the command, then delete the new variable and run the
exact same syntax again you get a different collection of values, and
each time you delete the variable and run the syntax again you get fewer
and fewer values, eventually you only gets "1"'s, as you should.  This
only happens in SPSS 14, not SPSS11.

When you turn the excel file into SPSS via DBMS copy this doesn't
happen, but DBMS copy truncates variable names, which is annoying. Does
any of this sound familiar to anyone?

-Graham

[Jason Burke]

Pin was a good idea, but the split option is an even better one....
let's not go backwards!

Jason

On 3/1/07, Michael A. Herradora Q. <[hidden email]> wrote:

> You could follow this way but it doesn't work like pinning.
>
> Sometimes if you click in one variable (to see the variable view
> information of this specific variable) after when you return to the data
> view you could find that the pinning variables have changed to the
> revised variable.
>
> Michael.
>
> Beadle, ViAnn wrote:
> > OK, I fired up SPSS and for 15, you can pin rows by dragging the horizontal handle just above the right scroll bar down. To pin columns, you drag the little vertical handle just to the right of the bottom scroll bar.
> >
> > -----Original Message-----
> > From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Michael A. Herradora Q.
> > Sent: Wednesday, February 28, 2007 10:12 AM
> > To: [hidden email]
> > Subject: Re: SPSS 13.0
> >
> > Dear Stella:
> >
> > This option is not avaible more. And it is one of the most important
> > lost option of SPSS.
> >
> > Really, really sorry.
> >
> > Michael.
> >
> > Stella Vasquez wrote:
> >
> >> In SPSS 12.0 there was an option to freeze variables, I believe it was called "pin" in SPSS, Is this option available in SPSS 13.0?
> >>
> >>
> >>
> >>
> >> Stella Vasquez, Planner II
> >> AZ Department of Juvenile Corrections
> >> 1624 West Adams
> >> Phoenix, AZ 85007
> >> [phone]
> >>
> >>
> >> Did I do a good job, in helping you?
> >> Please take a few minutes and rate my performance.
> >>
> >> Website:
> >> http://intranet.azdjc.gov/Surveys/CustomerServiceSurvey.asp
> >>
> >>
> >>
> >>
> >
> >
> >
>

[Albert-Jan Roskam]

Hi Graham,

That's very very odd.

Can't you avoid the problem by using tab-delimited
ascii instead of xls?

Albert-Jan

--- Graham Wright <[hidden email]> wrote:

> Has anyone had trouble in the past with really weird
> data corruption
> when opening an excel file in SPSS? There is an
> excel file I have
> (generated originally from perseus survey solutions)
> that, if you just
> try to open it in SPSS it looks fine but has some
> really weird
> corruption in it: If the variable blah does not
> already exist and you go
>
> if goreg=1& fulltime=1 blah=1.
>
> one would suspect that the only possible value for
> the new variable blah
> would be 1. However, instead when I do a frequency
> count of the new
> variable I get a number of different answers,
> ranging from 0 to 12. This
> happens with a number of different variables in the
> dataset, and its not
> stable: if you run the command, then delete the new
> variable and run the
> exact same syntax again you get a different
> collection of values, and
> each time you delete the variable and run the syntax
> again you get fewer
> and fewer values, eventually you only gets "1"'s, as
> you should.  This
> only happens in SPSS 14, not SPSS11.
>
> When you turn the excel file into SPSS via DBMS copy
> this doesn't
> happen, but DBMS copy truncates variable names,
> which is annoying. Does
> any of this sound familiar to anyone?
>
> -Graham
>

Cheers!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Did you know that 87.166253% of all statistics claim a precision of results that is not justified by the method employed? [HELMUT RICHTER]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



____________________________________________________________________________________
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html

[Richard Ristow]

At 03:53 PM 2/28/2007, Graham Wright wrote:

>There is an excel file I have (generated originally from perseus
>survey solutions) that, if you just try to open it in SPSS it looks
>fine but has some really weird corruption in it: If the variable blah
>does not already exist and you go
>
>if goreg=1& fulltime=1 blah=1.
>
>when I do a frequency count of the new variable I get a number of
>different [values], ranging from 0 to 12. This happens with a number
>of different variables in the dataset, and its not stable: if you run
>the command, then delete the new variable and run the exact same
>syntax again you get a different collection of values, and each time
>you delete the variable and run the syntax again you get fewer and
>fewer values, eventually you only gets "1"'s, as you should.  This
>only happens in SPSS 14, not SPSS11.

This sounds like one for Tech Support. You'd have to,
- Make sure you're running the latest version of SPSS 14 (it's 14.0.2)
- Be able to send an Excel file that fails; either real data that isn't
too confidential to send, or a constructed file where it happens.
- Send syntax that, when run, exhibits the problem.
- Since the problem is partly intermittent, send also a draft output
file (.RTF) from running the syntax, showing the problem; that is, with
a COMPUTE and FREQUENCIES.
- In the .RTF file, show the syntax and everything else relevant:
Menu Edit>Options>Draft Viewer, select everything under "Display output
items"

I recommend starting SPSS 14, loading and running the syntax, and
saving the draft output, not doing *anything* else in SPSS, first.

I'd also look at,
- If you're not opening the Excel file using syntax, the 'open' should
still operate by generating and running syntax. If that's what you're
doing, capture the syntax from the output file or SPSS journal, paste
into a syntax file, and run that way. It shouldn't make any difference;
on the other hand, your problem shouldn't occur.
- Opening and saving the Excel file in Excel, and then opening it in
SPSS. You write that it's "generated from perseus survey solutions";
maybe that means it's written by non-Excel software that doesn't get
the Excel format quite right. SPSS shouldn't create a corrupted working
file no matter what the input; but again, 'should' and 'is' don't
always match.
- Saving and reloading (SAVE OUTFILE and GET FILE) in SPSS, after
importing from Excel. If your SPSS working file is somehow corrupt,
that's likely either to blow up or to fix it.

-Cheers, and good luck,
  Richard

[Richard Ristow]

At 01:36 PM 2/28/2007, Mariajose Romero wrote:

>I use SPSS 15 in the office and SPSS 9 at home;  is there a way to
>open in SPSS 9 output files generated in SPSS 15?

To read the SPSS 15 output at home, you could export to HTML or PDF.

Or I understand there's the "SPSS Viewer", a program you can copy and
install freely to read SPSS output files. If I'm right, you could
install the SPSS 15 version at home. Unfortunately, I'm not sure about
this - anyway, I can't find instructions on either the SPSS site or the
install CD.

As "Will Bailey [Statman]" <[hidden email]> wrote,

>File all are usable (data & syntax), however, some specific syntax
>might not be backward compatible

Syntax for features added since release 9 isn't backward-compatible, of
course.

There's also one big 'gotcha': SPSS 15 supports long variable names;
SPSS 9 doesn't. To simplify something a little complex: if you use
variable names longer than eight characters, you may find it impossible
to write syntax that will work with those variables under both
releases.

-Good luck,
  Richard

[Melissa Ives]

How does one solve the problem of installing SPSS at work and at home (nominally allowed) when the current licensing process does not allow more than one copy to be installed per single license??

________________________________

From: SPSSX(r) Discussion on behalf of Richard Ristow
Sent: Fri 3/2/2007 9:24 PM
To: [hidden email]
Subject: Re: [SPSSX-L] SPSS 13.0



At 01:36 PM 2/28/2007, Mariajose Romero wrote:

>I use SPSS 15 in the office and SPSS 9 at home;  is there a way to
>open in SPSS 9 output files generated in SPSS 15?

To read the SPSS 15 output at home, you could export to HTML or PDF.

Or I understand there's the "SPSS Viewer", a program you can copy and
install freely to read SPSS output files. If I'm right, you could
install the SPSS 15 version at home. Unfortunately, I'm not sure about
this - anyway, I can't find instructions on either the SPSS site or the
install CD.

As "Will Bailey [Statman]" <[hidden email]> wrote,

>File all are usable (data & syntax), however, some specific syntax
>might not be backward compatible

Syntax for features added since release 9 isn't backward-compatible, of
course.

There's also one big 'gotcha': SPSS 15 supports long variable names;
SPSS 9 doesn't. To simplify something a little complex: if you use
variable names longer than eight characters, you may find it impossible
to write syntax that will work with those variables under both
releases.

-Good luck,
  Richard




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.

[Richard Ristow]

At 01:22 PM 3/3/2007, Melissa Ives wrote:

>How does one solve the problem of installing SPSS at work and at home
>(nominally allowed) when the current licensing process does not allow
>more than one copy to be installed per single license??

I believe, you just do it, and follow the authorization procedures.

In SPSS, Inc., parlance, a 'license' is permission to run SPSS on one
machine.

Whatever server issues the licenses (that's what's happening, when you
run the authorization procedure over the net) keeps track, of course,
of how often an authorization code has been used. Its instructions are
that it issues two licences for a code, before cutting off the spigot.

-Behave licentiously,
  Richard