Prev: A Data manipulation question - Confusing to me (Running out of
Next: long to wide
From: "Fowler, Ann" on 3 Mar 2010 13:50
Hi All,

=


I have a dataset with several thousand records and the first 3
variables. The only information I can send to a lab is the barcode.
However, I still need to tie the barcodes to each individual and each
collection date. Therefore, I hope to create 2 new variables as shown
in the last 2 columns.

=


Barcode ptid colldate subjid coll

123-123 111 1/10/2009 1 1

123-124 111 1/10/2009 1 1

123-125 111 2/15/2009 1 2

123-126 111 2/15/2009 1 2

123-127 123 1/12/2009 2 1

123-128 123 1/12/2009 2 1

123-129 123 3/10/2009 2 2

123-130 123 3/10/2009 2 2

123-131 123 3/10/2009 2 2

123-132 444 1/10/2009 3 1

123-133 444 1/10/2009 3 1

123-134 444 1/10/2009 3 1

.........

.........

=


Can anyone help me create the last two variables.?

=


Thanks.

Ann =


=


Ann Fowler

Clinical Data Coordinator III

Cystic Fibrosis Therapeutics Development Network

Coordinating Center

Seattle Children's Research Institute

1100 Olive Way, Suite 500

Seattle, WA 98101

email:ann.fowler(a)seattlechildrens.org

=




CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is=
for the sole use of the intended recipient(s) and may contain confidential=
and privileged information protected by law. Any unauthorized review, use=
, disclosure or distribution is prohibited. If you are not the intended re=
cipient, please contact the sender by reply e-mail and destroy all copies o=
f the original message.
 | 
Pages: 1
Prev: A Data manipulation question - Confusing to me (Running out of
Next: long to wide