I wanted to know if the CENT_TM10 is greater than (COLL_TM1 + 15 minutes) Data EC02;Set Ec01; if cent_tm10 > coll_tm1 + 15 ; Run; I get all the records in EC01 again into EC02.. Any help.. Bob
... View more
Tom - Thanks on your promp reply. I want the output into a dataset as I need to merge later. I think the same WHERE statment in PROC SQL can get me into a dataset. But wondering if there is an approch in Datastep that does that for me. Bob
... View more
Hi All- Wondering how to code the following scenario in SAS. Ideally all the rows in the table should pass the below criteria for the 3 dates. COLL_DT < REC_DT < RESULT_DT. I now want to create a list of ppl on whom the above criteria is not met. BOB
... View more
First, Visit and Var1 are coded only numeric. NO DESCRIPTION. Second, Per subjid- for every occurance of Visit=10 and var1=25 there should be a corresponding Visit=30 row and for every occurance of Visit=20 and var1=25 there should be a corresponding Visit=40 row present in the database table. If this above criteria is missing I want to know.
... View more
I have a scenario where I need to pick subject who doesn't have a corresponding repeat visit for occurance of an UNSATISFACTORY in Var1. Here in the above example subject 100 has a unsatisfactory for Year 1 visit so he comes in for a repeat visit Year 1 Repeat. But I need to find out subjects who doesn't make it to that repeat visit. I made up a Year 2 Repeat visit as greyed out here as expected record but right now missing in the database table. I can split this dataset into different datasets and somehow find out the missing repeat visit for a UNSATISFACTORY Visit but I would like to know if there is any other efficient way of find this out. Regards Bob
... View more