data won't populate in data editor

[Ed Herzog]

I am running SPSS 17.0 on a brand new computer. I am trying to open some
relatively large files (about 50-100,000 cases with about 200-300 variables
per case). When I open the files, the first 500 or so cases display on my
screen with no problem. However, the rest of the cases only display a
series of question marks. Even after waiting for over an hour, the question
marks do not go away. While some procedures operate fine under these
circumstances, others do not. For example, if I run Select Cases, the
Select Cases only works for the cases that are displayed on the screen and
not for the cases with all the question marks.

A seemingly related problem is that if I click on File, my computer locks
up for a few seconds.  And the File dropdown menu never displays.

I just tried opening a smaller file (5,000 cases, 500 variables) and ran
into the same problem.

The IT people at my work have tried reinstalling SPSS but the problem
persists.

Thanks!

Ed

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

[Lemon, John S.]

You say that you are running 17.0 – have you applied the patches as I seem to remember that this was one of the ‘features’ that happened occasionally with the original release. I regularly open files with fewer variables ( 50 ) but more cases ( up to 2.4 million ) which means the number of cells in my files is more but I don’t experience the problem and this is both on a one year old machine and one that is nearly 5 years old. Whether this has any bearing on it but in both cases I have 3Gbytes of memory and am running Vista.

 

Try patching to the latest release and see what happens.

 

Best Wishes

 

John S. Lemon

DIT ( Directorate of Information Technology ) - Student Liaison Officer

University of Aberdeen

Edward Wright Building: Room G51

 

Tel:  [phone]

Fax: [phone]

 

Diary ( Free / Busy )

 

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Ed Herzog
Sent: 23 June 2009 23:35
To: [hidden email]
Subject: data won't populate in data editor

 

I am running SPSS 17.0 on a brand new computer. I am trying to open some

relatively large files (about 50-100,000 cases with about 200-300 variables

per case). When I open the files, the first 500 or so cases display on my

screen with no problem. However, the rest of the cases only display a

series of question marks. Even after waiting for over an hour, the question

marks do not go away. While some procedures operate fine under these

circumstances, others do not. For example, if I run Select Cases, the

Select Cases only works for the cases that are displayed on the screen and

not for the cases with all the question marks.

 

A seemingly related problem is that if I click on File, my computer locks

up for a few seconds.  And the File dropdown menu never displays.

 

I just tried opening a smaller file (5,000 cases, 500 variables) and ran

into the same problem.

 

The IT people at my work have tried reinstalling SPSS but the problem

persists.

 

Thanks!

 

Ed

 

=====================

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

The University of Aberdeen is a charity registered in Scotland, No SC013683.

[DataMaestro]

Assuming you have at least 1GB of memory and you still have the same problem after you install the updates, try this:

 

After the file is open go to

File>
  Cache Data>

 
--- On Wed, 6/24/09, Lemon, John S. <[hidden email]> wrote:

From: Lemon, John S. <[hidden email]>
Subject: Re: data won't populate in data editor
To: [hidden email]
Date: Wednesday, June 24, 2009, 2:50 AM

You say that you are running 17.0 – have you applied the patches as I seem to remember that this was one of the ‘features’ that happened occasionally with the original release. I regularly open files with fewer variables ( 50 ) but more cases ( up to 2.4 million ) which means the number of cells in my files is more but I don’t experience the problem and this is both on a one year old machine and one that is nearly 5 years old. Whether this has any bearing on it but in both cases I have 3Gbytes of memory and am running Vista.

 

Try patching to the latest release and see what happens.

 

Best Wishes

 

John S. Lemon

DIT ( Directorate of Information Technology ) - Student Liaison Officer

University of Aberdeen

Edward Wright Building: Room G51

 

Tel:  [phone]

Fax: [phone]

 

Diary ( Free / Busy )

 

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Ed Herzog
Sent: 23 June 2009 23:35
To: [hidden email]
Subject: data won't populate in data editor

 

I am running SPSS 17.0 on a brand new computer. I am trying to open some

relatively large files (about 50-100,000 cases with about 200-300 variables

per case). When I open the files, the first 500 or so cases display on my

