creating score reports from SPSS data

[Dogan, Enis]

 
Dear all
I am trying to put together individual score reports (in Word or Excel) using data stored in SPSS.
So my question is how can i go from here (in SPSS):
 
Class_ID       student_ID     total_score   irrelevant_variable   gender
1                    113                 12                99                          1
1                    118                 17                99                          2
 
To here (in word or excel):
 
Student ID: 113
Class ID: 1
Total score: 12
Gender: 1
 
 
Student ID: 118
Class ID: 1
Total score: 17
Gender: 2
 
thank you
 
Enis
 

[Judith Saebel]

I think I'd use the print command, i.e.:


print records = 5
 /1 'Student ID: ' student_ID
 /2 'Class ID:   ' Class_ID
 /3 'Total Score:' total_score
 /4 'Gender:     ' gender
 /5 '            '
execute.

[The fifth line is to insert a blank line between the individual
students' data.]

Then I'd copy the output into a word document.

HTH,

Judith


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Dogan, Enis
Sent: Tuesday, 28 November 2006 14:36
To: [hidden email]
Subject: creating score reports from SPSS data


Dear all
I am trying to put together individual score reports (in Word or Excel)
using data stored in SPSS.
So my question is how can i go from here (in SPSS):

Class_ID       student_ID     total_score   irrelevant_variable   gender
1                    113                 12                99
1
1                    118                 17                99
2

To here (in word or excel):

Student ID: 113
Class ID: 1
Total score: 12
Gender: 1


Student ID: 118
Class ID: 1
Total score: 17
Gender: 2

thank you

Enis

[Hal 9000]

Judith, excellent! I can't believe this procedure escaped my attention. I'll
be using this for certain types of error reports :)

(Enis, this looks like the way)

-Gary


On 11/27/06, Judith Saebel <[hidden email]> wrote:

>
> I think I'd use the print command, i.e.:
>
>
> print records = 5
> /1 'Student ID: ' student_ID
> /2 'Class ID:   ' Class_ID
> /3 'Total Score:' total_score
> /4 'Gender:     ' gender
> /5 '            '
> execute.
>
> [The fifth line is to insert a blank line between the individual
> students' data.]
>
> Then I'd copy the output into a word document.
>
> HTH,
>
> Judith
>
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Dogan, Enis
> Sent: Tuesday, 28 November 2006 14:36
> To: [hidden email]
> Subject: creating score reports from SPSS data
>
>
> Dear all
> I am trying to put together individual score reports (in Word or Excel)
> using data stored in SPSS.
> So my question is how can i go from here (in SPSS):
>
> Class_ID       student_ID     total_score   irrelevant_variable   gender
> 1                    113                 12                99
> 1
> 1                    118                 17                99
> 2
>
> To here (in word or excel):
>
> Student ID: 113
> Class ID: 1
> Total score: 12
> Gender: 1
>
>
> Student ID: 118
> Class ID: 1
> Total score: 17
> Gender: 2
>
> thank you
>
> Enis
>

[Dogan, Enis]

Dear all

 

I am trying to extract variables from a (relatively large) data file
saved originally as text. And I get this message (terminating due to
catastrophic error) after about 6,200 cases are saved. Output reads:

 

File: D:\child5l.dat

Error detected in: GetToNL

Error: Invalid argument

File pointer:  0x7c38b688

File number:  14

 

>Error # 1209

>The host system has detected an error related to an input or output

>operation.

>This is an error from which SPSS cannot recover.

>The SPSS run will terminate now.

 

End of job:  4501 command lines  1 errors  0 warnings  242 CPU seconds

 

Any idea why?

 

Thank you

 

Enis

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

[Fry, Jonathan B.]

SPSS tried to read from your file and got an error from the operating system.  The indication it gave was "Invalid argument," which doesn't tell us much.  I've seen it sometimes when attempting to read or write a very large file using Windows file sharing.  Was this file on the same machine as SPSS was running on?  If not, try copying it to a local disk and reading it from there.

Jonathan Fry
SPSS Inc.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Dogan, Enis
Sent: Thursday, February 14, 2008 12:06 PM
To: [hidden email]
Subject: terminating due to catastrophic error??

Dear all

I am trying to extract variables from a (relatively large) data file
saved originally as text. And I get this message (terminating due to
catastrophic error) after about 6,200 cases are saved. Output reads:

File: D:\child5l.dat
Error detected in: GetToNL
Error: Invalid argument
File pointer:  0x7c38b688
File number:  14
>Error # 1209
>The host system has detected an error related to an input or output
>operation.
>This is an error from which SPSS cannot recover.
>The SPSS run will terminate now.

End of job:  4501 command lines  1 errors  0 warnings  242 CPU seconds

[snip]

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