creating new variables

  

Hi

my data looks as below

 

id	Repair Date	Repair Type	money
16	20090430	115	23
30	20090325	209	45
30	20090124	103	62
47	20090409	209	78
47	20090409	101	69

 

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 be look as below

 

id	Repair Date	Repair Type	money	more jobs plus	more money plus
16	20090430	115	23
30	20090325	209	45	0
30	20090124	103	62
47	20090409	209	78	1	69
47	20090409	101	69

 

I can explain more if it is required

Thanks in advance

 

Abdulrahman

 

---

Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! Try it!

---

Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! Try it!