Med dra

Reply
Contributor
Posts: 27

Med dra

Can someone explain the MedDra table . how the tables in dictionary is classified.The below hightlighted sort
SORT LOWER LEVEL TERM AND PREFERRED TERMS FOR MERGE WITH
**** SYSTEM ORGAN CLASS DATA.;has used variable soc_code for by variable  which was not merged before.I am not clear here.Can someone help me?




**** LOW_LEVEL_TERM = LOWEST LEVEL TERM, LLT_CODE = LOWEST

**** LEVEL TERM CODE, AND PT_CODE = PREFERRED TERM CODE.;

proc sort

      data = low_level_term(keep = low_level_term llt_code

                    pt_code);

            by pt_code;

run;

**** SORT PREFERRED TERM DATA FROM MEDDRA WHERE

**** PREFERRED_TERM = PREFERRED TERM, SOC_CODE = SYSTEM

**** ORGAN CLASS CODE, AND PT_CODE = PREFERRED TERM CODE.;

proc sort

      data = preferred_term(keep = preferred_term pt_code soc_code);

            bypt_code;

run;

**** MERGE LOW LEVEL TERMS WITH PREFERRED TERMS KEEPING ALL LOWER

**** LEVEL TERM RECORDS.;

data llt_pt;

      merge low_level_term (in = inlow)

                  preferred_term;

            by pt_code;

            if inlow;

run;

**** SORT BODY SYSTEM DATA FROM MEDDRA WHERE

**** SYSTEM_CLASS_TERM = SYSTEM ORGAN CLASS TERM AND SOC_CODE =

**** SYSTEM ORGAN CLASS CODE.;

proc sort

      data = soc_term(keep = system_class_term soc_code);

            by soc_code;

run;

**** SORT LOWER LEVEL TERM AND PREFERRED TERMS FOR MERGE WITH

**** SYSTEM ORGAN CLASS DATA.;

proc sort

      data = llt_pt;

            by soc_code;

run;

**** MERGE PREFERRED TERM LEVEL WITH BODY SYSTEMS;

data meddra;

      merge llt_pt (in = in_llt_pt)

                  soc_term;

            by soc_code;

            if in_llt_pt;

run;

Ask a Question
Discussion stats
  • 0 replies
  • 1826 views
  • 0 likes
  • 1 in conversation