Hi,  I have a scenario where we have SCREENING, VISIT1, VISIT2 and so on.  VISIT1  gets Drug A , while VISIT2 gets DrugA+DrugB and Drug B is the actual study drug. Certain labs are done at SCREENING, VISIT1, VISIT2. should we consider RFSTDTC date as VISIT2 date. If yes, then all the VISIT1 study days will be negative. If we consider RFSTDTC as VISIT1 date but then IG says RFSTDTC should be "study drug". Any thoughts on what visit date should be mapped to RFSTDTC.   ... View more

data fakedata; input id var rslt; datalines; 101 1 . 101 2 0 101 3 . 101 4 1 101 5 1 101 6 0 101 7 1 101 8 0 101 9 0 101 10 0 102 1 . 102 2 0 102 3 0 102 4 1 102 5 1 102 6 1 102 7 0 102 8 0 102 9 0 102 10 0 ; run;   i want to count two consecutive 1's and flag that var and then three consecutive 0s and then flag the top record . so lets say we create 2 new variables flag_1 and flag_0 so for id=101 we will have flag_1=4 and flag_0=7 id=102 we will have flag_1=4 and flag_0=6 once thats flagged i need to count the missing rslt before flag_1 was identified meaning for id=101 we identified flag_1=4 , so before var=4 we have 2 missing records so i need another variable flag_miss_count=2 for id=101 flag_miss_count=1 any help appreciated.   the resulting data should be like  id var rslt flag_1 flag_0 flag_miss_count 101 1 . 101 2 0 101 3 .                                       2 101 4 1       4 101 5 1 101 6 0 101 7 1 101 8 0                    7 101 9 0 101 10 0 102 1 .                                      1 102 2 0 102 3 0 102 4 1   4 102 5 1 102 6 1 102 7 0                  6 102 8 0 102 9 0 102 10 0   thanks, eric ... View more

Hi, I have a dataset and i need to compare 4 records against lab date and output the earliest rslt where cdx is less than lbdt. Any suggestions? data a; input subject $ labdt $ cd1 $ cd2 $ cd3 $ cd4 $ rslt; cards; 101 15JUN15 17JUN15 18JUN15 29JUN15 31AUG15 22 101 20JUN15 17JUN15 18JUN15 29JUN15 31AUG15 23 101 01AUG15 17JUN15 18JUN15 29JUN15 31AUG15 45 102 19JUN15 17JUN15 28JUN15 29JUN15 30SEP15 44 102 28JUN15 17JUN15 28JUN15 29JUN15 30SEP15 47 ; run; I need the result as subject date            rslt  101     17JUN2015  22 101     18JUN2015  22 101     29JUN2015  23 101     31AUG2015  23   records 3 and 4 are 23 as the earliest rslt less than cd3, cd4 date compared to labdate is 23.   Thx ... View more