Data have; input ID$ PARAMCD$ RESULT BASERSLT CRITFL$; datelines; 004 ALT 0.03 0.03 004 ALT 0.06 0.03 004 AST 0.03 0.03 004 CHOL 0.03 0.03 004 4HCHOL 0.03 0.03 004 ALT 0.12 0.03 Y 004 LIPA 0.09 0.09 005 ALT 0.03 0.03 005 AST 0.06 0.04 005 CHOL 0.03 0.03 005 4HCHOL 0.03 0.03 005 ALT 0.06 0.03 N 005 LIPA 0.12 0.12 ; Data want; input ID$ PARAMCD$ RESULT BASERSLT CRITFL$; datelines; 004 ALT 0.03 0.03 Y 004 ALT 0.06 0.03 Y 004 AST 0.03 0.03 Y 004 CHOL 0.03 0.03 Y 004 4HCHOL 0.03 0.03 Y 004 ALT 0.12 0.03 Y 004 LIPA 0.09 0.09 Y 005 ALT 0.03 0.03 N 005 AST 0.06 0.04 N 005 CHOL 0.03 0.03 N 005 4HCHOL 0.03 0.03 N 005 ALT 0.06 0.03 N 005 LIPA 0.12 0.12 N; 1.CRITFL for the ID will have either "Y" or "N" and not a combination and hence if at least one record of ID has a "Y" or "N" or even "" i want to see that being retained to all the other records of the ID. Hope this is a bit helpful and apologies for the attachments. Thanks ... View more

ok this is how i want the data to be finally if that helps: YELLOW HIGHLIGHTED: CRITFL-Y FOR ALL THE RECORDS OF THE ID AS THE ID 004 HAS ATLEAST ONE ALT PSTBSFL RECORD WITH RESULT>=4*BASERSLT GREEN HIGHLIGHTED: CRITFL-N FOR ALL THE RECORDS OF ID 005 AS THERE IS NO PSTBSFL ALT RECORD WITH RESULT>=4*BASERSLT PEACH HIGHLIGHTED: CRITFL-. FOR ALL THE RECORDS OF THE ID 006 AS THERE ARE NO PSTBSFL ALT RECORDS AT ALL.   Thanks ... View more

@Ksharp thanks for your response and definitely its not populating Y,N OR NULL Values of an ID If the test is other than ALT. SO HERE MY AIM IS TO POPULATE THE CRITFL WITH 'Y' FOR ALL(BOTH ALT,AST) THE RECORDS OF THE ID IF ATLEAST ONE RECORD IS HAVING ALT PSTBSFL AND ITS RESULT>=4*BASERESULT AND NULL FOR CRITFL IF THE ID DOESNT HAVE ANY RECORD WITH ALT AND CRITFL AS "N" IF THE ID HAS A ALT POSTBSFL RECORD BUT THE RESULT^>=4*BASERESULT. ... View more

Data want; Input ID $ test$ visitnum basefl$ result$ adt randdt basec$ 1 CHOL 1 Y HIGH 17JUN2018 18JUN2018 HIGH 1 CHOL 1 Y LOW 17JUN2018 18JUN2018 HIGH 1 CHOL 1 Y HIGH 18JUN2018 18JUN2018 HIGH 1 CHOL 2 . LOW 24JUN2018 18JUN2018 HIGH; run; @ballardw  Thanks for your response and apologies for so many confusions.   Here below is what i meant regarding equally apart and the data is how you have shown in your answer and here above is the data look that i want finally.     when I meant equally apart i mean to say that when we calculate the difference between adt and randdt if we get the same value for any two records.   Logic that I want here is that: 1. If a ID is having 2 or more records with BASEFL eq ‘Y’ and are equally apart (difference between adt and randdt is same )from randdt then consider worst case (HIGH) as BASEC and retain the value across the ID. 2. If a ID is having 2 or more records with BASEFL eq ‘Y’ and are not equally apart from RANDDT then choose the BASEC from the closest record to RANDDT and retain its value across the ID.   TIA again ... View more

