student database

[Johnny Amora]

A student database in spss format had been created
starting 2003. Some of the variables are:
student_name(string), ID_number(numeric), quarter (4
quarters coded 1, 2, 3, & 4) school_year (2003-2004,
2004-2005, etc), and status_whether_active_or_not.
Each student appeared in the database every term per
school year. Thus, if a student(say, John Amora) was
first enrolled in the first quarter of school year
2003-2004 and then graduated in the 1st quarter of
school year 2007-2008, then his data appeared in the
database as follows:

Student_Name  ID_number  Quarter  school_year  status
John Amora    01         1        2003-2004    active
John Amora    01         2        2003-2004    active
John Amora    01         3        2003-2004    active
John Amora    01         4        2003-2004    active
John Amora    01         1        2004-2005    active
John Amora    01         2        2004-2005    active
John Amora    01         3        2004-2005    active
John Amora    01         4        2004-2005    active
John Amora    01         1        2005-2006
on-leave
John Amora    01         2        2005-2006    active
John Amora    01         3        2005-2006    active
John Amora    01         4        2005-2006    active
John Amora    01         1        2006-2007    active
John Amora    01         2        2006-2007    active
John Amora    01         3        2006-2007    active
John Amora    01         4        2006-2007    active
John Amora    01         1       2007-2008
graduated

In the database, there are about 500 thousand students
in all, accumulated from 2003 to 2008. Each term after
the 1st quarter of 2003-2004, a new batch of students
(freshmen & transferee) was added into the database,
thus,the database contains the old batch (those who
enrolled in the first quarter of 2003-2004) plus the
new batch in the following quarter.  My goal is to
create a separate database by removing the batch of
students being entered in the database every quarter.
That is, my new database would contain only the
students enrolled in the first quarter of 2003-2004. I
appreciate if somebody could provide the syntax?

Thank you.
Johnny








      ____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

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

[Maguin, Eugene]

John,

I think I must be misunderstanding your question. These two statements seem
to conflict.

>>My goal is to create a separate database by removing the batch of students
being entered in the database every quarter.

Can't this be looked at like this. Upon creation of the database, students
enrolled in quarter 1, 03-04 were entered. At each succeeding quarter, more
students were entered, some who had not been enrolled in any previous
quarter and some who had been enrolled in the previous quarter. But, every
student has been entered. Therefore, the database you describe is the empty
database, one with no records. This can't be what you mean.

>>That is, my new database would contain only the students enrolled in the
first quarter of 2003-2004.

This statement implies

Select if (Quarter eq 1 and school_year eq '2003-2004').

I can't believe that you mean this either. Am I misunderstanding you?

Gene Maguin

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

[Johnny Amora]

I wrote again here to make everything clear.

Let "Batch1" be the batch of college students
(freshmen/tranferees) enrolled in the first quarter of
2003-2004. In every succeeding quarters, all students
in Batch1 were entered into the database, regardless
of whether they were on-leave or dropped. There is a
variable "status" in the database so that the status
of the students whether on-leave or dropped can be
determined.

In the 2nd quarter of 2003-2004, another batch of
students "Batch2" enrolled. These students had never
been enrolled in the previous quarter. These students
were then entered into the same database (the database
containing Batch1).  Thus, the database in the 2nd
quarter had contained the Batch1 and Batch2.  However,
there is no variable showing that the student is from
Batch1 or Batch2.

In the 3rd quarter of 2003-2004, another batch of
students "Batch3" coming in. Again, these students had
never been enrolled in the previous quarter. Thus, the
database in the 3rd quarter had contained the students
from Batch1, Batch2, and Batch3.

This process continued until the fourth quarter of
2006-2007.

The goal is to create a separate database which
contains only the Batch1 througout quarters from 2003
to 2007.  I appreciate if somebody could help me to
create the syntax.

I hope this is already clear.

Thank you.

John



--- Gene Maguin <[hidden email]> wrote:

