« Return to Thread: creating new variables
Re: creating new variables
by Richard Ristow
::
Rate this Message:
At 04:36 AM 5/7/2009, abdelrhman elmubarak wrote:
|-----------------------------|---------------------------|
|Output Created |12-MAY-2009 00:39:31 |
|-----------------------------|---------------------------|
[Input]
id Repair_Date Repair_Type money
16 2009/04/30 115 $23.00
30 2009/03/25 209 $45.00
30 2009/01/24 103 $62.00
47 2009/04/09 209 $78.00
47 2009/04/09 101 $69.00
50 2009/05/01 117 $41.00
50 2009/05/01 209 $75.00
50 2009/05/01 105 $15.00
51 2009/05/15 110 $62.00
51 2009/05/15 209 $51.00
51 2009/05/15 103 $67.00
51 2009/05/15 209 $50.00
51 2009/05/15 111 $84.00
Number of cases read: 13 Number of cases listed: 13
|Output Created |12-MAY-2009 00:39:31 |
|-----------------------------|---------------------------|
[Desired]
id Repair_Date Repair_Type money more_jobs_plus more_money_plus
16 2009/04/30 115 $23.00 . .
30 2009/03/25 209 $45.00 0 .
30 2009/01/24 103 $62.00 . .
47 2009/04/09 209 $78.00 1 $69.00
47 2009/04/09 101 $69.00 . .
50 2009/05/01 117 $41.00 . .
50 2009/05/01 209 $75.00 2 $56.00
50 2009/05/01 105 $15.00 . .
51 2009/05/15 110 $62.00 3 $198.00
51 2009/05/15 209 $51.00 . .
51 2009/05/15 103 $67.00 . .
51 2009/05/15 209 $50.00 3 $198.00
51 2009/05/15 111 $84.00 . .
Number of cases read: 13 Number of cases listed: 13
At 11:02 AM 5/11/2009, Ariel Barak wrote:
Here's a variation. Like Ariel's, it's based on AGGREGATE. If there are multiple repairs of type 209 on the same day, it puts the same values of more_jobs_plus and more_money_plus on all type-209 lines: the number of all services not type 209, and total money from all such services.
IF Repair_Type NE 209 more_jobs_plus = 1.
IF Repair_type NE 209 more_money_plus = money.
AGGREGATE OUTFILE=* MODE=ADDVARIABLES OVERWRITE = YES
/BREAK = id Repair_Date
/more_jobs_plus 'Number of services not type 209' =
SUM(more_jobs_plus)
/more_money_plus 'Money from services not type 209' =
SUM(more_money_plus).
FORMATS more_jobs_plus (F3)
/more_money_plus (DOLLAR7.2).
IF Repair_Type NE 209 more_jobs_plus = $SYSMIS.
IF Repair_type NE 209 more_money_plus = $SYSMIS.
LIST.
List
|-----------------------------|---------------------------|
|Output Created |12-MAY-2009 00:39:32 |
|-----------------------------|---------------------------|
id Repair_Date Repair_Type money more_jobs_plus more_money_plus
16 2009/04/30 115 $23.00 . .
30 2009/03/25 209 $45.00 . .
30 2009/01/24 103 $62.00 . .
47 2009/04/09 209 $78.00 1 $69.00
47 2009/04/09 101 $69.00 . .
50 2009/05/01 117 $41.00 . .
50 2009/05/01 209 $75.00 2 $56.00
50 2009/05/01 105 $15.00 . .
51 2009/05/15 110 $62.00 . .
51 2009/05/15 209 $51.00 3 $213.00
51 2009/05/15 103 $67.00 . .
51 2009/05/15 209 $50.00 3 $213.00
51 2009/05/15 111 $84.00 . .
Number of cases read: 13 Number of cases listed: 13
=============================
APPENDIX: Test data, and code
=============================
DATA LIST LIST/
id Repair_Date Repair_Type money
(F3, F10, F3, F4).
BEGIN DATA
16 20090430 115 23
30 20090325 209 45
30 20090124 103 62
47 20090409 209 78
47 20090409 101 69
50 20090501 117 41
50 20090501 209 75
50 20090501 105 15
51 20090515 110 62
51 20090515 209 51
51 20090515 103 67
51 20090515 209 50
51 20090515 111 84
END DATA.
. /**/ LIST /*-*/.
* Convert Repair_Date to an SPSS date variable: .... .
COMPUTE #Day = MOD(Repair_Date,100).
COMPUTE #Month = MOD((Repair_Date-#Day)/100,100).
COMPUTE #Year = (Repair_Date-100*#Month-#Day)/1E4.
COMPUTE #SPSSdate = DATE.DMY(#Day,#Month,#Year).
FORMATS #Day #Month #Year (F4)
/#SPSSdate (SDATE10).
COMPUTE Repair_Date = #SPSSdate.
FORMATS Repair_Date (SDATE10).
FORMATS money (DOLLAR7.2).
DATASET NAME Input.
LIST.
DATA LIST LIST/
id Repair_Date Repair_Type money more_jobs_plus more_money_plus
(F3, F10, F3, F4, F3, F3).
BEGIN DATA
16 20090430 115 23
30 20090325 209 45 0
30 20090124 103 62
47 20090409 209 78 1 69
47 20090409 101 69
50 20090501 117 41
50 20090501 209 75 2 56
50 20090501 105 15
51 20090515 110 62 3 198
51 20090515 209 51
51 20090515 103 67
51 20090515 209 50 3 198
51 20090515 111 84
END DATA.
* Convert Repair_Date to an SPSS date variable: .... .
COMPUTE #Day = MOD(Repair_Date,100).
COMPUTE #Month = MOD((Repair_Date-#Day)/100,100).
COMPUTE #Year = (Repair_Date-100*#Month-#Day)/1E4.
COMPUTE #SPSSdate = DATE.DMY(#Day,#Month,#Year).
FORMATS #Day #Month #Year (F4)
/#SPSSdate (SDATE10).
COMPUTE Repair_Date = #SPSSdate.
FORMATS Repair_Date (SDATE10).
FORMATS money more_money_plus
(DOLLAR7.2).
DATASET NAME Desired.
LIST.
* .... Calculate the desired new variables .... .
NEW FILE.
ADD FILES
/FILE=Input.
* A. Compute the 'extra' cost individually for those services .... .
* that are *not* type 209. .... .
IF Repair_Type NE 209 more_jobs_plus = 1.
IF Repair_type NE 209 more_money_plus = money.
AGGREGATE OUTFILE=* MODE=ADDVARIABLES OVERWRITE = YES
/BREAK = id Repair_Date
/more_jobs_plus 'Number of services not type 209' =
SUM(more_jobs_plus)
/more_money_plus 'Money from services not type 209' =
SUM(more_money_plus).
FORMATS more_jobs_plus (F3)
/more_money_plus (DOLLAR7.2).
. /**/ LIST /*-*/.
IF Repair_Type NE 209 more_jobs_plus = $SYSMIS.
IF Repair_type NE 209 more_money_plus = $SYSMIS.
LIST.
====================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
my data looks as belowThe posted data, extended for this reply:
|-----------------------------|---------------------------|
|Output Created |12-MAY-2009 00:39:31 |
|-----------------------------|---------------------------|
[Input]
id Repair_Date Repair_Type money
16 2009/04/30 115 $23.00
30 2009/03/25 209 $45.00
30 2009/01/24 103 $62.00
47 2009/04/09 209 $78.00
47 2009/04/09 101 $69.00
50 2009/05/01 117 $41.00
50 2009/05/01 209 $75.00
50 2009/05/01 105 $15.00
51 2009/05/15 110 $62.00
51 2009/05/15 209 $51.00
51 2009/05/15 103 $67.00
51 2009/05/15 209 $50.00
51 2009/05/15 111 $84.00
Number of cases read: 13 Number of cases listed: 13
I want to create two more variables for those who did repair type 209Â…the purpose is to know did they did more jobs on the same day of their visit and what the money generated from that. At the final my data should look as below|-----------------------------|---------------------------|
|Output Created |12-MAY-2009 00:39:31 |
|-----------------------------|---------------------------|
[Desired]
id Repair_Date Repair_Type money more_jobs_plus more_money_plus
16 2009/04/30 115 $23.00 . .
30 2009/03/25 209 $45.00 0 .
30 2009/01/24 103 $62.00 . .
47 2009/04/09 209 $78.00 1 $69.00
47 2009/04/09 101 $69.00 . .
50 2009/05/01 117 $41.00 . .
50 2009/05/01 209 $75.00 2 $56.00
50 2009/05/01 105 $15.00 . .
51 2009/05/15 110 $62.00 3 $198.00
51 2009/05/15 209 $51.00 . .
51 2009/05/15 103 $67.00 . .
51 2009/05/15 209 $50.00 3 $198.00
51 2009/05/15 111 $84.00 . .
Number of cases read: 13 Number of cases listed: 13
At 11:02 AM 5/11/2009, Ariel Barak wrote:
The following syntax works with the data you posted and will take care of multiple repairs. If there are multiple repair types of 209 on a given day, the syntax would not work properly.
Here's a variation. Like Ariel's, it's based on AGGREGATE. If there are multiple repairs of type 209 on the same day, it puts the same values of more_jobs_plus and more_money_plus on all type-209 lines: the number of all services not type 209, and total money from all such services.
IF Repair_Type NE 209 more_jobs_plus = 1.
IF Repair_type NE 209 more_money_plus = money.
AGGREGATE OUTFILE=* MODE=ADDVARIABLES OVERWRITE = YES
/BREAK = id Repair_Date
/more_jobs_plus 'Number of services not type 209' =
SUM(more_jobs_plus)
/more_money_plus 'Money from services not type 209' =
SUM(more_money_plus).
FORMATS more_jobs_plus (F3)
/more_money_plus (DOLLAR7.2).
IF Repair_Type NE 209 more_jobs_plus = $SYSMIS.
IF Repair_type NE 209 more_money_plus = $SYSMIS.
LIST.
List
|-----------------------------|---------------------------|
|Output Created |12-MAY-2009 00:39:32 |
|-----------------------------|---------------------------|
id Repair_Date Repair_Type money more_jobs_plus more_money_plus
16 2009/04/30 115 $23.00 . .
30 2009/03/25 209 $45.00 . .
30 2009/01/24 103 $62.00 . .
47 2009/04/09 209 $78.00 1 $69.00
47 2009/04/09 101 $69.00 . .
50 2009/05/01 117 $41.00 . .
50 2009/05/01 209 $75.00 2 $56.00
50 2009/05/01 105 $15.00 . .
51 2009/05/15 110 $62.00 . .
51 2009/05/15 209 $51.00 3 $213.00
51 2009/05/15 103 $67.00 . .
51 2009/05/15 209 $50.00 3 $213.00
51 2009/05/15 111 $84.00 . .
Number of cases read: 13 Number of cases listed: 13
=============================
APPENDIX: Test data, and code
=============================
DATA LIST LIST/
id Repair_Date Repair_Type money
(F3, F10, F3, F4).
BEGIN DATA
16 20090430 115 23
30 20090325 209 45
30 20090124 103 62
47 20090409 209 78
47 20090409 101 69
50 20090501 117 41
50 20090501 209 75
50 20090501 105 15
51 20090515 110 62
51 20090515 209 51
51 20090515 103 67
51 20090515 209 50
51 20090515 111 84
END DATA.
. /**/ LIST /*-*/.
* Convert Repair_Date to an SPSS date variable: .... .
COMPUTE #Day = MOD(Repair_Date,100).
COMPUTE #Month = MOD((Repair_Date-#Day)/100,100).
COMPUTE #Year = (Repair_Date-100*#Month-#Day)/1E4.
COMPUTE #SPSSdate = DATE.DMY(#Day,#Month,#Year).
FORMATS #Day #Month #Year (F4)
/#SPSSdate (SDATE10).
COMPUTE Repair_Date = #SPSSdate.
FORMATS Repair_Date (SDATE10).
FORMATS money (DOLLAR7.2).
DATASET NAME Input.
LIST.
DATA LIST LIST/
id Repair_Date Repair_Type money more_jobs_plus more_money_plus
(F3, F10, F3, F4, F3, F3).
BEGIN DATA
16 20090430 115 23
30 20090325 209 45 0
30 20090124 103 62
47 20090409 209 78 1 69
47 20090409 101 69
50 20090501 117 41
50 20090501 209 75 2 56
50 20090501 105 15
51 20090515 110 62 3 198
51 20090515 209 51
51 20090515 103 67
51 20090515 209 50 3 198
51 20090515 111 84
END DATA.
* Convert Repair_Date to an SPSS date variable: .... .
COMPUTE #Day = MOD(Repair_Date,100).
COMPUTE #Month = MOD((Repair_Date-#Day)/100,100).
COMPUTE #Year = (Repair_Date-100*#Month-#Day)/1E4.
COMPUTE #SPSSdate = DATE.DMY(#Day,#Month,#Year).
FORMATS #Day #Month #Year (F4)
/#SPSSdate (SDATE10).
COMPUTE Repair_Date = #SPSSdate.
FORMATS Repair_Date (SDATE10).
FORMATS money more_money_plus
(DOLLAR7.2).
DATASET NAME Desired.
LIST.
* .... Calculate the desired new variables .... .
NEW FILE.
ADD FILES
/FILE=Input.
* A. Compute the 'extra' cost individually for those services .... .
* that are *not* type 209. .... .
IF Repair_Type NE 209 more_jobs_plus = 1.
IF Repair_type NE 209 more_money_plus = money.
AGGREGATE OUTFILE=* MODE=ADDVARIABLES OVERWRITE = YES
/BREAK = id Repair_Date
/more_jobs_plus 'Number of services not type 209' =
SUM(more_jobs_plus)
/more_money_plus 'Money from services not type 209' =
SUM(more_money_plus).
FORMATS more_jobs_plus (F3)
/more_money_plus (DOLLAR7.2).
. /**/ LIST /*-*/.
IF Repair_Type NE 209 more_jobs_plus = $SYSMIS.
IF Repair_type NE 209 more_money_plus = $SYSMIS.
LIST.
====================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
« Return to Thread: creating new variables
| Free embeddable forum powered by Nabble | Forum Help |