@Ksharp thanks for your response.   here is what i want:   Data want; input $id visitn $test result baseresult $basefl $postbasefl $critfl; 1  1  ALT  12  3  . Y  Y 1  2  AST  3    1  .Y  Y 2  1  AST   3   1  Y .  . 2  2  AST   2   1 . Y . ; run; LOGIC: 1.FOR CRITfl eq "Y"-THE RECORDS FOR ID HAVE BOTH ALT AND AST TESTS AND THE CRITFL SHOULD BE FLAGGED "Y" FOR ALL THOSE RECORDS OF THE ID IF THE ID HAS ATLEAST ONE RECORD WITH POSTBASEFL AS "Y" AND RESULT>=4*BASERESULT. 2. FOR CRITFL EQ "N" -FOR ID 1 IT SHOULD BE FLAGGED "N" if there is no record at all where postbasefl eq "Y"  and result>=4*baseresult.. 3.FOR CRITFL eq ""- IF THE ID DOESNT HAVE ANY POSTBASEFL EQ "Y" RECORD FOR THE TEST ALT THEN THE ID SHOULD HAVE CRITFL "". HERE IS THE FLOWCHART IN CASE IF THE LOGIC IS STILL NOT CLEAR   Your Response is much appreciated.   TIA   ... View more

@Ksharp    Thanks for your response again.   Data want; input id visitn test result baseresult basefl postbasefl critfl; 1  1  ALT  12  3  . Y Y 1  2  AST  3    1  .Y  Y 2  1  AST   3   1  Y .  . 2  2  AST   2   1 . Y . ; run; For the ID 2 as we dont see any ALT at all that satisfies the predefined criteria result>=4*baseresult i want to see CRITFL as missing for the ID throughout.   PREDEFINED CRITERION: If any postbasefl result of an ID with ALT Is ge 4*baseresult then flag all the records for that ID or if postbasefl for the ID for ALT is missing then leave a null value in CRITFL.   the above response has populated "X' for CRITFL when none of the pstblfl records has result>=4*baseresult but whereas we need to see "N",please have a look the want dataset above .   Thanks   ... View more

these are my conditions to flag the CRITFL. SO THE CRITFL SHOULD BE "Y" if there is any postbasefl record for the ID with ALT Result>=4*baseresult. 2.CRITFL should be "N" if there is no postbasefl record for the ID with ALT result NOT ge baseresult. 3.CRITFl should be "" (missing) if the ID Doesnt have any postbasefl record for the ALT test even if it has AST test. ... View more

@Ksharp thanks for your response the response is not giving NULL values for the ID If the ID Doesnt have any postbaseresult record for ALT.   Thanks alot     ... View more

SO THE CRITFL SHOULD BE "Y" if there is any postbasefl record for the ID with ALT Result>=4*baseresult. 2.CRITFL should be "N" if there is no postbasefl record for the ID with ALT result NOT ge baseresult. 3.CRITFl should be "" (missing) if the ID Doesnt have any postbasefl record for the ALT test even if it has AST test. The above response made the values NULL When the CRITFL should be "N". Thanks once again for your prompt response. ... View more

Data have; input id visitn test result baseresult basefl postbasefl; 1  1  ALT  12  3  . Y 1  2  AST  3    1  .Y 2  1  AST   3   1  Y . ; run;   Data want; input id visitn test result baseresult basefl postbasefl critfl; 1  1  ALT  12  3  . Y Y 1  2  AST  3    1  .Y  Y 2  1  AST   3   1  Y .  . ; run; For the ID 2 as we dont see any ALT at all that satisfies the predefined criteria result>=4*baseresult i want to see CRITFL as missing for the ID throughout.   PREDEFINED CRITERION: If any postbasefl result of an ID with ALT Is ge 4*baseresult then flag all the records for that ID or if postbasefl for the ID for ALT is missing then leave a null value in CRITFL.   Hopefully I am a bit clear now   THANKS ALOT     ... View more

Thank you so much for the earlier response , just to add one more detail to my question my criterion is based on one test i.e ALT and if that test is not available for a ID Then the critfl should be left blank and not as "N".   Thanks in advance.   Your response is appreciated. ... View more