> John,
>
> I think I must be misunderstanding your question.
> These two statements seem
> to conflict.
>
> >>My goal is to create a separate database by
> removing the batch of students
> being entered in the database every quarter.
>
> Can't this be looked at like this. Upon creation of
> the database, students
> enrolled in quarter 1, 03-04 were entered. At each
> succeeding quarter, more
> students were entered, some who had not been
> enrolled in any previous
> quarter and some who had been enrolled in the
> previous quarter. But, every
> student has been entered. Therefore, the database
> you describe is the empty
> database, one with no records. This can't be what
> you mean.
>
> >>That is, my new database would contain only the
> students enrolled in the
> first quarter of 2003-2004.
>
> This statement implies
>
> Select if (Quarter eq 1 and school_year eq
> '2003-2004').
>
> I can't believe that you mean this either. Am I
> misunderstanding you?
>
> Gene Maguin
>
> =====================
> 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
>

      ____________________________________________________________________________________
Like movies? Here's a limited-time offer: Blockbuster Total Access for one month at no cost.
http://tc.deals.yahoo.com/tc/blockbuster/text4.com

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

[Marks, Jim]

John:

Try this (untested). It requires
        your data to be sorted on student id
        your original dataset to be named orig
        a variable called student_id
        a variable called date to indicate quarter.


DATASET COPY q1_list.
DATASET ACTIVATE q1_list.

*** Replace "date" with the variable and "Q1" with the value that
indicates Batch1.
SELECT IF date =Q1.
COMPUTE batch1 = 1.
EXECUTE.

*** Replace "orig" with the name of working dataset.
DATASET ACTIVATE orig.

*** Replace student_id with your variable to identify individual
students.
MATCH FILES FILE = * /TABLE = q1_list /BY student_id.
EXECUTE.

If you really want to identify all batches, we would use AGGREGATE
instead of SELECT IF.

--jim

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
John Amora
Sent: Sunday, March 30, 2008 9:00 PM
To: [hidden email]
Subject: Re: student database

I wrote again here to make everything clear.

Let "Batch1" be the batch of college students
(freshmen/tranferees) enrolled in the first quarter of 2003-2004. In
every succeeding quarters, all students in Batch1 were entered into the
database, regardless of whether they were on-leave or dropped. There is
a variable "status" in the database so that the status of the students
whether on-leave or dropped can be determined.

In the 2nd quarter of 2003-2004, another batch of students "Batch2"
enrolled. These students had never been enrolled in the previous
quarter. These students were then entered into the same database (the
database containing Batch1).  Thus, the database in the 2nd quarter had
contained the Batch1 and Batch2.  However, there is no variable showing
that the student is from
Batch1 or Batch2.

In the 3rd quarter of 2003-2004, another batch of students "Batch3"
coming in. Again, these students had never been enrolled in the previous
quarter. Thus, the database in the 3rd quarter had contained the
students from Batch1, Batch2, and Batch3.

This process continued until the fourth quarter of 2006-2007.

The goal is to create a separate database which contains only the Batch1
througout quarters from 2003 to 2007.  I appreciate if somebody could
help me to create the syntax.

I hope this is already clear.

Thank you.

John



--- Gene Maguin <[hidden email]> wrote:

> John,
>
> I think I must be misunderstanding your question.
> These two statements seem
> to conflict.
>
> >>My goal is to create a separate database by
> removing the batch of students
> being entered in the database every quarter.
>
> Can't this be looked at like this. Upon creation of the database,
> students enrolled in quarter 1, 03-04 were entered. At each succeeding

> quarter, more students were entered, some who had not been enrolled in

> any previous quarter and some who had been enrolled in the previous
> quarter. But, every student has been entered. Therefore, the database
> you describe is the empty database, one with no records. This can't be

> what you mean.
>
> >>That is, my new database would contain only the
> students enrolled in the
> first quarter of 2003-2004.
>
> This statement implies
>
> Select if (Quarter eq 1 and school_year eq '2003-2004').
>
> I can't believe that you mean this either. Am I misunderstanding you?
>
> Gene Maguin
>
> =====================
> 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
>




________________________________________________________________________
____________
Like movies? Here's a limited-time offer: Blockbuster Total Access for
one month at no cost.
http://tc.deals.yahoo.com/tc/blockbuster/text4.com

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

[Richard Ristow]

At 08:39 PM 3/26/2008, John Amora wrote:

>A student database in spss format had been created starting 2003.
>Some of the variables are:
>student_name(string), ID_number(numeric), quarter (4 quarters coded
>1, 2, 3, & 4) school_year (2003-2004, 2004-2005, etc), and
>status_whether_active_or_not.