screen with no problem. However, the rest of the cases only display a

series of question marks. Even after waiting for over an hour, the question

marks do not go away. While some procedures operate fine under these

circumstances, others do not. For example, if I run Select Cases, the

Select Cases only works for the cases that are displayed on the screen and

not for the cases with all the question marks.

 

A seemingly related problem is that if I click on File, my computer locks

up for a few seconds.  And the File dropdown menu never displays.

 

I just tried opening a smaller file (5,000 cases, 500 variables) and ran

into the same problem.

 

The IT people at my work have tried reinstalling SPSS but the problem

persists.

 

Thanks!

 

Ed

 

=====================

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

The University of Aberdeen is a charity registered in Scotland, No SC013683.

[DataMaestro]

sorry didn't fnish...

 

File>

   Cache Data>

       hit "Cache Now"

 

Let us know what works.

 

George

--- On Wed, 6/24/09, George Musick <[hidden email]> wrote:

From: George Musick <[hidden email]>
Subject: Re: data won't populate in data editor
To: [hidden email], " John S.Lemon" <[hidden email]>
Date: Wednesday, June 24, 2009, 3:01 AM

Assuming you have at least 1GB of memory and you still have the same problem after you install the updates, try this:

 

After the file is open go to

File>
  Cache Data>

 
--- On Wed, 6/24/09, Lemon, John S. <[hidden email]> wrote:

From: Lemon, John S. <[hidden email]>
Subject: Re: data won't populate in data editor
To: [hidden email]
Date: Wednesday, June 24, 2009, 2:50 AM

You say that you are running 17.0 – have you applied the patches as I seem to remember that this was one of the ‘features’ that happened occasionally with the original release. I regularly open files with fewer variables ( 50 ) but more cases ( up to 2.4 million ) which means the number of cells in my files is more but I don’t experience the problem and this is both on a one year old machine and one that is nearly 5 years old. Whether this has any bearing on it but in both cases I have 3Gbytes of memory and am running Vista.

 

Try patching to the latest release and see what happens.

 

Best Wishes

 

John S. Lemon

DIT ( Directorate of Information Technology ) - Student Liaison Officer

University of Aberdeen

Edward Wright Building: Room G51

 

Tel:  [phone]

Fax: [phone]

 

Diary ( Free / Busy )

 

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Ed Herzog
Sent: 23 June 2009 23:35
To: [hidden email]
Subject: data won't populate in data editor

 

I am running SPSS 17.0 on a brand new computer. I am trying to open some

relatively large files (about 50-100,000 cases with about 200-300 variables

per case). When I open the files, the first 500 or so cases display on my

screen with no problem. However, the rest of the cases only display a

series of question marks. Even after waiting for over an hour, the question

marks do not go away. While some procedures operate fine under these

circumstances, others do not. For example, if I run Select Cases, the

Select Cases only works for the cases that are displayed on the screen and

not for the cases with all the question marks.

 

A seemingly related problem is that if I click on File, my computer locks

up for a few seconds.  And the File dropdown menu never displays.

 

I just tried opening a smaller file (5,000 cases, 500 variables) and ran

into the same problem.

 

The IT people at my work have tried reinstalling SPSS but the problem

persists.

 

Thanks!

 

Ed

 

=====================

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

The University of Aberdeen is a charity registered in Scotland, No SC013683.

[Gyorgy Bea]

    Hi All,

I try to concatenate few string variables inside a loop, but I got all the time empty variable as a result (Q15).
Any idea, what could be wrong with my syntax? It doesn't give me any error, so I guess it might be some trick with the string functions...


