Oh, haha -- sorry for the vagueness:

I was expecting to get the comparison to work. I also didn't mention that the dataset is much larger; I just wanted to give the first few rows. 

So, basically, I have a bunch of times in three columns, and I'm looking to compare them in which the command works correctly. 

Let's say, using the example below, that I want to get:

>> match2 = subset(match2, AEONTIME < INFTIME.x)

Well, with that exact syntax, it's not working because I'm getting back a dataset in which some AEONTIMEs are actually > INFTIME.x.

So, I feel like I'm just missing a piece of the syntax (i.e. as.date, as.character, but what works for time?)

I hope this helps. :-)

Thanks!


On Feb 26, 2012, at 9:32 PM, David Winsemius wrote:

> 
> On Feb 26, 2012, at 10:31 PM, Edgar Alminar wrote:
> 
>> Hello All,
>> I have this dataset:
>> 
>>   RID VISCODE      SCRNO RECNO AEWHEN   AEONDATE AEONTIME INFPOINT.x  INFDATE.x INFTIME.x INFPOINT.y  INFDATE.y INFTIME.y
>> 1   100     w00 IGI1480069     4      2 09/15/2009     1118          1 09/15/2009       947         14         -4      1117
>> 2   100     w00 IGI1480069     8      2 09/15/2009     1132          1 09/15/2009       947         14         -4      1117
>> 3   100     w00 IGI1480069     5      2 09/15/2009     1125          1 09/15/2009       947         14         -4      1117
>> 
>> 
>> 
>> I have AEONTIME, INFTIME.x, and INFTIME.y, and they are all military times.
>> I'm trying to do a comparison like this:
>> 
>> match2 = subset(match2, AEONTIME < INFTIME.x)
>> 
>> But it's not working correctly.
> 
> Define what you expected. In the sample you offered none of those logical comparisons would be true so you should get a dataframe with zero rows. (And since you gave the result the same name, you have basically wiped out match2.)
> 
> 
>> How do I do this? :-)
> 
> Do what?
> 
> -- 
> 
> David Winsemius, MD
> Heritage Laboratories
> West Hartford, CT
> 

Edgar Alminar
Clinical Operations
Alzheimer's Disease Cooperative Study
University of California, San Diego
9500 Gilman Drive, MC-0949
La Jolla, CA 92093-0949
Tel: (858) 622-8798
Fax: (858) 622-5876
Email: eaalminar@ucsd.edu

Confidentiality Notice- This e-mail message from the Alz...{{dropped:11}}