>My goal is to create a separate database by removing the batch of
>students being entered in the database every quarter.

and at 09:00 PM 3/30/2008, clarified:

>Let "Batch1" be the batch of college students (freshmen/tranferees)
>enrolled in the first quarter of 2003-2004. In every succeeding
>quarters, all students in Batch1 were entered into the database,
>regardless of whether they were on-leave or dropped.
>
>In the 2nd quarter of 2003-2004, another batch of students "Batch2"
>enrolled. These students had never been enrolled in the previous
>quarter. These students were then entered into the same database
>(the database containing Batch1).  Thus, the database in the 2nd
>quarter had contained the Batch1 and Batch2.  However, there is no
>variable showing that the student is from Batch1 or Batch2. [...]

OK. It looks like your "Batch" is actually the quarter in which the
student enrolled, which is the first quarter in which the student
appears in the database. (That's risky dataset organization, by the
way. The indication a student enrolled in a particular quarter is
*absence* of records from earlier quarters; and inferring an event
from an absence is always risky. Better practice would be a record
inserted when the student enrolled; or, a variable with the record
for quarter indicating that the student did, or did not, enroll in
that quarter.)

So you want the earliest quarter in which the student appears in the
database. You have

>Student_Name  ID_number  Quarter  school_year  status
>John Amora    01         1        2003-2004    active
>John Amora    01         2        2003-2004    active
>John Amora    01         3        2003-2004    active
>John Amora    01         4        2003-2004    active
>John Amora    01         1        2004-2005    active

"School_year" has to be a character variable. I'll assume "Quarter"
is a numeric. The following code is not tested:

*  Get the quarter as a single character variable, .
*  yyyy-yyyy.q                                     .
STRING  Qtr_ID (A11).
COMPUTE Qtr_ID = CONCAT(school_year,
                         '.',
                         STRING(Quarter,F1)).

AGGREGATE OUTFILE=* MODE=ADDVARIABLES
    /BREAK=ID_Number
    /FirstQtr 'Earliest quarter where student appears'
          = MIN(Qtr_ID).

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

[hillel vardi]

Shalom

The fallowing syntax will create two new variable
  first_year_Quarter witch is the same for all lines of the same student
, the same for all the "Batch"
  first_year_for_student is the first line for each student .
You can use "split file by first_year_Quarter "  to get analysis by
batch , or you can  "select if     first_year_Quarter = 20021 " to work
on the first batch .

title  " add Batch number  to student data " .
data  list   list  /fname(a5) lName (a10)  ID_number(f3)  Quarter(f3)
school_year(f5)  status (a10) .
begin data.
John l        01         1        2003    active
John l        01         3        2003    active
John l        01         1        2005    active
John Amora    01         1        2003    active
John Amora    01         2        2003    active
John Amora    01         3        2003    active
John Amora    01         4        2003    active
John Amora    01         1        2004    active
John Amora    01         2        2004    active
John Amora    01         3        2004    active
John Amora    01         4        2004    active
John Amora    01         1        2006    on-leave
John b        01         1        2002    on-leave
John b        01         1        2006    on-leave
John b        01         1        2004    on-leave
l    Amora    01         1        2002    active
l    Amora    01         3        2002    active
l    Amora    01         4        2002    active
l    Amora    01         1        2004    active
l    Amora    01         2        2004    active
l    Amora    01         3        2004    active
l    Amora    01         4        2004    active
l    Amora    01         1        2007    graduated
end data .
compute   year_Quarter= school_year * 10 + Quarter .
execute .
AGGREGATE
  /OUTFILE=*   MODE=ADDVARIABLES
  /BREAK=fname lName
  /first_year_Quarter= min(year_Quarter).
if      first_year_Quarter eq year_Quarter   first_year_for_student=1 .
sort cases by first_year_Quarter fname lname year_Quarter .


Hillel Vardi
BGU



John Amora wrote:

