I have attached a text file and out should contain  ftwo more records for every subject, with visit as d-AA p-AA for d-aa row c1,c2,mc1,mc2 shoudl be populateda s c1 should be Y if any of result value of all dvisits  is less than 40 c2- should be Y if all result value of dvisits are greater than 40 mc1-if any of result is missing for d visits then mc1 should be Y mc2-if all results are missing for d visits then mc2 should be Y   same for p -aa row also   for paa row c1,c2,mc1,mc2 shoudl be populateda s c1 should be Y if any of result value of all ovisits  is less than 40 c2- should be Y if all result value of pvisits are greater than 40 mc1-if any of result is missing for pvisits then mc1 should be Y mc2-if all results are missing for pvisits then mc2 should be Y   so output should contain 2 records more per subject ... View more

i couldnt understand your logic ... View more

yes i do have multiple id,i just quoted a piece of data as i cant represent all data here.Assume that there are multiple subjects and multiplle tst values like EST and PGT and TGT . ... View more

Yes i want it in a dataset ... View more

subject   visit  result   tst     c1     c2    mc1  mc2 101         d1    20      EST    -       -        -        - 101         d2    30      EST    -      -        -         - 101         d3    40      EST    -      -        -         - 101         d4    50      EST    -      -        -         - 101         P1    40      EST    -      -        -         - 101         P2    50      EST    -      -        -         - 101         P3    60      EST    -      -        -         - 101         P4    70      EST    -      -        -         - 101         d-a     -        Z       -      Y      Y        - 101         p-a    -          Z      Y     -       -         Y             ... View more

hey thank you so much it worked.But still i didnt understood the trick of two loops .please explain.Thanks ... View more

please make a correction  -->fourth record from last should contain 44 as base value instead of 120 ... View more

@Reeza Hey nothing like that what you felt is true in my case.I know that it is collected as a part of demographics to check whether drug had different pk profile or therapeutic effect in different Races.But i dont have any personal intention in discrimination or etc .I just started learning sdtm mapping and whatever data is given to me i am working on it and personally i feel that every one is human .I am belong from which is mixed diversified culture and so you can believe that i am not a Racist. ... View more

@Patrick Hey there is nothing related to discrimination or categorization.It is just a dummy data related to clinical trials. ... View more