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