> A student database in spss format had been created
> starting 2003. Some of the variables are:
> student_name(string), ID_number(numeric), quarter (4
> quarters coded 1, 2, 3, & 4) school_year (2003-2004,
> 2004-2005, etc), and status_whether_active_or_not.
> Each student appeared in the database every term per
> school year. Thus, if a student(say, John Amora) was
> first enrolled in the first quarter of school year
> 2003-2004 and then graduated in the 1st quarter of
> school year 2007-2008, then his data appeared in the
> database as follows:
>
> Student_Name  ID_number  Quarter  school_year  status
> John Amora    01         1        2003-2004    active
> John Amora    01         2        2003-2004    active
> John Amora    01         3        2003-2004    active
> John Amora    01         4        2003-2004    active
> John Amora    01         1        2004-2005    active
> John Amora    01         2        2004-2005    active
> John Amora    01         3        2004-2005    active
> John Amora    01         4        2004-2005    active
> John Amora    01         1        2005-2006
> on-leave
> John Amora    01         2        2005-2006    active
> John Amora    01         3        2005-2006    active
> John Amora    01         4        2005-2006    active
> John Amora    01         1        2006-2007    active
> John Amora    01         2        2006-2007    active
> John Amora    01         3        2006-2007    active
> John Amora    01         4        2006-2007    active
> John Amora    01         1       2007-2008
> graduated
>
> In the database, there are about 500 thousand students
> in all, accumulated from 2003 to 2008. Each term after
> the 1st quarter of 2003-2004, a new batch of students
> (freshmen & transferee) was added into the database,
> thus,the database contains the old batch (those who
> enrolled in the first quarter of 2003-2004) plus the
> new batch in the following quarter.  My goal is to
> create a separate database by removing the batch of
> students being entered in the database every quarter.
> That is, my new database would contain only the
> students enrolled in the first quarter of 2003-2004. I
> appreciate if somebody could provide the syntax?
>
> Thank you.
> Johnny
>
>
>
>
>
>
>
>
>       ____________________________________________________________________________________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>
> =====================
> 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

[Johnny Amora]

Hello listers,

This concern was already posted one month ago, but I
reposted because it is not yet solved.

A student database in spss format had been created
starting 2003. Some of the variables are:
student_name(string), ID_number(numeric),
quarter(numeric coded as 1, 2, 3, & 4) and school_year
(string such as 2003-2004, 2004-2005,etc).

The creation of the database was like this:
1. During the first quarter in school year 2003-2004,
the first batch of students (Batch 1) who enrolled the
college were entered into a database.
2. In every succeeding quarters, all batch 1 students
were also entered into the same database, regardless
of whether the students were enrolled or not in that
quarter.
3.During the 2nd quarter of 2003-2004, another batch
of students "Batch2" enrolled in the same college.
These students had never been enrolled in the previous
quarter. These students were then entered into the
same database(the database containing Batch1).  Thus,
the database during the 2nd quarter contained the
Batch1 and Batch2. However, there is no variable
showing that the student is from Batch1 or Batch2.

4. The same thing was done in the succeeding quarters
until school year 2007-2008.  Thus, batch 1 appeared
in the database every quarter from 2003 to 2008.

The goal is to add another variable in the database
such that the variable is 1 if the student is from
batch 1; and 0 otherwise.

I would appreciate if someone could provide the
syntax.

Thank you.

Johnny





      ____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.
http://tc.deals.yahoo.com/tc/blockbuster/text5.com

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

[David Wasserman]

Try the following syntax (untested) that creates a separate table (file) of
student Ids of students who were in the first year and first quarter data.
It then creates a new variable batch1 and assigns a value of 1 for those
students.  This file is matched back into the original file by ID_number as
a table match.  The new file will then have a variable batch1 with value 1
in every record for every student who was in the first quarter data for the
first year.  The other students will have a variable batch1 with a missing
value, which is changed to 0.

Save outfile = temp1.
Get file = temp1.
Select if quarter eq 1 and school_year eq "2003-2004".
Compute batch1 = 1.
Sort cases by ID_number.
Save outfile = temp2/keep = ID_number batch1.
Get file = temp1.
Sort cases by ID_number.
Match files file = */table = temp2/by ID_number.
If missing(batch1) batch1 = 0.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
John Amora
Sent: April-08-08 10:35 PM
To: [hidden email]
Subject: database

Hello listers,

This concern was already posted one month ago, but I
reposted because it is not yet solved.

A student database in spss format had been created
starting 2003. Some of the variables are:
student_name(string), ID_number(numeric),
quarter(numeric coded as 1, 2, 3, & 4) and school_year
(string such as 2003-2004, 2004-2005,etc).

