Hi All,   I have 2 datasets In the below dataset for a subject the visit start date and end date has been provided. patient visit_start   visit_end     start_date         end_date 1001        SCR              WEEK0   01JAN2024       06JAN2024 In another dataset we have a set of dates recorded for the same subject. patient      date  1001       31dec2023 1001       01jan2024 1001      01jan2024 1001      04jan2024 1001      05jan2024 1001      05jan2024   The dates in the second table provided should be checked with the date range (start_date end_date) provided in first table and the dates which are not in range should be flagged and the missing calendar dates for the given range should be displayed.   Output: date range 01 jan2024 06jan2024 patient visit_start   visit_end     start_date         end_date       date                out_of_range         Missing_calendar days 1001        SCR              WEEK0   01JAN2024      06JAN2024  31dec2023         Y                             02JAN2024, 03JAN2024 1001        SCR              WEEK0   01JAN2024      06JAN2024 01jan2024 1001        SCR              WEEK0   01JAN2024      06JAN2024 01jan2024          1001        SCR              WEEK0   01JAN2024      06JAN2024 04jan2024 1001        SCR              WEEK0   01JAN2024      06JAN2024 07jan2024          Y 1001        SCR              WEEK0   01JAN2024      06JAN2024 08jan2024          Y    So the above output should be applied for all the subjects in the dataset and also for all the other visit_start and visit_end date ranges as well.   Your help will be very much appreciated.       ... View more

Hi All,   I have the below logic and confused on how to include 'AND 'and 'OR' within same if statement.    If ((HAT = 'Yes' Or SAT = 'Yes' Or TBP = 'Yes') Or (TBI = 'Yes' And REC = 'Yes') Or COT = Yes) And RESULT = 'Pos' And Does not satisfy (CAT = 'XCL' and TEST = 27) then output   The above variables with given values should satisfy so that i get the desired output from the given raw data.   Any help with how to write the program to satisfy the logic? ... View more

Hi All,   I have data as below: USUBJID $ AMT EXSTDTC $; 101 100 12JUN2023 101 500 13JUN2023 101 100 11JUN2023 102 100 12JUN2023 102 500 13JUN2023 102 100 11JUN2023 102 100 12JUN2023 102 500 13JUN2023 103 100 11JUN2023   I need to sort the data based on dates within same usubjid group and take the last amt value from each group and assign the value to new variable. My output should be as below USUBJID $ AMT EXSTDTC $  NEW_VAR 101 100 11JUN2023  500 101 100 12JUN2023 500 101 500 13JUN2023 500 102 100 11JUN2023  500 102 100 12JUN2023  500 102 500 13JUN2023  500 103 100 11JUN2023 500 103 100 12JUN2023 500 103 500 13JUN2023 500   Please help ... View more

Hi All,   If I have the dte values as below:   12/JAN/2020 11/UNK/2020 UN/UNK/2020   How to replace UN with date value as provided for example (01) and UNK with month value as provided example JAN ?   Values in the output should be as below   12/DEC/2020 11/JAN/2020 01/JAN/2020   Please help ... View more

Dear All, I am working on a blinded study which has 6 subjects and out of which 2 subjects are moved to open label because of disease remission. Now for populating the arm/armcd actarm/actarmcd what all should be considered to change arm/armcd actarm/actarmcd from blank to study arm ? Please be informed it's a rave database. Can anyone throw some light on it so that I'll proceed accordingly ... View more

Hi Team,   Request anyone to please kindly help with the below query.   I have a question where the data is as below:   TEST RESULT TIMEPOINT FU-ABC-1298 4.5 6 FU-ABC-1298 0 0 FU-ABC-1299 7.5 6 FU-ABC-1299 0 0 ABC-1298     ABC-1298     ABC-1298     ABC-1298     ABC-1299     ABC-1299     ABC-1299     ABC-1299       My output should look like below:     TEST RESULT TIMEPOINT FU-ABC-1298 4.5 6 FU-ABC-1298 0 0 FU-ABC-1299 7.5 6 FU-ABC-1299 0 0 ABC-1298 4.5   ABC-1298 4.5   ABC-1298 4.5   ABC-1298 4.5   ABC-1299 7.5   ABC-1299 7.5   ABC-1299 7.5   ABC-1299 7.5   ... View more