string Q15(A40).
vector v=v_172 to v_187.
vector str=Q15_1 to Q15_16.
loop #i=1 to 16.
   do if v(#i)=1.
      compute Q15=concat(Q15,str(#i),';').
   end if.
end loop.
compute Q15=ltrim(Q15).
exe.


Thanks a lot,
Beata

[Spousta Jan]

Looks like bad trimming of strings, Beata. Try something like

 

string Q15(A40).
vector v=v_172 to v_187.
vector str=Q15_1 to Q15_16.
loop #i=1 to 16.
   do if v(#i)=1.
      compute Q15=concat(RTRIM(Q15),str(#i),';').
   end if.
end loop.
compute Q15=ltrim(Q15).
exe.

Or you can even throw in a LTRIM if needed:

      compute Q15=concat(RTRIM(Q15),LTRIM(str(#i)),';').

HTH

 

Jan

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Gyorgy Bea
Sent: Wednesday, June 24, 2009 10:54 AM
To: [hidden email]
Subject: concatenate string

    Hi All,

I try to concatenate few string variables inside a loop, but I got all the time empty variable as a result (Q15).
Any idea, what could be wrong with my syntax? It doesn't give me any error, so I guess it might be some trick with the string functions...


string Q15(A40).
vector v=v_172 to v_187.
vector str=Q15_1 to Q15_16.
loop #i=1 to 16.
   do if v(#i)=1.
      compute Q15=concat(Q15,str(#i),';').
   end if.
end loop.
compute Q15=ltrim(Q15).
exe.


Thanks a lot,
Beata

 

_____________

Tato zpráva a všechny připojené soubory jsou důvěrné a určené výlučně adresátovi(-ům). Jestliže nejste oprávněným adresátem, je zakázáno jakékoliv zveřejňování, zprostředkování nebo jiné použití těchto informací. Jestliže jste tento mail dostali neoprávněně, prosím, uvědomte odesilatele a smažte zprávu i přiložené soubory. Odesilatel nezodpovídá za jakékoliv chyby nebo opomenutí způsobené tímto přenosem.

P Jste si jisti, že opravdu potřebujete vytisknout tuto zprávu a/nebo její přílohy? Myslete na přírodu.

 

This message and any attached files are confidential and intended solely for the addressee(s). Any publication, transmission or other use of the information by a person or entity other than the intended addressee is prohibited. If you receive this in error please contact the sender and delete the message as well as all attached documents. The sender does not accept liability for any errors or omissions as a result of the transmission.

 

P Are you sure that you really need a print version of this message and/or its attachments? Think about nature.

-.- --

[Gyorgy Bea]

Thanks Jan, it works perfectly :-)  (with both solutions)

---

From: Spousta Jan <[hidden email]>
To: [hidden email]
Sent: Wednesday, June 24, 2009 11:59:37 AM
Subject: Re: concatenate string

Looks like bad trimming of strings, Beata. Try something like

 

string Q15(A40).
vector v=v_172 to v_187.
vector str=Q15_1 to Q15_16.
loop #i=1 to 16.
   do if v(#i)=1.
      compute Q15=concat(RTRIM(Q15),str(#i),';').
   end if.
end loop.
compute Q15=ltrim(Q15).
exe.

Or you can even throw in a LTRIM if needed:

      compute Q15=concat(RTRIM(Q15),LTRIM(str(#i)),';').

HTH

 

Jan

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Gyorgy Bea
Sent: Wednesday, June 24, 2009 10:54 AM
To: [hidden email]
Subject: concatenate string

    Hi All,

I try to concatenate few string variables inside a loop, but I got all the time empty variable as a result (Q15).
Any idea, what could be wrong with my syntax? It doesn't give me any error, so I guess it might be some trick with the string functions...


string Q15(A40).
vector v=v_172 to v_187.
vector str=Q15_1 to Q15_16.
loop #i=1 to 16.
   do if v(#i)=1.
      compute Q15=concat(Q15,str(#i),';').
   end if.
end loop.
compute Q15=ltrim(Q15).
exe.


Thanks a lot,
Beata

 

_____________

Tato zpráva a všechny připojené soubory jsou důvěrné a určené výlučně adresátovi(-ům). Jestliže nejste oprávněným adresátem, je zakázáno jakékoliv zveřejňování, zprostředkování nebo jiné použití těchto informací. Jestliže jste tento mail dostali neoprávněně, prosím, uvědomte odesilatele a smažte zprávu i přiložené soubory. Odesilatel nezodpovídá za jakékoliv chyby nebo opomenutí způsobené tímto přenosem.

P Jste si jisti, že opravdu potřebujete vytisknout tuto zprávu a/nebo její přílohy? Myslete na přírodu.

 

This message and any attached files are confidential and intended solely for the addressee(s). Any publication, transmission or other use of the information by a person or entity other than the intended addressee is prohibited. If you receive this in error please contact the sender and delete the message as well as all attached documents. The sender does not accept liability for any errors or omissions as a result of the transmission.

 

P Are you sure that you really need a print version of this message and/or its attachments? Think about nature.

-.- --

[Ed Herzog]

Thanks for the responses.  I do have the patches installed.  I also tried
clearing the cache and that didn't help.  I've talked to our IT people and
I'm going to have them switch me to a different computer (in the hopes that
it's a hardware issue).

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

[Arthur Burke]

Ed ...Does your file reside on a network drive or a local drive?
Opening the file from your C: drive should be faster. Also closing
Outlook and Word before you open your SPSS file should help.

Art

-----Original Message-----
From: Ed Herzog [mailto:[hidden email]]
Sent: Tuesday, June 23, 2009 3:35 PM
To: [hidden email]
Subject: data won't populate in data editor

I am running SPSS 17.0 on a brand new computer. I am trying to open some
relatively large files (about 50-100,000 cases with about 200-300
variables per case). When I open the files, the first 500 or so cases
display on my screen with no problem. However, the rest of the cases
only display a series of question marks. Even after waiting for over an
hour, the question marks do not go away. While some procedures operate
fine under these circumstances, others do not. For example, if I run
Select Cases, the Select Cases only works for the cases that are
displayed on the screen and not for the cases with all the question
marks.

A seemingly related problem is that if I click on File, my computer
locks up for a few seconds.  And the File dropdown menu never displays.

I just tried opening a smaller file (5,000 cases, 500 variables) and ran
into the same problem.

The IT people at my work have tried reinstalling SPSS but the problem
persists.

Thanks!

Ed

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

[Doug]

This happens with large-ish data files when I'm scrolling through the
data sheets. I believe it is just that SPSS' refresh rate is too slow
to keep up; the data are still there. But Art's suggestions are good
ones.

Doug

On Wed, Jun 24, 2009 at 1:50 PM, Arthur Burke<[hidden email]> wrote:

> Ed ...Does your file reside on a network drive or a local drive?
> Opening the file from your C: drive should be faster. Also closing
> Outlook and Word before you open your SPSS file should help.
>
> Art
>
> -----Original Message-----
> From: Ed Herzog [mailto:[hidden email]]
> Sent: Tuesday, June 23, 2009 3:35 PM
> To: [hidden email]
> Subject: data won't populate in data editor
>
> I am running SPSS 17.0 on a brand new computer. I am trying to open some
> relatively large files (about 50-100,000 cases with about 200-300
> variables per case). When I open the files, the first 500 or so cases
> display on my screen with no problem. However, the rest of the cases
> only display a series of question marks. Even after waiting for over an
> hour, the question marks do not go away. While some procedures operate
> fine under these circumstances, others do not. For example, if I run
> Select Cases, the Select Cases only works for the cases that are
> displayed on the screen and not for the cases with all the question
> marks.
>
> A seemingly related problem is that if I click on File, my computer
> locks up for a few seconds.  And the File dropdown menu never displays.
>
> I just tried opening a smaller file (5,000 cases, 500 variables) and ran
> into the same problem.
>
> The IT people at my work have tried reinstalling SPSS but the problem
> persists.
>
> Thanks!
>
> Ed
>
> =====================
> 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

[DataMaestro]

Doug,

 

If you set "Cache Now" that problem should go away.

 

George

--- On Wed, 6/24/09, Doug Nutter <[hidden email]> wrote:

From: Doug Nutter <[hidden email]>
Subject: Re: data won't populate in data editor
To: [hidden email]
Date: Wednesday, June 24, 2009, 2:04 PM

This happens with large-ish data files when I'm scrolling through the
data sheets. I believe it is just that SPSS' refresh rate is too slow
to keep up; the data are still there. But Art's suggestions are good
ones.

Doug

On Wed, Jun 24, 2009 at 1:50 PM, Arthur Burke<burkea@...> wrote:

> Ed ...Does your file reside on a network drive or a local drive?
> Opening the file from your C: drive should be faster. Also closing
> Outlook and Word before you open your SPSS file should help.
>
> Art
>
> -----Original Message-----
> From: Ed Herzog [mailto:EMHERZOG@...]
> Sent: Tuesday, June 23, 2009 3:35 PM
> To: SPSSX-L@...
> Subject: data won't populate in data editor
>
> I am running SPSS 17.0 on a brand new computer. I am trying to open some
> relatively large files (about 50-100,000 cases with about 200-300
> variables per case). When I open the files, the first 500 or so cases
> display on my screen with no problem. However, the rest of the cases
> only display a series of question marks. Even after waiting for over an
> hour, the question marks do not go away. While some procedures operate
> fine under these circumstances, others do not. For example, if I run
> Select Cases, the Select Cases only works for the cases that are
> displayed on the screen and not for the cases with all the question
> marks.
>
> A seemingly related problem is that if I click on File, my computer
> locks up for a few seconds.  And the File dropdown menu never displays.
>
> I just tried opening a smaller file (5,000 cases, 500 variables) and ran
> into the same problem.
>
> The IT people at my work have tried reinstalling SPSS but the problem
> persists.
>
> Thanks!
>
> Ed
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> LISTSERV@... (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
> LISTSERV@... (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
LISTSERV@... (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

[Peck, Jon]

Note that if you turn on Unicode mode (SET UNICODE ON or via Edit>Options), the concat function automatically trims trailing blanks, so no RTRIM call is required.  This was part of the rework of the string functions in association with the introduction of all the char.* functions such as char.substr.  These functions treat strings as characters rather than bytes, which can be important if you have characters that are not plain ascii.

 

Regards,

Jon Peck

 

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Spousta Jan
Sent: Wednesday, June 24, 2009 3:00 AM
To: [hidden email]
Subject: Re: [SPSSX-L] concatenate string

 

Looks like bad trimming of strings, Beata. Try something like

 

string Q15(A40).
vector v=v_172 to v_187.
vector str=Q15_1 to Q15_16.
loop #i=1 to 16.
   do if v(#i)=1.
      compute Q15=concat(RTRIM(Q15),str(#i),';').
   end if.
end loop.
compute Q15=ltrim(Q15).
exe.

Or you can even throw in a LTRIM if needed:

      compute Q15=concat(RTRIM(Q15),LTRIM(str(#i)),';').

HTH

 

Jan

 

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Gyorgy Bea
Sent: Wednesday, June 24, 2009 10:54 AM
To: [hidden email]
Subject: concatenate string

 

    Hi All,

I try to concatenate few string variables inside a loop, but I got all the time empty variable as a result (Q15).
Any idea, what could be wrong with my syntax? It doesn't give me any error, so I guess it might be some trick with the string functions...


string Q15(A40).
vector v=v_172 to v_187.
vector str=Q15_1 to Q15_16.
loop #i=1 to 16.
   do if v(#i)=1.
      compute Q15=concat(Q15,str(#i),';').
   end if.
end loop.
compute Q15=ltrim(Q15).
exe.


Thanks a lot,
Beata

 

_____________

Tato zpráva a všechny připojené soubory jsou důvěrné a určené výlučně adresátovi(-ům). Jestliže nejste oprávněným adresátem, je zakázáno jakékoliv zveřejňování, zprostředkování nebo jiné použití těchto informací. Jestliže jste tento mail dostali neoprávněně, prosím, uvědomte odesilatele a smažte zprávu i přiložené soubory. Odesilatel nezodpovídá za jakékoliv chyby nebo opomenutí způsobené tímto přenosem.

P Jste si jisti, že opravdu potřebujete vytisknout tuto zprávu a/nebo její přílohy? Myslete na přírodu.

 

This message and any attached files are confidential and intended solely for the addressee(s). Any publication, transmission or other use of the information by a person or entity other than the intended addressee is prohibited. If you receive this in error please contact the sender and delete the message as well as all attached documents. The sender does not accept liability for any errors or omissions as a result of the transmission.

 

P Are you sure that you really need a print version of this message and/or its attachments? Think about nature.

-.- --