The creation of the database was like this:
1. During the first quarter in school year 2003-2004,
the first batch of students (Batch 1) who enrolled the
college were entered into a database.
2. In every succeeding quarters, all batch 1 students
were also entered into the same database, regardless
of whether the students were enrolled or not in that
quarter.
3.During the 2nd quarter of 2003-2004, another batch
of students "Batch2" enrolled in the same college.
These students had never been enrolled in the previous
quarter. These students were then entered into the
same database(the database containing Batch1).  Thus,
the database during the 2nd quarter contained the
Batch1 and Batch2. However, there is no variable
showing that the student is from Batch1 or Batch2.

4. The same thing was done in the succeeding quarters
until school year 2007-2008.  Thus, batch 1 appeared
in the database every quarter from 2003 to 2008.

The goal is to add another variable in the database
such that the variable is 1 if the student is from
batch 1; and 0 otherwise.

I would appreciate if someone could provide the
syntax.

Thank you.

Johnny






____________________________________________________________________________
________
You rock. That's why Blockbuster's offering you one month of Blockbuster
Total Access, No Cost.
http://tc.deals.yahoo.com/tc/blockbuster/text5.com

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

[Johnny Amora]

Hi David,

Your syntax works. Its a great help.
Thank you.

Johnny


--- David Wasserman <[hidden email]> wrote:

> Try the following syntax (untested) that creates a
> separate table (file) of
> student Ids of students who were in the first year
> and first quarter data.
> It then creates a new variable batch1 and assigns a
> value of 1 for those
> students.  This file is matched back into the
> original file by ID_number as
> a table match.  The new file will then have a
> variable batch1 with value 1
> in every record for every student who was in the
> first quarter data for the
> first year.  The other students will have a variable
> batch1 with a missing
> value, which is changed to 0.
>
> Save outfile = temp1.
> Get file = temp1.
> Select if quarter eq 1 and school_year eq
> "2003-2004".
> Compute batch1 = 1.
> Sort cases by ID_number.
> Save outfile = temp2/keep = ID_number batch1.
> Get file = temp1.
> Sort cases by ID_number.
> Match files file = */table = temp2/by ID_number.
> If missing(batch1) batch1 = 0.
>
> -----Original Message-----
> From: SPSSX(r) Discussion
> [mailto:[hidden email]] On Behalf Of
> John Amora
> Sent: April-08-08 10:35 PM
> To: [hidden email]
> Subject: database
>
> Hello listers,
>
> This concern was already posted one month ago, but I
> reposted because it is not yet solved.
>
> A student database in spss format had been created
> starting 2003. Some of the variables are:
> student_name(string), ID_number(numeric),
> quarter(numeric coded as 1, 2, 3, & 4) and
> school_year
> (string such as 2003-2004, 2004-2005,etc).
>
> The creation of the database was like this:
> 1. During the first quarter in school year
> 2003-2004,
> the first batch of students (Batch 1) who enrolled
> the
> college were entered into a database.
> 2. In every succeeding quarters, all batch 1
> students
> were also entered into the same database, regardless
> of whether the students were enrolled or not in that
> quarter.
> 3.During the 2nd quarter of 2003-2004, another batch
> of students "Batch2" enrolled in the same college.
> These students had never been enrolled in the
> previous
> quarter. These students were then entered into the
> same database(the database containing Batch1).
> Thus,
> the database during the 2nd quarter contained the
> Batch1 and Batch2. However, there is no variable
> showing that the student is from Batch1 or Batch2.
>
> 4. The same thing was done in the succeeding
> quarters
> until school year 2007-2008.  Thus, batch 1 appeared
> in the database every quarter from 2003 to 2008.
>
> The goal is to add another variable in the database
> such that the variable is 1 if the student is from
> batch 1; and 0 otherwise.
>
> I would appreciate if someone could provide the
> syntax.
>
> Thank you.
>
> Johnny
>
>
>
>
>
>
>

____________________________________________________________________________

> ________
> You rock. That's why Blockbuster's offering you one
> month of Blockbuster
> Total Access, No Cost.
> http://tc.deals.yahoo.com/tc/blockbuster/text5.com
>
> =====================
> 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
>

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

[Richard Ristow]

At 12:35 AM 4/9/2008, John Amora wrote:

>This concern was already posted one month ago, but I reposted
>because it is not yet solved.

