Date: Thu, 13 Nov 2008 13:58:16 +0100
Reply-To: Spousta Jan <JSpousta@CSAS.CZ>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Spousta Jan <JSpousta@CSAS.CZ>
Subject: Re: Help with copying unique status by multiple ID's
In-Reply-To: A<D4B81CAA05FBDC49BBD77A394CC30D57F36C0F@mailserver.pccc.cc.nj.us>
Content-Type: text/plain; charset="iso-8859-2"
Hi Gurvinder,
* recode the f/p status into 1/0 numbers
* use aggregate procedure (Data -> Aggregate...) by ID (seeking of the full-time status corresponds to seeking a maximum in the logic of aggregate)
* recode back if needed
Aggregate can be probably used also for computing of the sums.
HTH
Jan
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Khaneja, Gurvinder
Sent: Thursday, November 13, 2008 1:49 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Help with copying unique status by multiple ID's
Hi all
I need your help to resolve this problem. I have a term based file with status of full- or part-time (f or p) for each semester. I need to categorize a case as full-time, if the case is enrolled as full-time in any of the terms. I was able to create a unique_status using a sort and unduplicated logic. For example, case #2 occus three times for three consecutive semsters, and the case was full-time twice and part-time once, therefore the case is considered full-time for its unique status. However, the unique_status is associated with the case as it occurs for the first time for a term , and the unique_status is missing for the same case if it occurs for multiple terms. Is there a way to fill the missing field for each id with it's unique value.
Although I think I am pretty close to the solution I think I am missing some logic to calculate the total amount by id by unique_status. Here is what the data set looks like:
ID term Status unique_status Amount
1 fall07 f f 10
2 fall 07 f f 20
2 spring08 f . 30
2 summer 08 p . 10
3 fall 07 p p 20
3 winter 07 p . 40
3 spring08 p . 20
3 summer08 p . 10
4 fall07 f f 50
4 spring08 p . 20
5 summer07 p p 10
5 fall07 p . 30
5 spring08 p . 20
If I get the misiing data in place, I can calculate the total amount for each case by unique status,i.e.,
Total Amount for all full-time students (sum for cases 1, 2 and 4) = 10+20+30+10+50+20 = 140.
Although case 2 and 4 have part-time status in some semesters.
Total Amount for all partime students (sum for case 3 and 5) = 20+40+20+10+10+30+20 = 150.
I appreciate any suggestions to resolve the last piece of the puzzle. My apologies if you are seeing the posting again.
Many Thanks
G. Khaneja
=====================
To manage your subscription to SPSSX-L, send a message to LISTSERV@LISTSERV.UGA.EDU (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
_____________
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.
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.
Are you sure that you really need a print version of this message and/or its attachments? Think about nature.
-.- --
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (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