I'm glad you have a solution now. But what was wrong with the ones
that were posted before? You had, at least,

Date:     Mon, 31 Mar 2008 10:49:04 -0500
From:     Richard Ristow <[hidden email]>
Subject:  Re: student database
To:       [hidden email]
(with tested code)

and
Status:  U
Return-Path: <[hidden email]>
Received: from noehlo.host ([127.0.0.1])
         by msmx-page.atl.sa.earthlink.net (EarthLink SMTP Server)
with SMTP id 1jGwZx6zH3PGoUC0; Mon, 31 Mar 2008 23:16:55 -0400 (EDT)
Received: from malibu.cc.uga.edu ([128.192.1.103])
         by msmx-page.atl.sa.earthlink.net (EarthLink SMTP Server)
with ESMTP id 1jGwZx6mD3PGoUC0; Mon, 31 Mar 2008 23:16:55 -0400 (EDT)
Received: from listserv.uga.edu (listserv.uga.edu [128.192.1.75])
         by malibu.cc.uga.edu (8.12.11.20060308/8.12.11) with ESMTP
id m311PeLD020287;
         Mon, 31 Mar 2008 23:10:14 -0400
Received: from LISTSERV.UGA.EDU by LISTSERV.UGA.EDU (LISTSERV-TCP/IP release
           1.8d) with spool id 214553 for [hidden email]; Mon, 31 Mar
           2008 23:10:13 -0400
Approved-By: [hidden email]
Received: from smtp1.bgu.ac.il (smtp1.bgu.ac.il [132.72.126.38]) by
           listserv.uga.edu (8.13.1/8.13.1) with ESMTP id m2VLEleq024572 for
           <[hidden email]>; Mon, 31 Mar 2008 17:14:52 -0400
Received: from smtp1.bgu.ac.il (localhost.localdomain [127.0.0.1]) by
           postfix.imss70 (Postfix) with ESMTP id 1ACC91A27AA; Tue,  1 Apr 2008
           00:14:47 +0300 (IDT)
Received: from [132.72.73.204] (unknown [132.72.73.204]) by smtp1.bgu.ac.il
           (Postfix) with ESMTP id F0D0A1A2785; Tue,  1 Apr 2008 00:14:46 +0300
           (IDT)
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
References: <[hidden email]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Scanned-By: Digested by UGA Mail Gateway on 128.192.1.75
Message-ID:  <[hidden email]>

Date:     Mon, 31 Mar 2008 23:14:45 +0200
From:     hillel vardi <[hidden email]>
Subject:  Re: student database
To:       [hidden email]

at least.

>A student database in spss format had been created
>starting 2003. Some of the variables are:
>student_name(string), ID_number(numeric),
>quarter(numeric coded as 1, 2, 3, & 4) and school_year
>(string such as 2003-2004, 2004-2005,etc).
>
>The creation of the database was like this:
>1. During the first quarter in school year 2003-2004,
>the first batch of students (Batch 1) who enrolled the
>college were entered into a database.
>2. In every succeeding quarters, all batch 1 students
>were also entered into the same database, regardless
>of whether the students were enrolled or not in that
>quarter.
>3.During the 2nd quarter of 2003-2004, another batch
>of students "Batch2" enrolled in the same college.
>These students had never been enrolled in the previous
>quarter. These students were then entered into the
>same database(the database containing Batch1).  Thus,
>the database during the 2nd quarter contained the
>Batch1 and Batch2. However, there is no variable
>showing that the student is from Batch1 or Batch2.
>
>4. The same thing was done in the succeeding quarters
>until school year 2007-2008.  Thus, batch 1 appeared
>in the database every quarter from 2003 to 2008.
>
>The goal is to add another variable in the database
>such that the variable is 1 if the student is from
>batch 1; and 0 otherwise.
>
>I would appreciate if someone could provide the
>syntax.
>
>Thank you.
>
>Johnny
>
>
>
>
>
>
>____________________________________________________________________________________
>You rock. That's why Blockbuster's offering you one month of
>Blockbuster Total Access, No Cost.
>http://tc.deals.yahoo.com/tc/blockbuster/text5.com
>
>=====================
>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
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG.
>Version: 7.5.519 / Virus Database: 269.22.11/1371 - Release Date:
>4/10/2008 12:23 PM

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