cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
alexdsa310
Obsidian | Level 7 alexdsa310
Obsidian | Level 7

Re: proc sql - help needed

Posted 04-24-2017 10:36 AM (530 views)  |   In reply to Kurt_Bremser

if i run the below code than i get 706 obs which are exactly in _values_. It means there is no common records in both which is not true.

and if i use the one below

proc sql;
create table sv1 as
select a.* from _values_ a left join _assignments_ b
on a.origin=b.origin and a.originwhere=b.originwhere
where b.origin is missing;
quit;

then i get 197obs.and if you see there is origin=""FRX_MEM-MD-10"n.D_EFF.OBSTYPE" and column="QNAM" and originwhere in sv1 and it is also present in _assignments which should nt be coming to sv1

0 Likes
Kurt_Bremser
Super User Kurt_Bremser
Super User

Re: proc sql - help needed

Posted 04-24-2017 10:43 AM (529 views)  |   In reply to alexdsa310
@alexdsa310 wrote:

if i run the below code than i get 706 obs which are exactly in _values_.

 

Then you obviously have other data. When I run the code, I get 230 observations. Please make sure that the data you run the code against is the data you posted here.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX
0 Likes
alexdsa310
Obsidian | Level 7 alexdsa310
Obsidian | Level 7

Re: proc sql - help needed

Posted 04-24-2017 11:16 AM (525 views)  |   In reply to Kurt_Bremser

i gave the same data. can you confirm if 

_assigments_ has 476 obs and

_values_ has 706 obs

cause ran it again after closing sas session and still get 706obs

0 Likes
Kurt_Bremser
Super User Kurt_Bremser
Super User

Re: proc sql - help needed

Posted 04-25-2017 02:04 AM (503 views)  |   In reply to alexdsa310

This is the code I run:

data WORK._ASSIGNMENTS_;
  infile datalines dsd truncover;
  input COLUMN:$32. VALUE:$32. ORIGIN:$1000. ORIGINWHERE:$1000.;
datalines4;
QNAM,ITTFL,"""FRX_MEM-MD-01""n.D_PROF.ITT",
QSTESTCD,MMS106B,"""FRX_MEM-MD-01""n.MMSE.MMSE1A",
QSTESTCD,MMS106A,"""FRX_MEM-MD-01""n.MMSE.MMSE1B",
QSTESTCD,MMS101,"""FRX_MEM-MD-01""n.MMSE.MMSEA1",
QSTESTCD,MMS101D,"""FRX_MEM-MD-01""n.MMSE.MMSEA1AD",
QSTESTCD,MMS101C,"""FRX_MEM-MD-01""n.MMSE.MMSEA1AM",
QSTESTCD,MMS101A,"""FRX_MEM-MD-01""n.MMSE.MMSEA1AY",
QSTESTCD,MMS101E,"""FRX_MEM-MD-01""n.MMSE.MMSEA1B",
QSTESTCD,MMS101B,"""FRX_MEM-MD-01""n.MMSE.MMSEA1C",
QSTESTCD,MMS102,"""FRX_MEM-MD-01""n.MMSE.MMSEA2",
QSTESTCD,MMS102A,"""FRX_MEM-MD-01""n.MMSE.MMSEA2A1",
QSTESTCD,MMS102C,"""FRX_MEM-MD-01""n.MMSE.MMSEA2A2",
QSTESTCD,MMS102F,"""FRX_MEM-MD-01""n.MMSE.MMSEA2A3",
QSTESTCD,MMS102D,"""FRX_MEM-MD-01""n.MMSE.MMSEA2A4",
QSTESTCD,MMS102E,"""FRX_MEM-MD-01""n.MMSE.MMSEA2A5",
QSTESTCD,MMS103,"""FRX_MEM-MD-01""n.MMSE.MMSEB",
QSTESTCD,MMS103A,"""FRX_MEM-MD-01""n.MMSE.MMSEB1",
QSTESTCD,MMS103C,"""FRX_MEM-MD-01""n.MMSE.MMSEB2",
QSTESTCD,MMS103B,"""FRX_MEM-MD-01""n.MMSE.MMSEB3",
QSTESTCD,MMS104,"""FRX_MEM-MD-01""n.MMSE.MMSEC",
QSTESTCD,MMS104A,"""FRX_MEM-MD-01""n.MMSE.MMSECH1",
QSTESTCD,MMS104B,"""FRX_MEM-MD-01""n.MMSE.MMSECH2",
QSTESTCD,MMS104C,"""FRX_MEM-MD-01""n.MMSE.MMSECH3",
QSTESTCD,MMS104D,"""FRX_MEM-MD-01""n.MMSE.MMSECH4",
QSTESTCD,MMS104E,"""FRX_MEM-MD-01""n.MMSE.MMSECH5",
QSTESTCD,MMS105,"""FRX_MEM-MD-01""n.MMSE.MMSED",
QSTESTCD,MMS105A,"""FRX_MEM-MD-01""n.MMSE.MMSED1",
QSTESTCD,MMS105C,"""FRX_MEM-MD-01""n.MMSE.MMSED2",
QSTESTCD,MMS105B,"""FRX_MEM-MD-01""n.MMSE.MMSED3",
QSTESTCD,MMS107,"""FRX_MEM-MD-01""n.MMSE.MMSEE2",
QSTESTCD,MMS108A,"""FRX_MEM-MD-01""n.MMSE.MMSEE3A",
QSTESTCD,MMS108B,"""FRX_MEM-MD-01""n.MMSE.MMSEE3B",
QSTESTCD,MMS108C,"""FRX_MEM-MD-01""n.MMSE.MMSEE3C",
QSTESTCD,MMS109,"""FRX_MEM-MD-01""n.MMSE.MMSEE4",
QSTESTCD,MMS110,"""FRX_MEM-MD-01""n.MMSE.MMSEE5",
QSTESTCD,MMS111,"""FRX_MEM-MD-01""n.MMSE.MMSEE6",
QSTESTCD,MMS1TOT,"""FRX_MEM-MD-01""n.MMSE.MMSETOT",
QNAM,ITTFL,"""FRX_MEM-MD-02""n.D_PROF.ITT",
QSTESTCD,MMS1TOT2,"""FRX_MEM-MD-02""n.D_PROF.MMSEBASE",
QSTESTCD,MMS1TOT1,"""FRX_MEM-MD-02""n.D_PROF.MMSESCRN",
QNAM,ITTFL,"""FRX_MEM-MD-03AB""n.D_PROF.ITT",
QNAM,ITTFL,"""FRX_MEM-MD-03C""n.D_PROF.ITT",
QNAM,DTYPE,"""FRX_MEM-MD-10""n.D_EFF.OBSTYPE",where 1<=param<=12
QNAM,ITTFL,"""FRX_MEM-MD-10""n.D_PROF.ITT",
QNAM,DTYPE,"""FRX_MEM-MD-11AB""n.D_EFF.OBSTYPE",where 1<=param<=12
QNAM,ITTFL,"""FRX_MEM-MD-11AB""n.D_PROF.ITT",
QNAM,DTYPE,"""FRX_MEM-MD-11C""n.D_EFF.OBSTYPE",where 1<=param<=12
QNAM,ITTFL,"""FRX_MEM-MD-11C""n.D_PROF.ITT",
QNAM,DTYPE,"""FRX_MEM-MD-12""n.D_EFF.OBSTYPE",where 1<=param<=12
QNAM,ITTFL,"""FRX_MEM-MD-12""n.D_PROF.ITT",
QNAM,DTYPE,"""FRX_MEM-MD-12A""n.D_EFF.OBSTYPE",where 1<=param<=12
QNAM,ITTFL,"""FRX_MEM-MD-12A""n.D_PROF.ITT",
QNAM,DTYPE,"""FRX_MEM-MD-12B""n.D_EFF.OBSTYPE",where 1<=param<=12
QNAM,ITTFL,"""FRX_MEM-MD-12B""n.D_PROF.ITT",
QNAM,DTYPE,"""FRX_MEM-MD-22""n.D_EFF.OBSTYPE",
QNAM,ITTFL,"""FRX_MEM-MD-22""n.D_PROF.ITT",
QSTESTCD,MMS101,"""FRX_MEM-MD-22""n.MMSE.MMSEA1",
QSTESTCD,MMS102,"""FRX_MEM-MD-22""n.MMSE.MMSEA2",
QSTESTCD,MMS103,"""FRX_MEM-MD-22""n.MMSE.MMSEB",
QSTESTCD,MMS104,"""FRX_MEM-MD-22""n.MMSE.MMSEC",
QSTESTCD,MMS105,"""FRX_MEM-MD-22""n.MMSE.MMSED",
QSTESTCD,MMS1TOT,"""FRX_MEM-MD-22""n.MMSE.MMSETOT",
QNAM,DTYPE,"""FRX_MEM-MD-50""n.D_EFF1.OBSTYPE",
QNAM,DTYPE,"""FRX_MEM-MD-50""n.D_EFF2.OBSTYPE",
QNAM,ITTFL,"""FRX_MEM-MD-50""n.D_PROF.ITT",
QSTESTCD,MMS1TOT2,"""FRX_MEM-MD-50""n.D_PROF.MMSEBASE",
QSTESTCD,MMS1TOT1,"""FRX_MEM-MD-50""n.D_PROF.MMSESCRN",
QNAM,FASFL,"""HLU_10112""n.CORE_PAT.POP_FULL",
QNAM,RANDFL,"""HLU_10112""n.CORE_PAT.POP_RAND",
QNAM,ITTFL,"""HLU_10112""n.CORE_PAT.POP_TREAT",
QSTESTCD,ADCOR,"""HLU_10112""n.EFF_ACOG.ACOG_6",
QSTESTCD,ADCDIF01,"""HLU_10112""n.EFF_ACOG.ADAS_10",
QSTESTCD,ADCRI01,"""HLU_10112""n.EFF_ACOG.ADAS_11",
QSTESTCD,ADCRLT01,"""HLU_10112""n.EFF_ACOG.ADAS_1_1",
QSTESTCD,ADCRLT02,"""HLU_10112""n.EFF_ACOG.ADAS_1_2",
QSTESTCD,ADCRLT03,"""HLU_10112""n.EFF_ACOG.ADAS_1_3",
QSTESTCD,ADCOF01,"""HLU_10112""n.EFF_ACOG.ADAS_2_1",
QSTESTCD,ADCOF02,"""HLU_10112""n.EFF_ACOG.ADAS_2_2",
QSTESTCD,ADCCMD01,"""HLU_10112""n.EFF_ACOG.ADAS_3_B",
QSTESTCD,ADCCMD02,"""HLU_10112""n.EFF_ACOG.ADAS_3_C",
QSTESTCD,ADCCMD03,"""HLU_10112""n.EFF_ACOG.ADAS_3_D",
QSTESTCD,ADCCMD04,"""HLU_10112""n.EFF_ACOG.ADAS_3_E",
QSTESTCD,ADCCMD05,"""HLU_10112""n.EFF_ACOG.ADAS_3_F",
QSTESTCD,ADCCP00B,"""HLU_10112""n.EFF_ACOG.ADAS_4_B",
QSTESTCD,ADCCP01,"""HLU_10112""n.EFF_ACOG.ADAS_4_C",
QSTESTCD,ADCCP02,"""HLU_10112""n.EFF_ACOG.ADAS_4_D",
QSTESTCD,ADCCP03,"""HLU_10112""n.EFF_ACOG.ADAS_4_E",
QSTESTCD,ADCCP04,"""HLU_10112""n.EFF_ACOG.ADAS_4_F",
QSTESTCD,ADCIP01,"""HLU_10112""n.EFF_ACOG.ADAS_5_B",
QSTESTCD,ADCIP02,"""HLU_10112""n.EFF_ACOG.ADAS_5_C",
QSTESTCD,ADCIP03,"""HLU_10112""n.EFF_ACOG.ADAS_5_D",
QSTESTCD,ADCIP04,"""HLU_10112""n.EFF_ACOG.ADAS_5_E",
QSTESTCD,ADCIP05,"""HLU_10112""n.EFF_ACOG.ADAS_5_F",
QSTESTCD,ADCOR01,"""HLU_10112""n.EFF_ACOG.ADAS_6_B",
QSTESTCD,ADCOR02,"""HLU_10112""n.EFF_ACOG.ADAS_6_C",
QSTESTCD,ADCOR03,"""HLU_10112""n.EFF_ACOG.ADAS_6_D",
QSTESTCD,ADCOR04,"""HLU_10112""n.EFF_ACOG.ADAS_6_E",
QSTESTCD,ADCOR05,"""HLU_10112""n.EFF_ACOG.ADAS_6_F",
QSTESTCD,ADCOR06,"""HLU_10112""n.EFF_ACOG.ADAS_6_G",
QSTESTCD,ADCOR07,"""HLU_10112""n.EFF_ACOG.ADAS_6_H",
QSTESTCD,ADCOR08,"""HLU_10112""n.EFF_ACOG.ADAS_6_I",
QSTESTCD,ADCRGT01,"""HLU_10112""n.EFF_ACOG.ADAS_7_1",
QSTESTCD,ADCRGT02,"""HLU_10112""n.EFF_ACOG.ADAS_7_2",
QSTESTCD,ADCRGT03,"""HLU_10112""n.EFF_ACOG.ADAS_7_3",
QSTESTCD,ADCSL01,"""HLU_10112""n.EFF_ACOG.ADAS_8",
QSTESTCD,ADCCMP01,"""HLU_10112""n.EFF_ACOG.ADAS_9",
QSTESTCD,MMS101,"""HLU_10112""n.EFF_MMSE.MMSE_A1",
QSTESTCD,MMS101C,"""HLU_10112""n.EFF_MMSE.MMSE_A1_1",
QSTESTCD,MMS101D,"""HLU_10112""n.EFF_MMSE.MMSE_A1_2",
QSTESTCD,MMS101A,"""HLU_10112""n.EFF_MMSE.MMSE_A1_3",
QSTESTCD,MMS101E,"""HLU_10112""n.EFF_MMSE.MMSE_A1_4",
QSTESTCD,MMS101B,"""HLU_10112""n.EFF_MMSE.MMSE_A1_5",
QSTESTCD,MMS102,"""HLU_10112""n.EFF_MMSE.MMSE_A2",
QSTESTCD,MMS102A,"""HLU_10112""n.EFF_MMSE.MMSE_A2_1",
QSTESTCD,MMS102C,"""HLU_10112""n.EFF_MMSE.MMSE_A2_2",
QSTESTCD,MMS102F,"""HLU_10112""n.EFF_MMSE.MMSE_A2_3",
QSTESTCD,MMS102D,"""HLU_10112""n.EFF_MMSE.MMSE_A2_4",
QSTESTCD,MMS102E,"""HLU_10112""n.EFF_MMSE.MMSE_A2_5",
QSTESTCD,MMS103,"""HLU_10112""n.EFF_MMSE.MMSE_B",
QSTESTCD,MMS103A,"""HLU_10112""n.EFF_MMSE.MMSE_B_1",
QSTESTCD,MMS103C,"""HLU_10112""n.EFF_MMSE.MMSE_B_2",
QSTESTCD,MMS103B,"""HLU_10112""n.EFF_MMSE.MMSE_B_3",
QSTESTCD,MMS104,"""HLU_10112""n.EFF_MMSE.MMSE_C",
QSTESTCD,MMS104A,"""HLU_10112""n.EFF_MMSE.MMSE_C_1",
QSTESTCD,MMS104B,"""HLU_10112""n.EFF_MMSE.MMSE_C_2",
QSTESTCD,MMS104C,"""HLU_10112""n.EFF_MMSE.MMSE_C_3",
QSTESTCD,MMS104D,"""HLU_10112""n.EFF_MMSE.MMSE_C_4",
QSTESTCD,MMS104E,"""HLU_10112""n.EFF_MMSE.MMSE_C_5",
QSTESTCD,MMS105,"""HLU_10112""n.EFF_MMSE.MMSE_D",
QSTESTCD,MMS105A,"""HLU_10112""n.EFF_MMSE.MMSE_D_1",
QSTESTCD,MMS105C,"""HLU_10112""n.EFF_MMSE.MMSE_D_2",
QSTESTCD,MMS105B,"""HLU_10112""n.EFF_MMSE.MMSE_D_3",
QSTESTCD,MMS106,"""HLU_10112""n.EFF_MMSE.MMSE_E1",
QSTESTCD,MMS106B,"""HLU_10112""n.EFF_MMSE.MMSE_E1_1",
QSTESTCD,MMS106A,"""HLU_10112""n.EFF_MMSE.MMSE_E1_2",
QSTESTCD,MMS107,"""HLU_10112""n.EFF_MMSE.MMSE_E2",
QSTESTCD,MMS108,"""HLU_10112""n.EFF_MMSE.MMSE_E3",
QSTESTCD,MMS108A,"""HLU_10112""n.EFF_MMSE.MMSE_E3_1",
QSTESTCD,MMS108B,"""HLU_10112""n.EFF_MMSE.MMSE_E3_2",
QSTESTCD,MMS108C,"""HLU_10112""n.EFF_MMSE.MMSE_E3_3",
QSTESTCD,MMS109,"""HLU_10112""n.EFF_MMSE.MMSE_E4",
QSTESTCD,MMS110,"""HLU_10112""n.EFF_MMSE.MMSE_E5",
QSTESTCD,MMS111,"""HLU_10112""n.EFF_MMSE.MMSE_E6",
QSTESTCD,MMS1TOT,"""HLU_10112""n.EFF_MMSE.MMSE_TOT",
QNAM,FASFL,"""HLU_10113""n.CORE_PAT.POP_FULL",
QNAM,RANDFL,"""HLU_10113""n.CORE_PAT.POP_RAND",
QNAM,ITTFL,"""HLU_10113""n.CORE_PAT.POP_TREAT",
QSTESTCD,MMS101,"""HLU_10113""n.EFF_MMSE.MMSE_A1",
QSTESTCD,MMS101C,"""HLU_10113""n.EFF_MMSE.MMSE_A1_1",
QSTESTCD,MMS101D,"""HLU_10113""n.EFF_MMSE.MMSE_A1_2",
QSTESTCD,MMS101A,"""HLU_10113""n.EFF_MMSE.MMSE_A1_3",
QSTESTCD,MMS101E,"""HLU_10113""n.EFF_MMSE.MMSE_A1_4",
QSTESTCD,MMS101B,"""HLU_10113""n.EFF_MMSE.MMSE_A1_5",
QSTESTCD,MMS102,"""HLU_10113""n.EFF_MMSE.MMSE_A2",
QSTESTCD,MMS102A,"""HLU_10113""n.EFF_MMSE.MMSE_A2_1",
QSTESTCD,MMS102C,"""HLU_10113""n.EFF_MMSE.MMSE_A2_2",
QSTESTCD,MMS102F,"""HLU_10113""n.EFF_MMSE.MMSE_A2_3",
QSTESTCD,MMS102D,"""HLU_10113""n.EFF_MMSE.MMSE_A2_4",
QSTESTCD,MMS102E,"""HLU_10113""n.EFF_MMSE.MMSE_A2_5",
QSTESTCD,MMS103,"""HLU_10113""n.EFF_MMSE.MMSE_B",
QSTESTCD,MMS103A,"""HLU_10113""n.EFF_MMSE.MMSE_B_1",
QSTESTCD,MMS103C,"""HLU_10113""n.EFF_MMSE.MMSE_B_2",
QSTESTCD,MMS103B,"""HLU_10113""n.EFF_MMSE.MMSE_B_3",
QSTESTCD,MMS104,"""HLU_10113""n.EFF_MMSE.MMSE_C",
QSTESTCD,MMS104A,"""HLU_10113""n.EFF_MMSE.MMSE_C_1",
QSTESTCD,MMS104B,"""HLU_10113""n.EFF_MMSE.MMSE_C_2",
QSTESTCD,MMS104C,"""HLU_10113""n.EFF_MMSE.MMSE_C_3",
QSTESTCD,MMS104D,"""HLU_10113""n.EFF_MMSE.MMSE_C_4",
QSTESTCD,MMS104E,"""HLU_10113""n.EFF_MMSE.MMSE_C_5",
QSTESTCD,MMS105,"""HLU_10113""n.EFF_MMSE.MMSE_D",
QSTESTCD,MMS105A,"""HLU_10113""n.EFF_MMSE.MMSE_D_1",
QSTESTCD,MMS105C,"""HLU_10113""n.EFF_MMSE.MMSE_D_2",
QSTESTCD,MMS105B,"""HLU_10113""n.EFF_MMSE.MMSE_D_3",
QSTESTCD,MMS106,"""HLU_10113""n.EFF_MMSE.MMSE_E1",
QSTESTCD,MMS106B,"""HLU_10113""n.EFF_MMSE.MMSE_E1_1",
QSTESTCD,MMS106A,"""HLU_10113""n.EFF_MMSE.MMSE_E1_2",
QSTESTCD,MMS107,"""HLU_10113""n.EFF_MMSE.MMSE_E2",
QSTESTCD,MMS108,"""HLU_10113""n.EFF_MMSE.MMSE_E3",
QSTESTCD,MMS108A,"""HLU_10113""n.EFF_MMSE.MMSE_E3_1",
QSTESTCD,MMS108B,"""HLU_10113""n.EFF_MMSE.MMSE_E3_2",
QSTESTCD,MMS108C,"""HLU_10113""n.EFF_MMSE.MMSE_E3_3",
QSTESTCD,MMS109,"""HLU_10113""n.EFF_MMSE.MMSE_E4",
QSTESTCD,MMS110,"""HLU_10113""n.EFF_MMSE.MMSE_E5",
QSTESTCD,MMS111,"""HLU_10113""n.EFF_MMSE.MMSE_E6",
QSTESTCD,MMS1TOT,"""HLU_10113""n.EFF_MMSE.MMSE_TOT",
QNAM,FASFL,"""HLU_10114""n.CORE_PAT.POP_FULL",
QNAM,RANDFL,"""HLU_10114""n.CORE_PAT.POP_RAND",
QNAM,ITTFL,"""HLU_10114""n.CORE_PAT.POP_TREAT",
QSTESTCD,MMS101,"""HLU_10114""n.EFF_MMSE.MMSE_A1",
QSTESTCD,MMS101C,"""HLU_10114""n.EFF_MMSE.MMSE_A1_1",
QSTESTCD,MMS101D,"""HLU_10114""n.EFF_MMSE.MMSE_A1_2",
QSTESTCD,MMS101A,"""HLU_10114""n.EFF_MMSE.MMSE_A1_3",
QSTESTCD,MMS101E,"""HLU_10114""n.EFF_MMSE.MMSE_A1_4",
QSTESTCD,MMS101B,"""HLU_10114""n.EFF_MMSE.MMSE_A1_5",
QSTESTCD,MMS102,"""HLU_10114""n.EFF_MMSE.MMSE_A2",
QSTESTCD,MMS102A,"""HLU_10114""n.EFF_MMSE.MMSE_A2_1",
QSTESTCD,MMS102C,"""HLU_10114""n.EFF_MMSE.MMSE_A2_2",
QSTESTCD,MMS102F,"""HLU_10114""n.EFF_MMSE.MMSE_A2_3",
QSTESTCD,MMS102D,"""HLU_10114""n.EFF_MMSE.MMSE_A2_4",
QSTESTCD,MMS102E,"""HLU_10114""n.EFF_MMSE.MMSE_A2_5",
QSTESTCD,MMS103,"""HLU_10114""n.EFF_MMSE.MMSE_B",
QSTESTCD,MMS103A,"""HLU_10114""n.EFF_MMSE.MMSE_B_1",
QSTESTCD,MMS103C,"""HLU_10114""n.EFF_MMSE.MMSE_B_2",
QSTESTCD,MMS103B,"""HLU_10114""n.EFF_MMSE.MMSE_B_3",
QSTESTCD,MMS104,"""HLU_10114""n.EFF_MMSE.MMSE_C",
QSTESTCD,MMS104A,"""HLU_10114""n.EFF_MMSE.MMSE_C_1",
QSTESTCD,MMS104B,"""HLU_10114""n.EFF_MMSE.MMSE_C_2",
QSTESTCD,MMS104C,"""HLU_10114""n.EFF_MMSE.MMSE_C_3",
QSTESTCD,MMS104D,"""HLU_10114""n.EFF_MMSE.MMSE_C_4",
QSTESTCD,MMS104E,"""HLU_10114""n.EFF_MMSE.MMSE_C_5",
QSTESTCD,MMS105,"""HLU_10114""n.EFF_MMSE.MMSE_D",
QSTESTCD,MMS105A,"""HLU_10114""n.EFF_MMSE.MMSE_D_1",
QSTESTCD,MMS105C,"""HLU_10114""n.EFF_MMSE.MMSE_D_2",
QSTESTCD,MMS105B,"""HLU_10114""n.EFF_MMSE.MMSE_D_3",
QSTESTCD,MMS106,"""HLU_10114""n.EFF_MMSE.MMSE_E1",
QSTESTCD,MMS106B,"""HLU_10114""n.EFF_MMSE.MMSE_E1_1",
QSTESTCD,MMS106A,"""HLU_10114""n.EFF_MMSE.MMSE_E1_2",
QSTESTCD,MMS107,"""HLU_10114""n.EFF_MMSE.MMSE_E2",
QSTESTCD,MMS108,"""HLU_10114""n.EFF_MMSE.MMSE_E3",
QSTESTCD,MMS108A,"""HLU_10114""n.EFF_MMSE.MMSE_E3_1",
QSTESTCD,MMS108B,"""HLU_10114""n.EFF_MMSE.MMSE_E3_2",
QSTESTCD,MMS108C,"""HLU_10114""n.EFF_MMSE.MMSE_E3_3",
QSTESTCD,MMS109,"""HLU_10114""n.EFF_MMSE.MMSE_E4",
QSTESTCD,MMS110,"""HLU_10114""n.EFF_MMSE.MMSE_E5",
QSTESTCD,MMS111,"""HLU_10114""n.EFF_MMSE.MMSE_E6",
QSTESTCD,MMS1TOT,"""HLU_10114""n.EFF_MMSE.MMSE_TOT",
QNAM,FASFL,"""HLU_10116""n.CORE_PAT.POP_FULL",
QNAM,RANDFL,"""HLU_10116""n.CORE_PAT.POP_RAND",
QNAM,ITTFL,"""HLU_10116""n.CORE_PAT.POP_TREAT",
QSTESTCD,MMS101,"""HLU_10116""n.EFF_MMSE.MMSE_A1",
QSTESTCD,MMS102,"""HLU_10116""n.EFF_MMSE.MMSE_A2",
QSTESTCD,MMS103,"""HLU_10116""n.EFF_MMSE.MMSE_B",
QSTESTCD,MMS104,"""HLU_10116""n.EFF_MMSE.MMSE_C",
QSTESTCD,MMS105,"""HLU_10116""n.EFF_MMSE.MMSE_D",
QSTESTCD,MMS106,"""HLU_10116""n.EFF_MMSE.MMSE_E1",
QSTESTCD,MMS107,"""HLU_10116""n.EFF_MMSE.MMSE_E2",
QSTESTCD,MMS108,"""HLU_10116""n.EFF_MMSE.MMSE_E3",
QSTESTCD,MMS109,"""HLU_10116""n.EFF_MMSE.MMSE_E4",
QSTESTCD,MMS110,"""HLU_10116""n.EFF_MMSE.MMSE_E5",
QSTESTCD,MMS111,"""HLU_10116""n.EFF_MMSE.MMSE_E6",
QSTESTCD,MMS1TOT,"""HLU_10116""n.EFF_MMSE.MMSE_TOT",
QNAM,FASFL,"""HLU_10158""n.CORE_PAT.POP_FULL",
QNAM,RANDFL,"""HLU_10158""n.CORE_PAT.POP_RAND",
QNAM,ITTFL,"""HLU_10158""n.CORE_PAT.POP_TREAT",
QSTESTCD,MMS101,"""HLU_10158""n.EFF_MMSE.MMSE_A1",
QSTESTCD,MMS101C,"""HLU_10158""n.EFF_MMSE.MMSE_A1_1",
QSTESTCD,MMS101D,"""HLU_10158""n.EFF_MMSE.MMSE_A1_2",
QSTESTCD,MMS101A,"""HLU_10158""n.EFF_MMSE.MMSE_A1_3",
QSTESTCD,MMS101E,"""HLU_10158""n.EFF_MMSE.MMSE_A1_4",
QSTESTCD,MMS101B,"""HLU_10158""n.EFF_MMSE.MMSE_A1_5",
QSTESTCD,MMS102,"""HLU_10158""n.EFF_MMSE.MMSE_A2",
QSTESTCD,MMS102A,"""HLU_10158""n.EFF_MMSE.MMSE_A2_1",
QSTESTCD,MMS102C,"""HLU_10158""n.EFF_MMSE.MMSE_A2_2",
QSTESTCD,MMS102F,"""HLU_10158""n.EFF_MMSE.MMSE_A2_3",
QSTESTCD,MMS102D,"""HLU_10158""n.EFF_MMSE.MMSE_A2_4",
QSTESTCD,MMS102E,"""HLU_10158""n.EFF_MMSE.MMSE_A2_5",
QSTESTCD,MMS103,"""HLU_10158""n.EFF_MMSE.MMSE_B",
QSTESTCD,MMS103A,"""HLU_10158""n.EFF_MMSE.MMSE_B_1",
QSTESTCD,MMS103C,"""HLU_10158""n.EFF_MMSE.MMSE_B_2",
QSTESTCD,MMS103B,"""HLU_10158""n.EFF_MMSE.MMSE_B_3",
QSTESTCD,MMS104,"""HLU_10158""n.EFF_MMSE.MMSE_C",
QSTESTCD,MMS104A,"""HLU_10158""n.EFF_MMSE.MMSE_C_1",
QSTESTCD,MMS104B,"""HLU_10158""n.EFF_MMSE.MMSE_C_2",
QSTESTCD,MMS104C,"""HLU_10158""n.EFF_MMSE.MMSE_C_3",
QSTESTCD,MMS104D,"""HLU_10158""n.EFF_MMSE.MMSE_C_4",
QSTESTCD,MMS104E,"""HLU_10158""n.EFF_MMSE.MMSE_C_5",
QSTESTCD,MMS105,"""HLU_10158""n.EFF_MMSE.MMSE_D",
QSTESTCD,MMS105A,"""HLU_10158""n.EFF_MMSE.MMSE_D_1",
QSTESTCD,MMS105C,"""HLU_10158""n.EFF_MMSE.MMSE_D_2",
QSTESTCD,MMS105B,"""HLU_10158""n.EFF_MMSE.MMSE_D_3",
QSTESTCD,MMS106,"""HLU_10158""n.EFF_MMSE.MMSE_E1",
QSTESTCD,MMS106B,"""HLU_10158""n.EFF_MMSE.MMSE_E1_1",
QSTESTCD,MMS106A,"""HLU_10158""n.EFF_MMSE.MMSE_E1_2",
QSTESTCD,MMS107,"""HLU_10158""n.EFF_MMSE.MMSE_E2",
QSTESTCD,MMS108,"""HLU_10158""n.EFF_MMSE.MMSE_E3",
QSTESTCD,MMS108A,"""HLU_10158""n.EFF_MMSE.MMSE_E3_1",
QSTESTCD,MMS108B,"""HLU_10158""n.EFF_MMSE.MMSE_E3_2",
QSTESTCD,MMS108C,"""HLU_10158""n.EFF_MMSE.MMSE_E3_3",
QSTESTCD,MMS109,"""HLU_10158""n.EFF_MMSE.MMSE_E4",
QSTESTCD,MMS110,"""HLU_10158""n.EFF_MMSE.MMSE_E5",
QSTESTCD,MMS111,"""HLU_10158""n.EFF_MMSE.MMSE_E6",
QSTESTCD,MMS1TOT,"""HLU_10158""n.EFF_MMSE.MMSE_TOT",
QNAM,ITTFL,"""HLU_10252""n.CORE_PAT.POP_TREAT",
QSTESTCD,MMS101,"""HLU_10252""n.EFF_MMSE.MMSE_A1",
QSTESTCD,MMS101C,"""HLU_10252""n.EFF_MMSE.MMSE_A1_1",
QSTESTCD,MMS101D,"""HLU_10252""n.EFF_MMSE.MMSE_A1_2",
QSTESTCD,MMS101A,"""HLU_10252""n.EFF_MMSE.MMSE_A1_3",
QSTESTCD,MMS101E,"""HLU_10252""n.EFF_MMSE.MMSE_A1_4",
QSTESTCD,MMS101B,"""HLU_10252""n.EFF_MMSE.MMSE_A1_5",
QSTESTCD,MMS102,"""HLU_10252""n.EFF_MMSE.MMSE_A2",
QSTESTCD,MMS102A,"""HLU_10252""n.EFF_MMSE.MMSE_A2_1",
QSTESTCD,MMS102C,"""HLU_10252""n.EFF_MMSE.MMSE_A2_2",
QSTESTCD,MMS102F,"""HLU_10252""n.EFF_MMSE.MMSE_A2_3",
QSTESTCD,MMS102D,"""HLU_10252""n.EFF_MMSE.MMSE_A2_4",
QSTESTCD,MMS102E,"""HLU_10252""n.EFF_MMSE.MMSE_A2_5",
QSTESTCD,MMS103,"""HLU_10252""n.EFF_MMSE.MMSE_B",
QSTESTCD,MMS103A,"""HLU_10252""n.EFF_MMSE.MMSE_B_1",
QSTESTCD,MMS103C,"""HLU_10252""n.EFF_MMSE.MMSE_B_2",
QSTESTCD,MMS103B,"""HLU_10252""n.EFF_MMSE.MMSE_B_3",
QSTESTCD,MMS104,"""HLU_10252""n.EFF_MMSE.MMSE_C",
QSTESTCD,MMS104A,"""HLU_10252""n.EFF_MMSE.MMSE_C_1",
QSTESTCD,MMS104B,"""HLU_10252""n.EFF_MMSE.MMSE_C_2",
QSTESTCD,MMS104C,"""HLU_10252""n.EFF_MMSE.MMSE_C_3",
QSTESTCD,MMS104D,"""HLU_10252""n.EFF_MMSE.MMSE_C_4",
QSTESTCD,MMS104E,"""HLU_10252""n.EFF_MMSE.MMSE_C_5",
QSTESTCD,MMS105,"""HLU_10252""n.EFF_MMSE.MMSE_D",
QSTESTCD,MMS105A,"""HLU_10252""n.EFF_MMSE.MMSE_D_1",
QSTESTCD,MMS105C,"""HLU_10252""n.EFF_MMSE.MMSE_D_2",
QSTESTCD,MMS105B,"""HLU_10252""n.EFF_MMSE.MMSE_D_3",
QSTESTCD,MMS106,"""HLU_10252""n.EFF_MMSE.MMSE_E1",
QSTESTCD,MMS106B,"""HLU_10252""n.EFF_MMSE.MMSE_E1_1",
QSTESTCD,MMS106A,"""HLU_10252""n.EFF_MMSE.MMSE_E1_2",
QSTESTCD,MMS107,"""HLU_10252""n.EFF_MMSE.MMSE_E2",
QSTESTCD,MMS108,"""HLU_10252""n.EFF_MMSE.MMSE_E3",
QSTESTCD,MMS108A,"""HLU_10252""n.EFF_MMSE.MMSE_E3_1",
QSTESTCD,MMS108B,"""HLU_10252""n.EFF_MMSE.MMSE_E3_2",
QSTESTCD,MMS108C,"""HLU_10252""n.EFF_MMSE.MMSE_E3_3",
QSTESTCD,MMS109,"""HLU_10252""n.EFF_MMSE.MMSE_E4",
QSTESTCD,MMS110,"""HLU_10252""n.EFF_MMSE.MMSE_E5",
QSTESTCD,MMS111,"""HLU_10252""n.EFF_MMSE.MMSE_E6",
QSTESTCD,MMS1TOT,"""HLU_10252""n.EFF_MMSE.MMSE_TOT",
QNAM,FASFL,"""HLU_99679""n.CORE_PAT.POP_FULL",
QNAM,RANDFL,"""HLU_99679""n.CORE_PAT.POP_RAND",
QNAM,ITTFL,"""HLU_99679""n.CORE_PAT.POP_TREAT",
QSTESTCD,ADCRL,"""HLU_99679""n.EFF_ACOG.ACOG_1",
QSTESTCD,ADCDIF,"""HLU_99679""n.EFF_ACOG.ACOG_10",
QSTESTCD,ADCRI,"""HLU_99679""n.EFF_ACOG.ACOG_11",
QSTESTCD,ADCOF,"""HLU_99679""n.EFF_ACOG.ACOG_2",
QSTESTCD,ADCCMD,"""HLU_99679""n.EFF_ACOG.ACOG_3",
QSTESTCD,ADCCP,"""HLU_99679""n.EFF_ACOG.ACOG_4",
QSTESTCD,ADCIP,"""HLU_99679""n.EFF_ACOG.ACOG_5",
QSTESTCD,ADCOR,"""HLU_99679""n.EFF_ACOG.ACOG_6",
QSTESTCD,ADCRG,"""HLU_99679""n.EFF_ACOG.ACOG_7",
QSTESTCD,ADCSL,"""HLU_99679""n.EFF_ACOG.ACOG_8",
QSTESTCD,ADCCMP,"""HLU_99679""n.EFF_ACOG.ACOG_9",
QSTESTCD,ADASTOT,"""HLU_99679""n.EFF_ACOG.ACOG_TOT",
QSTESTCD,MMS101,"""HLU_99679""n.EFF_MMSE.MMSE_A1",
QSTESTCD,MMS102,"""HLU_99679""n.EFF_MMSE.MMSE_A2",
QSTESTCD,MMS103,"""HLU_99679""n.EFF_MMSE.MMSE_B",
QSTESTCD,MMS104,"""HLU_99679""n.EFF_MMSE.MMSE_C",
QSTESTCD,MMS105,"""HLU_99679""n.EFF_MMSE.MMSE_D",
QSTESTCD,MMS106,"""HLU_99679""n.EFF_MMSE.MMSE_E1",
QSTESTCD,MMS107,"""HLU_99679""n.EFF_MMSE.MMSE_E2",
QSTESTCD,MMS108,"""HLU_99679""n.EFF_MMSE.MMSE_E3",
QSTESTCD,MMS109,"""HLU_99679""n.EFF_MMSE.MMSE_E4",
QSTESTCD,MMS110,"""HLU_99679""n.EFF_MMSE.MMSE_E5",
QSTESTCD,MMS111,"""HLU_99679""n.EFF_MMSE.MMSE_E6",
QSTESTCD,MMS1TOT,"""HLU_99679""n.EFF_MMSE.MMSE_TOTAL_CRF",
QNAM,FASFL,"""HLU_99817""n.CORE_PAT.POP_FULL",
QNAM,RANDFL,"""HLU_99817""n.CORE_PAT.POP_RAND",
QNAM,ITTFL,"""HLU_99817""n.CORE_PAT.POP_TREAT",
QSTESTCD,ADCRL,"""HLU_99817""n.EFF_ACOG.ACOG_1",
QSTESTCD,ADCDIF,"""HLU_99817""n.EFF_ACOG.ACOG_10",
QSTESTCD,ADCRI,"""HLU_99817""n.EFF_ACOG.ACOG_11",
QSTESTCD,ADCOF,"""HLU_99817""n.EFF_ACOG.ACOG_2",
QSTESTCD,ADCCMD,"""HLU_99817""n.EFF_ACOG.ACOG_3",
QSTESTCD,ADCCP,"""HLU_99817""n.EFF_ACOG.ACOG_4",
QSTESTCD,ADCIP,"""HLU_99817""n.EFF_ACOG.ACOG_5",
QSTESTCD,ADCOR,"""HLU_99817""n.EFF_ACOG.ACOG_6",
QSTESTCD,ADCRG,"""HLU_99817""n.EFF_ACOG.ACOG_7",
QSTESTCD,ADCSL,"""HLU_99817""n.EFF_ACOG.ACOG_8",
QSTESTCD,ADCCMP,"""HLU_99817""n.EFF_ACOG.ACOG_9",
QSTESTCD,ADASTOT,"""HLU_99817""n.EFF_ACOG.ACOG_TOT",
QSTESTCD,MMS101,"""HLU_99817""n.EFF_MMSE.MMSE_A1",
QSTESTCD,MMS102,"""HLU_99817""n.EFF_MMSE.MMSE_A2",
QSTESTCD,MMS103,"""HLU_99817""n.EFF_MMSE.MMSE_B",
QSTESTCD,MMS104,"""HLU_99817""n.EFF_MMSE.MMSE_C",
QSTESTCD,MMS105,"""HLU_99817""n.EFF_MMSE.MMSE_D",
QSTESTCD,MMS106,"""HLU_99817""n.EFF_MMSE.MMSE_E1",
QSTESTCD,MMS107,"""HLU_99817""n.EFF_MMSE.MMSE_E2",
QSTESTCD,MMS108,"""HLU_99817""n.EFF_MMSE.MMSE_E3",
QSTESTCD,MMS109,"""HLU_99817""n.EFF_MMSE.MMSE_E4",
QSTESTCD,MMS110,"""HLU_99817""n.EFF_MMSE.MMSE_E5",
QSTESTCD,MMS111,"""HLU_99817""n.EFF_MMSE.MMSE_E6",
QSTESTCD,MMS1TOT,"""HLU_99817""n.EFF_MMSE.MMSE_SCORE_CRF",
QNAM,FASFL,"""HLU_99819""n.CORE_PAT.pop_full",
QNAM,FASFL,"""HLU_99819""n.CORE_PAT.pop_full_99679",
QNAM,RANDFL,"""HLU_99819""n.CORE_PAT.pop_rand_99679",
QNAM,ITTFL,"""HLU_99819""n.CORE_PAT.pop_treat",
QNAM,ITTFL,"""HLU_99819""n.CORE_PAT.pop_treat_99679",
QSTESTCD,ADCDIF01,"""HLU_99819""n.EFF_ADASCOG.ADAS_10",
QSTESTCD,ADCRI01,"""HLU_99819""n.EFF_ADASCOG.ADAS_11",
QSTESTCD,ADCRLT01,"""HLU_99819""n.EFF_ADASCOG.ADAS_1_1",
QSTESTCD,ADCRLT02,"""HLU_99819""n.EFF_ADASCOG.ADAS_1_2",
QSTESTCD,ADCRLT03,"""HLU_99819""n.EFF_ADASCOG.ADAS_1_3",
QSTESTCD,ADCOF01,"""HLU_99819""n.EFF_ADASCOG.ADAS_2_1",
QSTESTCD,ADCOF02,"""HLU_99819""n.EFF_ADASCOG.ADAS_2_2",
QSTESTCD,ADCCMD01,"""HLU_99819""n.EFF_ADASCOG.ADAS_3_B",
QSTESTCD,ADCCMD02,"""HLU_99819""n.EFF_ADASCOG.ADAS_3_C",
QSTESTCD,ADCCMD03,"""HLU_99819""n.EFF_ADASCOG.ADAS_3_D",
QSTESTCD,ADCCMD04,"""HLU_99819""n.EFF_ADASCOG.ADAS_3_E",
QSTESTCD,ADCCMD05,"""HLU_99819""n.EFF_ADASCOG.ADAS_3_F",
QSTESTCD,ADCCP00B,"""HLU_99819""n.EFF_ADASCOG.ADAS_4_B",
QSTESTCD,ADCCP01,"""HLU_99819""n.EFF_ADASCOG.ADAS_4_C",
QSTESTCD,ADCCP02,"""HLU_99819""n.EFF_ADASCOG.ADAS_4_D",
QSTESTCD,ADCCP03,"""HLU_99819""n.EFF_ADASCOG.ADAS_4_E",
QSTESTCD,ADCCP04,"""HLU_99819""n.EFF_ADASCOG.ADAS_4_F",
QSTESTCD,ADCIP01,"""HLU_99819""n.EFF_ADASCOG.ADAS_5_B",
QSTESTCD,ADCIP02,"""HLU_99819""n.EFF_ADASCOG.ADAS_5_C",
QSTESTCD,ADCIP03,"""HLU_99819""n.EFF_ADASCOG.ADAS_5_D",
QSTESTCD,ADCIP04,"""HLU_99819""n.EFF_ADASCOG.ADAS_5_E",
QSTESTCD,ADCIP05,"""HLU_99819""n.EFF_ADASCOG.ADAS_5_F",
QSTESTCD,ADCOR01,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_B",
QSTESTCD,ADCOR02,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_C",
QSTESTCD,ADCOR03,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_D",
QSTESTCD,ADCOR04,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_E",
QSTESTCD,ADCOR05,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_F",
QSTESTCD,ADCOR06,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_G",
QSTESTCD,ADCOR07,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_H",
QSTESTCD,ADCOR08,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_I",
QSTESTCD,ADCRGT01,"""HLU_99819""n.EFF_ADASCOG.ADAS_7_1",
QSTESTCD,ADCRGT02,"""HLU_99819""n.EFF_ADASCOG.ADAS_7_2",
QSTESTCD,ADCRGT03,"""HLU_99819""n.EFF_ADASCOG.ADAS_7_3",
QSTESTCD,ADCSL01,"""HLU_99819""n.EFF_ADASCOG.ADAS_8",
QSTESTCD,ADCCMP01,"""HLU_99819""n.EFF_ADASCOG.ADAS_9",
QSTESTCD,MMS101,"""HLU_99819""n.EFF_MMSE.MMSE_A1",
QSTESTCD,MMS101C,"""HLU_99819""n.EFF_MMSE.MMSE_A1_1",
QSTESTCD,MMS101D,"""HLU_99819""n.EFF_MMSE.MMSE_A1_2",
QSTESTCD,MMS101A,"""HLU_99819""n.EFF_MMSE.MMSE_A1_3",
QSTESTCD,MMS101E,"""HLU_99819""n.EFF_MMSE.MMSE_A1_4",
QSTESTCD,MMS101B,"""HLU_99819""n.EFF_MMSE.MMSE_A1_5",
QSTESTCD,MMS102,"""HLU_99819""n.EFF_MMSE.MMSE_A2",
QSTESTCD,MMS102A,"""HLU_99819""n.EFF_MMSE.MMSE_A2_1",
QSTESTCD,MMS102C,"""HLU_99819""n.EFF_MMSE.MMSE_A2_2",
QSTESTCD,MMS102F,"""HLU_99819""n.EFF_MMSE.MMSE_A2_3",
QSTESTCD,MMS102D,"""HLU_99819""n.EFF_MMSE.MMSE_A2_4",
QSTESTCD,MMS102E,"""HLU_99819""n.EFF_MMSE.MMSE_A2_5",
QSTESTCD,MMS103,"""HLU_99819""n.EFF_MMSE.MMSE_B",
QSTESTCD,MMS103A,"""HLU_99819""n.EFF_MMSE.MMSE_B_1",
QSTESTCD,MMS103C,"""HLU_99819""n.EFF_MMSE.MMSE_B_2",
QSTESTCD,MMS103B,"""HLU_99819""n.EFF_MMSE.MMSE_B_3",
QSTESTCD,MMS104,"""HLU_99819""n.EFF_MMSE.MMSE_C",
QSTESTCD,MMS104A,"""HLU_99819""n.EFF_MMSE.MMSE_C_1",
QSTESTCD,MMS104B,"""HLU_99819""n.EFF_MMSE.MMSE_C_2",
QSTESTCD,MMS104C,"""HLU_99819""n.EFF_MMSE.MMSE_C_3",
QSTESTCD,MMS104D,"""HLU_99819""n.EFF_MMSE.MMSE_C_4",
QSTESTCD,MMS104E,"""HLU_99819""n.EFF_MMSE.MMSE_C_5",
QSTESTCD,MMS105,"""HLU_99819""n.EFF_MMSE.MMSE_D",
QSTESTCD,MMS105A,"""HLU_99819""n.EFF_MMSE.MMSE_D_1",
QSTESTCD,MMS105C,"""HLU_99819""n.EFF_MMSE.MMSE_D_2",
QSTESTCD,MMS105B,"""HLU_99819""n.EFF_MMSE.MMSE_D_3",
QSTESTCD,MMS106,"""HLU_99819""n.EFF_MMSE.MMSE_E1",
QSTESTCD,MMS106B,"""HLU_99819""n.EFF_MMSE.MMSE_E1_1",
QSTESTCD,MMS106A,"""HLU_99819""n.EFF_MMSE.MMSE_E1_2",
QSTESTCD,MMS107,"""HLU_99819""n.EFF_MMSE.MMSE_E2",
QSTESTCD,MMS108,"""HLU_99819""n.EFF_MMSE.MMSE_E3",
QSTESTCD,MMS108A,"""HLU_99819""n.EFF_MMSE.MMSE_E3_1",
QSTESTCD,MMS108B,"""HLU_99819""n.EFF_MMSE.MMSE_E3_2",
QSTESTCD,MMS108C,"""HLU_99819""n.EFF_MMSE.MMSE_E3_3",
QSTESTCD,MMS109,"""HLU_99819""n.EFF_MMSE.MMSE_E4",
QSTESTCD,MMS110,"""HLU_99819""n.EFF_MMSE.MMSE_E5",
QSTESTCD,MMS111,"""HLU_99819""n.EFF_MMSE.MMSE_E6",
QSTESTCD,MMS1TOT,"""HLU_99819""n.EFF_MMSE.MMSE_SCORE_CRF",
QSTESTCD,MMS1TOT,MRZ_9403.CORE_PAT.B_MMSE,
QNAM,FASFL,MRZ_9403.CORE_PAT.POP_FULL,
QNAM,RANDFL,MRZ_9403.CORE_PAT.POP_RAND,
QNAM,ITTFL,MRZ_9403.CORE_PAT.POP_TREAT,
QNAM,FASFL,MRZ_9605.CORE_PAT.POP_FULL,
QNAM,RANDFL,MRZ_9605.CORE_PAT.POP_RAND,
QNAM,ITTFL,MRZ_9605.CORE_PAT.POP_TREAT,
QSTESTCD,MMS101,MRZ_9605.EFF_MMSE.MMSE_A1,
QSTESTCD,MMS102,MRZ_9605.EFF_MMSE.MMSE_A2,
QSTESTCD,MMS103,MRZ_9605.EFF_MMSE.MMSE_B,
QSTESTCD,MMS104,MRZ_9605.EFF_MMSE.MMSE_C,
QSTESTCD,MMS105,MRZ_9605.EFF_MMSE.MMSE_D,
QSTESTCD,MMS106,MRZ_9605.EFF_MMSE.MMSE_E1,
QSTESTCD,MMS107,MRZ_9605.EFF_MMSE.MMSE_E2,
QSTESTCD,MMS108,MRZ_9605.EFF_MMSE.MMSE_E3,
QSTESTCD,MMS109,MRZ_9605.EFF_MMSE.MMSE_E4,
QSTESTCD,MMS110,MRZ_9605.EFF_MMSE.MMSE_E5,
QSTESTCD,MMS111,MRZ_9605.EFF_MMSE.MMSE_E6,
QSTESTCD,MMS1TOT,MRZ_9605.EFF_MMSE.MMSE_TOT,
QSTESTCD,MMS1TOT,MRZ_9901.CORE_PAT.B_MMSE,
QNAM,FASFL,MRZ_9901.CORE_PAT.POP_FULL,
QNAM,RANDFL,MRZ_9901.CORE_PAT.POP_RAND,
QNAM,ITTFL,MRZ_9901.CORE_PAT.POP_TREAT,
;;;;
run;

data WORK._VALUES_;
  infile datalines dsd truncover;
  input TABLE:$32. COLUMN:$32. ORIGIN:$1000. ORIGINWHERE:$1000. ALGORITHM:$1000. ORIGINDESCRIPTION:$1000. ROLE:$200. TERM:$80. MAPSUBMITTED:$1.;
datalines4;
DM,COUNTRY,,,"if index(studyid,""MEM-MD-"") and missing(country) then COUNTRY=""USA"";",,RecordQualifier,(ISO3166),Y
DM,DOMAIN,,,"DOMAIN=""DM"";",,Identifier,(DOMAIN),Y
QS,DOMAIN,,,"DOMAIN=""QS"";",,Identifier,(DOMAIN),Y
QSADASCOG,DOMAIN,,,"DOMAIN=""QS"";",,Identifier,(DOMAIN),Y
SV,DOMAIN,,,"DOMAIN=""SV"";",,Identifier,(DOMAIN),Y
DM,DTHFL,,,"if not(missing(DTHDTC)) then DTHFL=""Y"";",,RecordQualifier,(NY),Y
SUPPDM,IDVAR,,,"IDVAR="""";",,,*,Y
SUPPQS,IDVAR,,,"if QNAM=""DTYPE"" then IDVAR=""QSSEQ"";",,,(DTYPE),Y
SUPPQSADASCOG,IDVAR,,,"if QNAM=""DTYPE"" then IDVAR=""QSSEQ"";",,,(DTYPE),Y
QS,QSBLFL,,,"if QSDY=1 then QSBLFL=""Y"";",,RecordQualifier,(NY),Y
QSADASCOG,QSBLFL,,,"if QSDY=1 then QSBLFL=""Y"";",,RecordQualifier,(NY),Y
QSMMSE,QSBLFL,,,"if QSDY=1 then QSBLFL=""Y"";",,RecordQualifier,(NY),Y
QS,QSCAT,,,"QSCAT=""--TBD--"";",,GroupingQualifier,(QSCAT),Y
QSADASCOG,QSCAT,,,"if substr(QSTESTCD,1,3) in (""ADA"",""ADC"") then QSCAT=""ADAS-COG"";",,GroupingQualifier,(QSCAT),Y
QSMMSE,QSCAT,,,"if index(QSTESTCD,""MMS"")^=0 then QSCAT=""MMSE"";",,GroupingQualifier,(QSCAT),Y
QS,QSDRVFL,,,"if DTYPE^=""OC"" then QSDRVFL=""Y"";",,RecordQualifier,(NY),Y
QSADASCOG,QSDRVFL,,,"if DTYPE^=""OC"" then QSDRVFL=""Y"";",,RecordQualifier,(NY),Y
QS,QSTEST,,,"QSTEST=""--TBD--"";",,SynonymQualifier,(QSTEST),Y
QSADASCOG,QSTEST,,,"QSTEST=put(QSTESTCD,$ADCTC.);",,SynonymQualifier,(QSTEST),Y
QSMMSE,QSTEST,,,"QSTEST=put(QSTESTCD,$MMSE.);",,SynonymQualifier,(QSTEST),Y
QSMMSE,QSTESTCD,,,"if studyid=""FRX-MEM-MD-02"" then QSTESTCD=""MMS1TOT""; if studyid=""FRX-MEM-MD-50"" then QSTESTCD=""MMS1TOT"";",,Topic,(QSTESTCD),Y
SUPPQS,QVAL,,,"if qval=""OC"" then call missing(qval);",,,(DTYPE),Y
SUPPQSADASCOG,QVAL,,,"if qval=""OC"" then call missing(qval);",,,(DTYPE),Y
SUPPDM,RDOMAIN,,,RDOMAIN=DOMAIN;,,,(DOMAIN),Y
SUPPQS,RDOMAIN,,,RDOMAIN=DOMAIN;,,,(DOMAIN),Y
SUPPQSADASCOG,RDOMAIN,,,RDOMAIN=DOMAIN;,,,(DOMAIN),Y
SUPPDM,QNAM,"""FRX_MEM-MD-01""n.D_PROF.ITT",,"QNAM=""ITTFL""","""(D) ITT patient flag""",,(POPINDC),Y
DM,RACE,"""FRX_MEM-MD-01""n.D_PROF.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""FRX_MEM-MD-01""n.D_PROF.RACEC",,,"""(D) Race, character string""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""FRX_MEM-MD-01""n.D_PROF.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""FRX_MEM-MD-01""n.D_PROF.TREAT",,,"""Treatment Code""",RecordQualifier,(ARMCD),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSE1A",,"QSTESTCD=""MMS106B""","""Identify a wristwatch""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSE1B",,"QSTESTCD=""MMS106A""","""Identify a pencil""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEA1",,"QSTESTCD=""MMS101""","""Orientation time score""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEA1AD",,"QSTESTCD=""MMS101D""","""Today's Date (Day)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEA1AM",,"QSTESTCD=""MMS101C""","""Today's Date (Month)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEA1AY",,"QSTESTCD=""MMS101A""","""Today's Date (Year)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEA1B",,"QSTESTCD=""MMS101E""","""Day of the week""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEA1C",,"QSTESTCD=""MMS101B""","""Season""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEA2",,"QSTESTCD=""MMS102""","""Orientation place score""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEA2A1",,"QSTESTCD=""MMS102A""","""Present state""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEA2A2",,"QSTESTCD=""MMS102C""","""Present city""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEA2A3",,"QSTESTCD=""MMS102F""","""Present part of city""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEA2A4",,"QSTESTCD=""MMS102D""","""Present building""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEA2A5",,"QSTESTCD=""MMS102E""","""Present floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEB",,"QSTESTCD=""MMS103""","""Registration score""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEB1",,"QSTESTCD=""MMS103A""","""Registers an apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEB2",,"QSTESTCD=""MMS103C""","""Registers a table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEB3",,"QSTESTCD=""MMS103B""","""Registers a penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEC",,"QSTESTCD=""MMS104""","""Attention and calculation score""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSECH1",,"QSTESTCD=""MMS104A""","""First difference (93)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSECH2",,"QSTESTCD=""MMS104B""","""Second difference (86)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSECH3",,"QSTESTCD=""MMS104C""","""Third difference (79)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSECH4",,"QSTESTCD=""MMS104D""","""Fourth difference (72)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSECH5",,"QSTESTCD=""MMS104E""","""Fifth difference (65)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSED",,"QSTESTCD=""MMS105""","""Recall score""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSED1",,"QSTESTCD=""MMS105A""","""Recall apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSED2",,"QSTESTCD=""MMS105C""","""Recall table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSED3",,"QSTESTCD=""MMS105B""","""Recall penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEE2",,"QSTESTCD=""MMS107""","""Say no ifs and or buts""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEE3A",,"QSTESTCD=""MMS108A""","""Take paper in right hand""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEE3B",,"QSTESTCD=""MMS108B""","""Fold paper""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEE3C",,"QSTESTCD=""MMS108C""","""Place paper on floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEE4",,"QSTESTCD=""MMS109""","""Read a sentence""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEE5",,"QSTESTCD=""MMS110""","""Write a sentence""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSEE6",,"QSTESTCD=""MMS111""","""Pentagon drawing""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-01""n.MMSE.MMSETOT",,"QSTESTCD=""MMS1TOT""","""Sum of score for section A-E""",Topic,(MMSE),Y
QSMMSE,VISIT,"""FRX_MEM-MD-01""n.MMSE.VISIT",,,"""Visit Number""",Timing,(VIS),Y
SUPPDM,QNAM,"""FRX_MEM-MD-02""n.D_PROF.ITT",,"QNAM=""ITTFL""","""(D) ITT Patient Flag""",,(POPINDC),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-02""n.D_PROF.MMSEBASE",,"QSTESTCD=""MMS1TOT2""","""(D) BASELINE MMSE""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-02""n.D_PROF.MMSESCRN",,"QSTESTCD=""MMS1TOT1""","""(D) SCREENING MMSE""",Topic,(MMSE),Y
DM,RACE,"""FRX_MEM-MD-02""n.D_PROF.RACE",,,"""PATIENT RACE""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""FRX_MEM-MD-02""n.D_PROF.RACEC",,,"""(D) Race, Character String""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""FRX_MEM-MD-02""n.D_PROF.SEX",,,"""PATIENT SEX""",RecordQualifier,(SEX),Y
DM,ARMCD,"""FRX_MEM-MD-02""n.D_PROF.TREAT",,,"""Treatment Code""",RecordQualifier,(ARMCD),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-03AB""n.D_EFF.PARAMC",,,"""(D) Efficacy Parameter Text""",Topic,(MMSE),Y
QSMMSE,VISIT,"""FRX_MEM-MD-03AB""n.D_EFF.WINDOW",,,"""(D) Analysis Window""",Timing,(VIS),Y
SUPPDM,QNAM,"""FRX_MEM-MD-03AB""n.D_PROF.ITT",,"QNAM=""ITTFL""","""(D) ITT Patient Flag""",,(POPINDC),Y
DM,RACE,"""FRX_MEM-MD-03AB""n.D_PROF.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""FRX_MEM-MD-03AB""n.D_PROF.RACEC",,,"""(D) Race, Character String""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""FRX_MEM-MD-03AB""n.D_PROF.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""FRX_MEM-MD-03AB""n.D_PROF.TRTSEQ",,,"""(D) Treatment Sequence Code""",RecordQualifier,(ARMCD),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-03C""n.D_EFF1.PARAMC",,,"""(D) Efficacy Parameter Text""",Topic,(MMSE),Y
QSMMSE,VISIT,"""FRX_MEM-MD-03C""n.D_EFF1.WINDOW",,,"""(D) Analysis Window""",Timing,(VIS),Y
SUPPDM,QNAM,"""FRX_MEM-MD-03C""n.D_PROF.ITT",,"QNAM=""ITTFL""","""(D) ITT patient flag""",,(POPINDC),Y
DM,RACE,"""FRX_MEM-MD-03C""n.D_PROF.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""FRX_MEM-MD-03C""n.D_PROF.RACEC",,,"""(D) Race, Character String""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""FRX_MEM-MD-03C""n.D_PROF.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""FRX_MEM-MD-03C""n.D_PROF.TRTSEQ",,,"""(D) Treatment Sequence Code""",RecordQualifier,(ARMCD),Y
SUPPQSADASCOG,QNAM,"""FRX_MEM-MD-10""n.D_EFF.OBSTYPE",where 1<=param<=12,"QNAM=""DTYPE""","""(D) Observed Type""",,(DTYPE),Y
SUPPQSADASCOG,QVAL,"""FRX_MEM-MD-10""n.D_EFF.OBSTYPE",where 1<=param<=12,,"""(D) Observed Type""",,(DTYPE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-10""n.D_EFF.PARAMC",,,"""(D) Efficacy Parameter Text""",Topic,(MMSE),Y
QSADASCOG,QSTESTCD,"""FRX_MEM-MD-10""n.D_EFF.PARAMC",where 1<=param<=12,,"""(D) Efficacy Parameter Text""",Topic,(ADCTC),Y
QSMMSE,VISIT,"""FRX_MEM-MD-10""n.D_EFF.VISIT",,,"""Visit Number""",Timing,(VIS),Y
SUPPDM,QNAM,"""FRX_MEM-MD-10""n.D_PROF.ITT",,"QNAM=""ITTFL""","""(D) ITT Patient Flag""",,(POPINDC),Y
DM,RACE,"""FRX_MEM-MD-10""n.D_PROF.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""FRX_MEM-MD-10""n.D_PROF.RACEC",,,"""(D) Race, Character String""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""FRX_MEM-MD-10""n.D_PROF.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""FRX_MEM-MD-10""n.D_PROF.TREAT",,,"""Treatment Code""",RecordQualifier,(ARMCD),Y
SUPPQSADASCOG,QNAM,"""FRX_MEM-MD-11AB""n.D_EFF.OBSTYPE",where 1<=param<=12,"QNAM=""DTYPE""","""(D) Observed Type""",,(DTYPE),Y
SUPPQSADASCOG,QVAL,"""FRX_MEM-MD-11AB""n.D_EFF.OBSTYPE",where 1<=param<=12,,"""(D) Observed Type""",,(DTYPE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-11AB""n.D_EFF.PARAMC",,,"""(D) Efficacy Parameter Text""",Topic,(MMSE),Y
QSADASCOG,QSTESTCD,"""FRX_MEM-MD-11AB""n.D_EFF.PARAMC",where 1<=param<=12,,"""(D) Efficacy Parameter Text""",Topic,(ADCTC),Y
QSMMSE,VISIT,"""FRX_MEM-MD-11AB""n.D_EFF.VISIT",,,"""Visit Number""",Timing,(VIS),Y
SUPPDM,QNAM,"""FRX_MEM-MD-11AB""n.D_PROF.ITT",,"QNAM=""ITTFL""","""(D) ITT Patient Flag""",,(POPINDC),Y
DM,RACE,"""FRX_MEM-MD-11AB""n.D_PROF.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""FRX_MEM-MD-11AB""n.D_PROF.RACEC",,,"""(D) Race, Character String""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""FRX_MEM-MD-11AB""n.D_PROF.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""FRX_MEM-MD-11AB""n.D_PROF.TREAT",,,"""(D) Treatment Sequence Code""",RecordQualifier,(ARMCD),Y
SUPPQSADASCOG,QNAM,"""FRX_MEM-MD-11C""n.D_EFF.OBSTYPE",where 1<=param<=12,"QNAM=""DTYPE""","""(D) Observed Type""",,(DTYPE),Y
SUPPQSADASCOG,QVAL,"""FRX_MEM-MD-11C""n.D_EFF.OBSTYPE",where 1<=param<=12,,"""(D) Observed Type""",,(DTYPE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-11C""n.D_EFF.PARAMC",,,"""(D) Efficacy Parameter Text""",Topic,(MMSE),Y
QSADASCOG,QSTESTCD,"""FRX_MEM-MD-11C""n.D_EFF.PARAMC",where 1<=param<=12,,"""(D) Efficacy Parameter Text""",Topic,(ADCTC),Y
QSMMSE,VISIT,"""FRX_MEM-MD-11C""n.D_EFF.WINDOW",,,"""(D) Analysis Window""",Timing,(VIS),Y
SUPPDM,QNAM,"""FRX_MEM-MD-11C""n.D_PROF.ITT",,"QNAM=""ITTFL""","""(D) ITT Patient Flag""",,(POPINDC),Y
DM,RACE,"""FRX_MEM-MD-11C""n.D_PROF.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""FRX_MEM-MD-11C""n.D_PROF.RACEC",,,"""(D) Race, Character String""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""FRX_MEM-MD-11C""n.D_PROF.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""FRX_MEM-MD-11C""n.D_PROF.TREAT",,,"""(D) Treatment Sequence Code""",RecordQualifier,(ARMCD),Y
SUPPQSADASCOG,QNAM,"""FRX_MEM-MD-12""n.D_EFF.OBSTYPE",where 1<=param<=12,"QNAM=""DTYPE""","""(D) Observed Type""",,(DTYPE),Y
SUPPQSADASCOG,QVAL,"""FRX_MEM-MD-12""n.D_EFF.OBSTYPE",where 1<=param<=12,,"""(D) Observed Type""",,(DTYPE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-12""n.D_EFF.PARAMC",,,"""(D) Efficacy Parameter Text""",Topic,(MMSE),Y
QSADASCOG,QSTESTCD,"""FRX_MEM-MD-12""n.D_EFF.PARAMC",where 1<=param<=12,,"""(D) Efficacy Parameter Text""",Topic,(ADCTC),Y
QSMMSE,VISIT,"""FRX_MEM-MD-12""n.D_EFF.WINDOW",,,"""(D) Analysis Window""",Timing,(VIS),Y
SUPPDM,QNAM,"""FRX_MEM-MD-12""n.D_PROF.ITT",,"QNAM=""ITTFL""","""(D) ITT Patient Flag""",,(POPINDC),Y
DM,RACE,"""FRX_MEM-MD-12""n.D_PROF.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""FRX_MEM-MD-12""n.D_PROF.RACEC",,,"""(D) Race, Character String""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""FRX_MEM-MD-12""n.D_PROF.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""FRX_MEM-MD-12""n.D_PROF.TREAT",,,"""Treatment Code""",RecordQualifier,(ARMCD),Y
SUPPQSADASCOG,QNAM,"""FRX_MEM-MD-12A""n.D_EFF.OBSTYPE",where 1<=param<=12,"QNAM=""DTYPE""","""(D) Observed Type""",,(DTYPE),Y
SUPPQSADASCOG,QVAL,"""FRX_MEM-MD-12A""n.D_EFF.OBSTYPE",where 1<=param<=12,,"""(D) Observed Type""",,(DTYPE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-12A""n.D_EFF.PARAMC",,,"""(D) Efficacy Parameter Text""",Topic,(MMSE),Y
QSADASCOG,QSTESTCD,"""FRX_MEM-MD-12A""n.D_EFF.PARAMC",where 1<=param<=12,,"""(D) Efficacy Parameter Text""",Topic,(ADCTC),Y
QSMMSE,VISIT,"""FRX_MEM-MD-12A""n.D_EFF.WINDOW",,,"""(D) Analysis Window""",Timing,(VIS),Y
SUPPDM,QNAM,"""FRX_MEM-MD-12A""n.D_PROF.ITT",,"QNAM=""ITTFL""","""(D) ITT Patient Flag""",,(POPINDC),Y
DM,RACE,"""FRX_MEM-MD-12A""n.D_PROF.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""FRX_MEM-MD-12A""n.D_PROF.RACEC",,,"""(D) Race, Character String""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""FRX_MEM-MD-12A""n.D_PROF.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""FRX_MEM-MD-12A""n.D_PROF.TREAT",,,"""Treatment Code""",RecordQualifier,(ARMCD),Y
SUPPQSADASCOG,QNAM,"""FRX_MEM-MD-12B""n.D_EFF.OBSTYPE",where 1<=param<=12,"QNAM=""DTYPE""","""(D) Observed Type""",,(DTYPE),Y
SUPPQSADASCOG,QVAL,"""FRX_MEM-MD-12B""n.D_EFF.OBSTYPE",where 1<=param<=12,,"""(D) Observed Type""",,(DTYPE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-12B""n.D_EFF.PARAMC",,,"""(D) Efficacy Parameter Text""",Topic,(MMSE),Y
QSADASCOG,QSTESTCD,"""FRX_MEM-MD-12B""n.D_EFF.PARAMC",where 1<=param<=12,,"""(D) Efficacy Parameter Text""",Topic,(ADCTC),Y
QSMMSE,VISIT,"""FRX_MEM-MD-12B""n.D_EFF.WINDOW",,,"""(D) Analysis Window""",Timing,(VIS),Y
SUPPDM,QNAM,"""FRX_MEM-MD-12B""n.D_PROF.ITT",,"QNAM=""ITTFL""","""(D) ITT Patient Flag""",,(POPINDC),Y
DM,RACE,"""FRX_MEM-MD-12B""n.D_PROF.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""FRX_MEM-MD-12B""n.D_PROF.RACEC",,,"""(D) Race, Character String""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""FRX_MEM-MD-12B""n.D_PROF.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""FRX_MEM-MD-12B""n.D_PROF.TREAT",,,"""(D) Treatment Sequence Code""",RecordQualifier,(ARMCD),Y
SUPPQS,QNAM,"""FRX_MEM-MD-22""n.D_EFF.OBSTYPE",,"QNAM=""DTYPE""","""(D) Observed Type""",,(DTYPE),Y
SUPPQS,QVAL,"""FRX_MEM-MD-22""n.D_EFF.OBSTYPE",,,"""(D) Observed Type""",,(DTYPE),Y
QS,QSTESTCD,"""FRX_MEM-MD-22""n.D_EFF.PARAMC",,,"""(D) Efficacy Parameter Text""",Topic,(QSTESTCD),Y
SUPPDM,QNAM,"""FRX_MEM-MD-22""n.D_PROF.ITT",,"QNAM=""ITTFL""","""(D) ITT Patient Flag""",,(POPINDC),Y
DM,RACE,"""FRX_MEM-MD-22""n.D_PROF.RACE",,,"""Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""FRX_MEM-MD-22""n.D_PROF.RACEC",,,"""(D) Race, Character String""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""FRX_MEM-MD-22""n.D_PROF.SEX",,,"""Gender""",RecordQualifier,(SEX),Y
DM,ARMCD,"""FRX_MEM-MD-22""n.D_PROF.TREAT",,,"""(D) Treatment Code""",RecordQualifier,(ARMCD),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-22""n.MMSE.MMSEA1",,"QSTESTCD=""MMS101""","""A. Orientation Time: (0 to 5)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-22""n.MMSE.MMSEA2",,"QSTESTCD=""MMS102""","""A. Orientation Place: (0 to 5)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-22""n.MMSE.MMSEB",,"QSTESTCD=""MMS103""","""B. Registration: (0 to 3)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-22""n.MMSE.MMSEC",,"QSTESTCD=""MMS104""","""C. Attention and Calculation: (0 to 5)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-22""n.MMSE.MMSED",,"QSTESTCD=""MMS105""","""D. Recall: (0 to 3)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-22""n.MMSE.MMSETOT",,"QSTESTCD=""MMS1TOT""","""Sum of Scores""",Topic,(MMSE),Y
QSMMSE,VISIT,"""FRX_MEM-MD-22""n.MMSE.VISIT",,,"""Visit Number""",Timing,(VIS),Y
SUPPQS,QNAM,"""FRX_MEM-MD-50""n.D_EFF1.OBSTYPE",,"QNAM=""DTYPE""","""(D) Observed Type""",,(DTYPE),Y
SUPPQS,QVAL,"""FRX_MEM-MD-50""n.D_EFF1.OBSTYPE",,,"""(D) Observed Type""",,(DTYPE),Y
QS,QSTESTCD,"""FRX_MEM-MD-50""n.D_EFF1.PARAMC",,,"""(D) Efficacy Parameter Text""",Topic,(QSTESTCD),Y
SUPPQS,QNAM,"""FRX_MEM-MD-50""n.D_EFF2.OBSTYPE",,"QNAM=""DTYPE""","""(D) Observed Type""",,(DTYPE),Y
SUPPQS,QVAL,"""FRX_MEM-MD-50""n.D_EFF2.OBSTYPE",,,"""(D) Observed Type""",,(DTYPE),Y
QS,QSTESTCD,"""FRX_MEM-MD-50""n.D_EFF2.PARAMC",,,"""(D) Efficacy Parameter Text""",Topic,(QSTESTCD),Y
DM,COUNTRY,"""FRX_MEM-MD-50""n.D_PROF.COUNTRY",,,"""(D) Country""",RecordQualifier,(ISO3166),Y
SUPPDM,QNAM,"""FRX_MEM-MD-50""n.D_PROF.ITT",,"QNAM=""ITTFL""","""(D) ITT Patient Flag""",,(POPINDC),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-50""n.D_PROF.MMSEBASE",,"QSTESTCD=""MMS1TOT2""","""MMSE at Baseline Visit""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""FRX_MEM-MD-50""n.D_PROF.MMSESCRN",,"QSTESTCD=""MMS1TOT1""","""MMSE at Screening Visit""",Topic,(MMSE),Y
DM,RACE,"""FRX_MEM-MD-50""n.D_PROF.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""FRX_MEM-MD-50""n.D_PROF.RACEC",,,"""(D) Race, Character String""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""FRX_MEM-MD-50""n.D_PROF.SEX",,,"""Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""FRX_MEM-MD-50""n.D_PROF.TREAT",,,"""(D) Treatment Code""",RecordQualifier,(ARMCD),Y
DM,COUNTRY,"""HLU_10112""n.CORE_PAT.COUNTRY",,,"""Country Code""",RecordQualifier,(ISO3166),Y
SUPPDM,QNAM,"""HLU_10112""n.CORE_PAT.POP_FULL",,"QNAM=""FASFL""","""POP_FULL""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10112""n.CORE_PAT.POP_FULL",,,"""POP_FULL""",,(NY),Y
SUPPDM,QNAM,"""HLU_10112""n.CORE_PAT.POP_RAND",,"QNAM=""RANDFL""","""POP_RAND""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10112""n.CORE_PAT.POP_RAND",,,"""POP_RAND""",,(NY),Y
SUPPDM,QNAM,"""HLU_10112""n.CORE_PAT.POP_TREAT",,"QNAM=""ITTFL""","""POP_TREAT""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10112""n.CORE_PAT.POP_TREAT",,,"""POP_TREAT""",,(NY),Y
DM,RACE,"""HLU_10112""n.CORE_PAT.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""HLU_10112""n.CORE_PAT.RACE_S",,,"""Patient Race, Other Description""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""HLU_10112""n.CORE_PAT.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""HLU_10112""n.CORE_PAT.TREAT",,,"""Treatment Code""",RecordQualifier,(ARMCD),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ACOG_6",,"QSTESTCD=""ADCOR""","""ADAS-COG Orientation""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_10",,"QSTESTCD=""ADCDIF01""","""10. Word finding difficulty""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_11",,"QSTESTCD=""ADCRI01""","""11. Remembering test instructions""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_1_1",,"QSTESTCD=""ADCRLT01""","""1. I Word Recall task Trial I""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_1_2",,"QSTESTCD=""ADCRLT02""","""1.II Word Recall task Trial II""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_1_3",,"QSTESTCD=""ADCRLT03""","""1.III Word Recall task Trial III""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_2_1",,"QSTESTCD=""ADCOF01""","""2. A. Objects""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_2_2",,"QSTESTCD=""ADCOF02""","""2. B. Fingers""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_3_B",,"QSTESTCD=""ADCCMD01""","""3. Commands - Make a fist""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_3_C",,"QSTESTCD=""ADCCMD02""","""3. Commands - Point to the ceiling/floor""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_3_D",,"QSTESTCD=""ADCCMD03""","""3. Commands - Pencil on top of the card/""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_3_E",,"QSTESTCD=""ADCCMD04""","""3. Commands - Watch on other side of pen""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_3_F",,"QSTESTCD=""ADCCMD05""","""3. Commands - Tap each shoulder twice""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_4_B",,"QSTESTCD=""ADCCP00B""","""4. Constr. - Pt. drew no forms...""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_4_C",,"QSTESTCD=""ADCCP01""","""4. Constr. - Circle""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_4_D",,"QSTESTCD=""ADCCP02""","""4. Constr. - Two overlapping rectangles""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_4_E",,"QSTESTCD=""ADCCP03""","""4. Constr. - Rhombus""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_4_F",,"QSTESTCD=""ADCCP04""","""4. Constr. - Cube""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_5_B",,"QSTESTCD=""ADCIP01""","""5. Ideat. - Fold a letter""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_5_C",,"QSTESTCD=""ADCIP02""","""5. Ideat. - Put letter in envelope""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_5_D",,"QSTESTCD=""ADCIP03""","""5. Ideat. - Seal envelope""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_5_E",,"QSTESTCD=""ADCIP04""","""5. Ideat. - Address envelope""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_5_F",,"QSTESTCD=""ADCIP05""","""5. Ideat. - Indicate where stamp goes""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_6_B",,"QSTESTCD=""ADCOR01""","""6. Orient - Full name""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_6_C",,"QSTESTCD=""ADCOR02""","""6. Orient - Month""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_6_D",,"QSTESTCD=""ADCOR03""","""6. Orient - Date""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_6_E",,"QSTESTCD=""ADCOR04""","""6. Orient - Year""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_6_F",,"QSTESTCD=""ADCOR05""","""6. Orient - Day""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_6_G",,"QSTESTCD=""ADCOR06""","""6. Orient - Season""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_6_H",,"QSTESTCD=""ADCOR07""","""6. Orient - Place""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_6_I",,"QSTESTCD=""ADCOR08""","""6. Orient - Time of day""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_7_1",,"QSTESTCD=""ADCRGT01""","""7. Word Recog - Trial I""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_7_2",,"QSTESTCD=""ADCRGT02""","""7. Word Recog. - Trial II""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_7_3",,"QSTESTCD=""ADCRGT03""","""7. Word Recog. - Trial III""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_8",,"QSTESTCD=""ADCSL01""","""8. Language""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_10112""n.EFF_ACOG.ADAS_9",,"QSTESTCD=""ADCCMP01""","""9. Comprehension of spoken language""",Topic,(ADCTC),Y
QSMMSE,VISIT,"""HLU_10112""n.EFF_MMSE.ANALYSIS_DAY",,,"""Nominal or Window Day for Analysis""",Timing,(VIS),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_A1",,"QSTESTCD=""MMS101""","""Time""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_A1_1",,"QSTESTCD=""MMS101C""","""Time - Month""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_A1_2",,"QSTESTCD=""MMS101D""","""Time - Day""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_A1_3",,"QSTESTCD=""MMS101A""","""Time - Year""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_A1_4",,"QSTESTCD=""MMS101E""","""Time - Day of week""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_A1_5",,"QSTESTCD=""MMS101B""","""Time - season""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_A2",,"QSTESTCD=""MMS102""","""Place""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_A2_1",,"QSTESTCD=""MMS102A""","""Place - State""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_A2_2",,"QSTESTCD=""MMS102C""","""Place - City""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_A2_3",,"QSTESTCD=""MMS102F""","""Place - Part of city""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_A2_4",,"QSTESTCD=""MMS102D""","""Place - Building""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_A2_5",,"QSTESTCD=""MMS102E""","""Place - Floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_B",,"QSTESTCD=""MMS103""","""Registration""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_B_1",,"QSTESTCD=""MMS103A""","""Registration - Apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_B_2",,"QSTESTCD=""MMS103C""","""Registration - Table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_B_3",,"QSTESTCD=""MMS103B""","""Registration - Penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_C",,"QSTESTCD=""MMS104""","""Attention and Calculation""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_C_1",,"QSTESTCD=""MMS104A""","""Attention and Calculation - Num1 Correct number (93)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_C_2",,"QSTESTCD=""MMS104B""","""Attention and Calculation - Num2 Correct number (86)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_C_3",,"QSTESTCD=""MMS104C""","""Attention and Calculation - Num3 Correct number (79)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_C_4",,"QSTESTCD=""MMS104D""","""Attention and Calculation - Num4 Correct number (72)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_C_5",,"QSTESTCD=""MMS104E""","""Attention and Calculation - Num5 Correct number (65)""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_D",,"QSTESTCD=""MMS105""","""Recall""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_D_1",,"QSTESTCD=""MMS105A""","""Recall - Apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_D_2",,"QSTESTCD=""MMS105C""","""Recall - Table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_D_3",,"QSTESTCD=""MMS105B""","""Recall - Penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_E1",,"QSTESTCD=""MMS106""","""Language - Naming""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_E1_1",,"QSTESTCD=""MMS106B""","""Language - naming - watch""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_E1_2",,"QSTESTCD=""MMS106A""","""Language - naming - pencil""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_E2",,"QSTESTCD=""MMS107""","""Language - Repetition""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_E3",,"QSTESTCD=""MMS108""","""Language - Three-stage command""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_E3_1",,"QSTESTCD=""MMS108A""","""Language - Three-stage command - Paper in right hand""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_E3_2",,"QSTESTCD=""MMS108B""","""Language - Three-stage command - paper folded""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_E3_3",,"QSTESTCD=""MMS108C""","""Language - Three-stage command - Paper placed on floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_E4",,"QSTESTCD=""MMS109""","""Language - Reading""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_E5",,"QSTESTCD=""MMS110""","""Language - Writing""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_E6",,"QSTESTCD=""MMS111""","""Language - Copying""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10112""n.EFF_MMSE.MMSE_TOT",,"QSTESTCD=""MMS1TOT""","""MMSE Score""",Topic,(MMSE),Y
DM,COUNTRY,"""HLU_10113""n.CORE_PAT.COUNTRY",,,"""Country Code""",RecordQualifier,(ISO3166),Y
SUPPDM,QNAM,"""HLU_10113""n.CORE_PAT.POP_FULL",,"QNAM=""FASFL""","""POP_FULL""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10113""n.CORE_PAT.POP_FULL",,,"""POP_FULL""",,(NY),Y
SUPPDM,QNAM,"""HLU_10113""n.CORE_PAT.POP_RAND",,"QNAM=""RANDFL""","""POP_RAND""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10113""n.CORE_PAT.POP_RAND",,,"""POP_RAND""",,(NY),Y
SUPPDM,QNAM,"""HLU_10113""n.CORE_PAT.POP_TREAT",,"QNAM=""ITTFL""","""POP_TREAT""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10113""n.CORE_PAT.POP_TREAT",,,"""POP_TREAT""",,(NY),Y
DM,RACE,"""HLU_10113""n.CORE_PAT.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""HLU_10113""n.CORE_PAT.RACE_S",,,"""Patient Race, Other Description""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""HLU_10113""n.CORE_PAT.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""HLU_10113""n.CORE_PAT.TREAT",,,"""Randomised Treatment""",RecordQualifier,(ARMCD),Y
QSMMSE,VISIT,"""HLU_10113""n.EFF_MMSE.ANALYSIS_DAY",,,"""Nominal or Window Day for Analysis""",Timing,(VIS),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_A1",,"QSTESTCD=""MMS101""","""Time""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_A1_1",,"QSTESTCD=""MMS101C""","""Time - Month""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_A1_2",,"QSTESTCD=""MMS101D""","""Time - Day""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_A1_3",,"QSTESTCD=""MMS101A""","""Time - Year""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_A1_4",,"QSTESTCD=""MMS101E""","""Time - Day of week""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_A1_5",,"QSTESTCD=""MMS101B""","""Time - season""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_A2",,"QSTESTCD=""MMS102""","""Place""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_A2_1",,"QSTESTCD=""MMS102A""","""Place - State""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_A2_2",,"QSTESTCD=""MMS102C""","""Place - City""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_A2_3",,"QSTESTCD=""MMS102F""","""Place - Part of city""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_A2_4",,"QSTESTCD=""MMS102D""","""Place - Building""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_A2_5",,"QSTESTCD=""MMS102E""","""Place - Floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_B",,"QSTESTCD=""MMS103""","""Registration""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_B_1",,"QSTESTCD=""MMS103A""","""Registration - Apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_B_2",,"QSTESTCD=""MMS103C""","""Registration - Table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_B_3",,"QSTESTCD=""MMS103B""","""Registration - Penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_C",,"QSTESTCD=""MMS104""","""Attention and Calculation""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_C_1",,"QSTESTCD=""MMS104A""","""Attention and Calculation - Num1 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_C_2",,"QSTESTCD=""MMS104B""","""Attention and Calculation - Num2 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_C_3",,"QSTESTCD=""MMS104C""","""Attention and Calculation - Num3 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_C_4",,"QSTESTCD=""MMS104D""","""Attention and Calculation - Num4 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_C_5",,"QSTESTCD=""MMS104E""","""Attention and Calculation - Num5 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_D",,"QSTESTCD=""MMS105""","""Recall""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_D_1",,"QSTESTCD=""MMS105A""","""Recall - Apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_D_2",,"QSTESTCD=""MMS105C""","""Recall - Table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_D_3",,"QSTESTCD=""MMS105B""","""Recall - Penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_E1",,"QSTESTCD=""MMS106""","""Language - Naming""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_E1_1",,"QSTESTCD=""MMS106B""","""Language - naming - watch""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_E1_2",,"QSTESTCD=""MMS106A""","""Language - naming - pencil""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_E2",,"QSTESTCD=""MMS107""","""Language - Repetition""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_E3",,"QSTESTCD=""MMS108""","""Language - Three-stage command""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_E3_1",,"QSTESTCD=""MMS108A""","""Language - Three-stage command - Paper in right hand""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_E3_2",,"QSTESTCD=""MMS108B""","""Language - Three-stage command - paper folded""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_E3_3",,"QSTESTCD=""MMS108C""","""Language - Three-stage command - Paper placed on floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_E4",,"QSTESTCD=""MMS109""","""Language - Reading""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_E5",,"QSTESTCD=""MMS110""","""Language - Writing""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_E6",,"QSTESTCD=""MMS111""","""Language - Copying""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10113""n.EFF_MMSE.MMSE_TOT",,"QSTESTCD=""MMS1TOT""","""MMSE Score""",Topic,(MMSE),Y
DM,COUNTRY,"""HLU_10114""n.CORE_PAT.COUNTRY",,,"""Country Code""",RecordQualifier,(ISO3166),Y
SUPPDM,QNAM,"""HLU_10114""n.CORE_PAT.POP_FULL",,"QNAM=""FASFL""","""POP_FULL""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10114""n.CORE_PAT.POP_FULL",,,"""POP_FULL""",,(NY),Y
SUPPDM,QNAM,"""HLU_10114""n.CORE_PAT.POP_RAND",,"QNAM=""RANDFL""","""POP_RAND""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10114""n.CORE_PAT.POP_RAND",,,"""POP_RAND""",,(NY),Y
SUPPDM,QNAM,"""HLU_10114""n.CORE_PAT.POP_TREAT",,"QNAM=""ITTFL""","""POP_TREAT""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10114""n.CORE_PAT.POP_TREAT",,,"""POP_TREAT""",,(NY),Y
DM,RACE,"""HLU_10114""n.CORE_PAT.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""HLU_10114""n.CORE_PAT.RACE_S",,,"""Patient Race, Other Description""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""HLU_10114""n.CORE_PAT.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""HLU_10114""n.CORE_PAT.TREAT",,,"""Randomised Treatment""",RecordQualifier,(ARMCD),Y
QSMMSE,VISIT,"""HLU_10114""n.EFF_MMSE.ANALYSIS_DAY",,,"""Nominal or Window Day for Analysis""",Timing,(VIS),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_A1",,"QSTESTCD=""MMS101""","""Time""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_A1_1",,"QSTESTCD=""MMS101C""","""Time - Month""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_A1_2",,"QSTESTCD=""MMS101D""","""Time - Day""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_A1_3",,"QSTESTCD=""MMS101A""","""Time - Year""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_A1_4",,"QSTESTCD=""MMS101E""","""Time - Day of week""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_A1_5",,"QSTESTCD=""MMS101B""","""Time - season""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_A2",,"QSTESTCD=""MMS102""","""Place""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_A2_1",,"QSTESTCD=""MMS102A""","""Place - State""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_A2_2",,"QSTESTCD=""MMS102C""","""Place - City""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_A2_3",,"QSTESTCD=""MMS102F""","""Place - Part of city""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_A2_4",,"QSTESTCD=""MMS102D""","""Place - Building""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_A2_5",,"QSTESTCD=""MMS102E""","""Place - Floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_B",,"QSTESTCD=""MMS103""","""Registration""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_B_1",,"QSTESTCD=""MMS103A""","""Registration - Apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_B_2",,"QSTESTCD=""MMS103C""","""Registration - Table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_B_3",,"QSTESTCD=""MMS103B""","""Registration - Penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_C",,"QSTESTCD=""MMS104""","""Attention and Calculation""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_C_1",,"QSTESTCD=""MMS104A""","""Attention and Calculation - Num1 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_C_2",,"QSTESTCD=""MMS104B""","""Attention and Calculation - Num2 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_C_3",,"QSTESTCD=""MMS104C""","""Attention and Calculation - Num3 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_C_4",,"QSTESTCD=""MMS104D""","""Attention and Calculation - Num4 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_C_5",,"QSTESTCD=""MMS104E""","""Attention and Calculation - Num5 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_D",,"QSTESTCD=""MMS105""","""Recall""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_D_1",,"QSTESTCD=""MMS105A""","""Recall - Apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_D_2",,"QSTESTCD=""MMS105C""","""Recall - Table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_D_3",,"QSTESTCD=""MMS105B""","""Recall - Penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_E1",,"QSTESTCD=""MMS106""","""Language - Naming""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_E1_1",,"QSTESTCD=""MMS106B""","""Language - naming - watch""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_E1_2",,"QSTESTCD=""MMS106A""","""Language - naming - pencil""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_E2",,"QSTESTCD=""MMS107""","""Language - Repetition""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_E3",,"QSTESTCD=""MMS108""","""Language - Three-stage command""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_E3_1",,"QSTESTCD=""MMS108A""","""Language - Three-stage command - Paper in right hand""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_E3_2",,"QSTESTCD=""MMS108B""","""Language - Three-stage command - paper folded""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_E3_3",,"QSTESTCD=""MMS108C""","""Language - Three-stage command - Paper placed on floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_E4",,"QSTESTCD=""MMS109""","""Language - Reading""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_E5",,"QSTESTCD=""MMS110""","""Language - Writing""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_E6",,"QSTESTCD=""MMS111""","""Language - Copying""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10114""n.EFF_MMSE.MMSE_TOT",,"QSTESTCD=""MMS1TOT""","""MMSE Score""",Topic,(MMSE),Y
DM,COUNTRY,"""HLU_10116""n.CORE_PAT.COUNTRY",,,"""Country Code""",RecordQualifier,(ISO3166),Y
SUPPDM,QNAM,"""HLU_10116""n.CORE_PAT.POP_FULL",,"QNAM=""FASFL""","""POP_FULL""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10116""n.CORE_PAT.POP_FULL",,,"""POP_FULL""",,(NY),Y
SUPPDM,QNAM,"""HLU_10116""n.CORE_PAT.POP_RAND",,"QNAM=""RANDFL""","""POP_RAND""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10116""n.CORE_PAT.POP_RAND",,,"""POP_RAND""",,(NY),Y
SUPPDM,QNAM,"""HLU_10116""n.CORE_PAT.POP_TREAT",,"QNAM=""ITTFL""","""POP_TREAT""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10116""n.CORE_PAT.POP_TREAT",,,"""POP_TREAT""",,(NY),Y
DM,RACE,"""HLU_10116""n.CORE_PAT.RACE",,,"""""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""HLU_10116""n.CORE_PAT.RACE_S",,,"""Patient Race, Other Description""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""HLU_10116""n.CORE_PAT.SEX",,,"""""",RecordQualifier,(SEX),Y
DM,ARMCD,"""HLU_10116""n.CORE_PAT.TREAT",,,"""Treatment Code""",RecordQualifier,(ARMCD),Y
QSMMSE,VISIT,"""HLU_10116""n.EFF_MMSE.ANALYSIS_DAY",,,"""Nominal or Window Day for Analysis""",Timing,(VIS),Y
QSMMSE,QSTESTCD,"""HLU_10116""n.EFF_MMSE.MMSE_A1",,"QSTESTCD=""MMS101""","""Time""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10116""n.EFF_MMSE.MMSE_A2",,"QSTESTCD=""MMS102""","""Place""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10116""n.EFF_MMSE.MMSE_B",,"QSTESTCD=""MMS103""","""Registration""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10116""n.EFF_MMSE.MMSE_C",,"QSTESTCD=""MMS104""","""Attention and Calculation""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10116""n.EFF_MMSE.MMSE_D",,"QSTESTCD=""MMS105""","""Recall""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10116""n.EFF_MMSE.MMSE_E1",,"QSTESTCD=""MMS106""","""Language - Naming""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10116""n.EFF_MMSE.MMSE_E2",,"QSTESTCD=""MMS107""","""Language - Repetition""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10116""n.EFF_MMSE.MMSE_E3",,"QSTESTCD=""MMS108""","""Language - Three-stage command""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10116""n.EFF_MMSE.MMSE_E4",,"QSTESTCD=""MMS109""","""Language - Reading""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10116""n.EFF_MMSE.MMSE_E5",,"QSTESTCD=""MMS110""","""Language - Writing""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10116""n.EFF_MMSE.MMSE_E6",,"QSTESTCD=""MMS111""","""Language - Copying""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10116""n.EFF_MMSE.MMSE_TOT",,"QSTESTCD=""MMS1TOT""","""MMSE Total CRF""",Topic,(MMSE),Y
DM,COUNTRY,"""HLU_10158""n.CORE_PAT.COUNTRY",,,"""Country Code""",RecordQualifier,(ISO3166),Y
SUPPDM,QNAM,"""HLU_10158""n.CORE_PAT.POP_FULL",,"QNAM=""FASFL""","""POP_FULL""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10158""n.CORE_PAT.POP_FULL",,,"""POP_FULL""",,(NY),Y
SUPPDM,QNAM,"""HLU_10158""n.CORE_PAT.POP_RAND",,"QNAM=""RANDFL""","""POP_RAND""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10158""n.CORE_PAT.POP_RAND",,,"""POP_RAND""",,(NY),Y
SUPPDM,QNAM,"""HLU_10158""n.CORE_PAT.POP_TREAT",,"QNAM=""ITTFL""","""POP_TREAT""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10158""n.CORE_PAT.POP_TREAT",,,"""POP_TREAT""",,(NY),Y
DM,RACE,"""HLU_10158""n.CORE_PAT.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""HLU_10158""n.CORE_PAT.RACE_S",,,"""Patient Race, Other Description""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""HLU_10158""n.CORE_PAT.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""HLU_10158""n.CORE_PAT.TREAT",,,"""Treatment Code""",RecordQualifier,(ARMCD),Y
QSMMSE,VISIT,"""HLU_10158""n.EFF_MMSE.ANALYSIS_DAY",,,"""Nominal or Window Day for Analysis""",Timing,(VIS),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_A1",,"QSTESTCD=""MMS101""","""MMSE Time""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_A1_1",,"QSTESTCD=""MMS101C""","""Time - Month""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_A1_2",,"QSTESTCD=""MMS101D""","""Time - Date""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_A1_3",,"QSTESTCD=""MMS101A""","""Time - Year""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_A1_4",,"QSTESTCD=""MMS101E""","""Time - Day of week""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_A1_5",,"QSTESTCD=""MMS101B""","""Time - season""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_A2",,"QSTESTCD=""MMS102""","""MMSE Place""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_A2_1",,"QSTESTCD=""MMS102A""","""Place - Province""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_A2_2",,"QSTESTCD=""MMS102C""","""Place - City""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_A2_3",,"QSTESTCD=""MMS102F""","""Place - Part of city""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_A2_4",,"QSTESTCD=""MMS102D""","""Place - Building""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_A2_5",,"QSTESTCD=""MMS102E""","""Place - Floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_B",,"QSTESTCD=""MMS103""","""MMSE Registration""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_B_1",,"QSTESTCD=""MMS103A""","""Registration - Apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_B_2",,"QSTESTCD=""MMS103C""","""Registration - Table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_B_3",,"QSTESTCD=""MMS103B""","""Registration - Penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_C",,"QSTESTCD=""MMS104""","""MMSE Attention and Calculation""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_C_1",,"QSTESTCD=""MMS104A""","""Attention and Calculation - Num1 (93) Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_C_2",,"QSTESTCD=""MMS104B""","""Attention and Calculation - Num2 (86) Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_C_3",,"QSTESTCD=""MMS104C""","""Attention and Calculation - Num3 (79) Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_C_4",,"QSTESTCD=""MMS104D""","""Attention and Calculation - Num4 (72) Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_C_5",,"QSTESTCD=""MMS104E""","""Attention and Calculation - Num5 (65) Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_D",,"QSTESTCD=""MMS105""","""MMSE Recall""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_D_1",,"QSTESTCD=""MMS105A""","""Recall - Apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_D_2",,"QSTESTCD=""MMS105C""","""Recall - Table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_D_3",,"QSTESTCD=""MMS105B""","""Recall - Penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_E1",,"QSTESTCD=""MMS106""","""Language - Naming""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_E1_1",,"QSTESTCD=""MMS106B""","""Language - naming - watch""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_E1_2",,"QSTESTCD=""MMS106A""","""Language - naming - pencil""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_E2",,"QSTESTCD=""MMS107""","""Language - Repetition""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_E3",,"QSTESTCD=""MMS108""","""Language - Three-stage command""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_E3_1",,"QSTESTCD=""MMS108A""","""Language - Three-stage command - Paper in right hand""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_E3_2",,"QSTESTCD=""MMS108B""","""Language - Three-stage command - Paper folded""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_E3_3",,"QSTESTCD=""MMS108C""","""Language - Three-stage command - Paper placed on floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_E4",,"QSTESTCD=""MMS109""","""Language - Reading""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_E5",,"QSTESTCD=""MMS110""","""Language - Writing""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_E6",,"QSTESTCD=""MMS111""","""Language - Copying""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10158""n.EFF_MMSE.MMSE_TOT",,"QSTESTCD=""MMS1TOT""","""MMSE Total, calculated""",Topic,(MMSE),Y
DM,COUNTRY,"""HLU_10252""n.CORE_PAT.COUNTRY",,,"""Country Code""",RecordQualifier,(ISO3166),Y
SUPPDM,QNAM,"""HLU_10252""n.CORE_PAT.POP_TREAT",,"QNAM=""ITTFL""","""POP_TREAT""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_10252""n.CORE_PAT.POP_TREAT",,,"""POP_TREAT""",,(NY),Y
DM,RACE,"""HLU_10252""n.CORE_PAT.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""HLU_10252""n.CORE_PAT.RACE_S",,,"""Patient Race, Other Description""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""HLU_10252""n.CORE_PAT.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""HLU_10252""n.CORE_PAT.TREAT",,,"""Treatment Code""",RecordQualifier,(ARMCD),Y
QSMMSE,VISIT,"""HLU_10252""n.EFF_MMSE.ANALYSIS_DAY",,,"""Nominal or Window Day for Analysis""",Timing,(VIS),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_A1",,"QSTESTCD=""MMS101""","""MMSE Time""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_A1_1",,"QSTESTCD=""MMS101C""","""Time - Month""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_A1_2",,"QSTESTCD=""MMS101D""","""Time - Date""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_A1_3",,"QSTESTCD=""MMS101A""","""Time - Year""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_A1_4",,"QSTESTCD=""MMS101E""","""Time - Day of week""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_A1_5",,"QSTESTCD=""MMS101B""","""Time - season""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_A2",,"QSTESTCD=""MMS102""","""MMSE Place""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_A2_1",,"QSTESTCD=""MMS102A""","""Place - Province""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_A2_2",,"QSTESTCD=""MMS102C""","""Place - City""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_A2_3",,"QSTESTCD=""MMS102F""","""Place - Part of city""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_A2_4",,"QSTESTCD=""MMS102D""","""Place - Building""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_A2_5",,"QSTESTCD=""MMS102E""","""Place - Floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_B",,"QSTESTCD=""MMS103""","""MMSE Registration""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_B_1",,"QSTESTCD=""MMS103A""","""Registration - Apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_B_2",,"QSTESTCD=""MMS103C""","""Registration - Table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_B_3",,"QSTESTCD=""MMS103B""","""Registration - Penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_C",,"QSTESTCD=""MMS104""","""MMSE Attention and Calculation""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_C_1",,"QSTESTCD=""MMS104A""","""Attention and Calculation - Num1 (93) Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_C_2",,"QSTESTCD=""MMS104B""","""Attention and Calculation - Num2 (86) Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_C_3",,"QSTESTCD=""MMS104C""","""Attention and Calculation - Num3 (79) Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_C_4",,"QSTESTCD=""MMS104D""","""Attention and Calculation - Num4 (72) Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_C_5",,"QSTESTCD=""MMS104E""","""Attention and Calculation - Num5 (65) Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_D",,"QSTESTCD=""MMS105""","""MMSE Recall""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_D_1",,"QSTESTCD=""MMS105A""","""Recall - Apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_D_2",,"QSTESTCD=""MMS105C""","""Recall - Table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_D_3",,"QSTESTCD=""MMS105B""","""Recall - Penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_E1",,"QSTESTCD=""MMS106""","""Language - Naming""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_E1_1",,"QSTESTCD=""MMS106B""","""Language - naming - watch""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_E1_2",,"QSTESTCD=""MMS106A""","""Language - naming - pencil""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_E2",,"QSTESTCD=""MMS107""","""Language - Repetition""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_E3",,"QSTESTCD=""MMS108""","""Language - Three-stage command""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_E3_1",,"QSTESTCD=""MMS108A""","""Language - Three-stage command - Paper in right hand""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_E3_2",,"QSTESTCD=""MMS108B""","""Language - Three-stage command - Paper folded""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_E3_3",,"QSTESTCD=""MMS108C""","""Language - Three-stage command - Paper placed on floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_E4",,"QSTESTCD=""MMS109""","""Language - Reading""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_E5",,"QSTESTCD=""MMS110""","""Language - Writing""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_E6",,"QSTESTCD=""MMS111""","""Language - Copying""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_10252""n.EFF_MMSE.MMSE_TOT",,"QSTESTCD=""MMS1TOT""","""MMSE total score, calculated""",Topic,(MMSE),Y
DM,COUNTRY,"""HLU_99679""n.CORE_PAT.COUNTRY",,,"""Country Code""",RecordQualifier,(ISO3166),Y
SUPPDM,QNAM,"""HLU_99679""n.CORE_PAT.POP_FULL",,"QNAM=""FASFL""","""POP_FULL""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_99679""n.CORE_PAT.POP_FULL",,,"""POP_FULL""",,(NY),Y
SUPPDM,QNAM,"""HLU_99679""n.CORE_PAT.POP_RAND",,"QNAM=""RANDFL""","""POP_RAND""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_99679""n.CORE_PAT.POP_RAND",,,"""POP_RAND""",,(NY),Y
SUPPDM,QNAM,"""HLU_99679""n.CORE_PAT.POP_TREAT",,"QNAM=""ITTFL""","""POP_TREAT""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_99679""n.CORE_PAT.POP_TREAT",,,"""POP_TREAT""",,(NY),Y
DM,RACE,"""HLU_99679""n.CORE_PAT.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""HLU_99679""n.CORE_PAT.RACE_S",,,"""Patient Race, Other Description""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""HLU_99679""n.CORE_PAT.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""HLU_99679""n.CORE_PAT.TREAT",,,"""Randomised Treatment""",RecordQualifier,(ARMCD),Y
QSADASCOG,QSTESTCD,"""HLU_99679""n.EFF_ACOG.ACOG_1",,"QSTESTCD=""ADCRL""","""ADAS-COG Word Recall""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99679""n.EFF_ACOG.ACOG_10",,"QSTESTCD=""ADCDIF""","""ADAS-COG Word Finding""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99679""n.EFF_ACOG.ACOG_11",,"QSTESTCD=""ADCRI""","""ADAS-COG Test Instructions""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99679""n.EFF_ACOG.ACOG_2",,"QSTESTCD=""ADCOF""","""ADAS-COG Objects and Figures""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99679""n.EFF_ACOG.ACOG_3",,"QSTESTCD=""ADCCMD""","""ADAS-COG Commands""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99679""n.EFF_ACOG.ACOG_4",,"QSTESTCD=""ADCCP""","""ADAS-COG Constructional Praxis""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99679""n.EFF_ACOG.ACOG_5",,"QSTESTCD=""ADCIP""","""ADAS-COG Ideational Praxis""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99679""n.EFF_ACOG.ACOG_6",,"QSTESTCD=""ADCOR""","""ADAS-COG Orientation""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99679""n.EFF_ACOG.ACOG_7",,"QSTESTCD=""ADCRG""","""ADAS-COG Word Recognition""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99679""n.EFF_ACOG.ACOG_8",,"QSTESTCD=""ADCSL""","""ADAS-COG Language""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99679""n.EFF_ACOG.ACOG_9",,"QSTESTCD=""ADCCMP""","""ADAS-COG Comprehension""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99679""n.EFF_ACOG.ACOG_TOT",,"QSTESTCD=""ADASTOT""","""ADAS-COG Total""",Topic,(ADCTC),Y
QSMMSE,VISIT,"""HLU_99679""n.EFF_MMSE.ANALYSIS_DAY",,,"""Nominal or Window Day for Analysis""",Timing,(VIS),Y
QSMMSE,QSTESTCD,"""HLU_99679""n.EFF_MMSE.MMSE_A1",,"QSTESTCD=""MMS101""","""MMSE Orientation Time""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99679""n.EFF_MMSE.MMSE_A2",,"QSTESTCD=""MMS102""","""MMSE Orientation Place""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99679""n.EFF_MMSE.MMSE_B",,"QSTESTCD=""MMS103""","""MMSE Registration""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99679""n.EFF_MMSE.MMSE_C",,"QSTESTCD=""MMS104""","""MMSE Attention""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99679""n.EFF_MMSE.MMSE_D",,"QSTESTCD=""MMS105""","""MMSE Recall""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99679""n.EFF_MMSE.MMSE_E1",,"QSTESTCD=""MMS106""","""Language - Naming""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99679""n.EFF_MMSE.MMSE_E2",,"QSTESTCD=""MMS107""","""Language - Repetition""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99679""n.EFF_MMSE.MMSE_E3",,"QSTESTCD=""MMS108""","""Language - Three-stage command""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99679""n.EFF_MMSE.MMSE_E4",,"QSTESTCD=""MMS109""","""Language - Reading""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99679""n.EFF_MMSE.MMSE_E5",,"QSTESTCD=""MMS110""","""Language - Writing""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99679""n.EFF_MMSE.MMSE_E6",,"QSTESTCD=""MMS111""","""Language - Copying""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99679""n.EFF_MMSE.MMSE_TOTAL_CRF",,"QSTESTCD=""MMS1TOT""","""MMSE Total CRF""",Topic,(MMSE),Y
DM,COUNTRY,"""HLU_99817""n.CORE_PAT.COUNTRY",,,"""Country Code""",RecordQualifier,(ISO3166),Y
SUPPDM,QNAM,"""HLU_99817""n.CORE_PAT.POP_FULL",,"QNAM=""FASFL""","""POP_FULL""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_99817""n.CORE_PAT.POP_FULL",,,"""POP_FULL""",,(NY),Y
SUPPDM,QNAM,"""HLU_99817""n.CORE_PAT.POP_RAND",,"QNAM=""RANDFL""","""POP_RAND""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_99817""n.CORE_PAT.POP_RAND",,,"""POP_RAND""",,(NY),Y
SUPPDM,QNAM,"""HLU_99817""n.CORE_PAT.POP_TREAT",,"QNAM=""ITTFL""","""POP_TREAT""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_99817""n.CORE_PAT.POP_TREAT",,,"""POP_TREAT""",,(NY),Y
DM,RACE,"""HLU_99817""n.CORE_PAT.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""HLU_99817""n.CORE_PAT.RACE_S",,,"""Patient Race, Other Description""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""HLU_99817""n.CORE_PAT.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""HLU_99817""n.CORE_PAT.TREAT",,,"""Treatment Code""",RecordQualifier,(ARMCD),Y
QSADASCOG,QSTESTCD,"""HLU_99817""n.EFF_ACOG.ACOG_1",,"QSTESTCD=""ADCRL""","""ADAS-COG Word Recall""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99817""n.EFF_ACOG.ACOG_10",,"QSTESTCD=""ADCDIF""","""ADAS-COG Word Finding""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99817""n.EFF_ACOG.ACOG_11",,"QSTESTCD=""ADCRI""","""ADAS-COG Test Instructions""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99817""n.EFF_ACOG.ACOG_2",,"QSTESTCD=""ADCOF""","""ADAS-COG Objects and Figures""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99817""n.EFF_ACOG.ACOG_3",,"QSTESTCD=""ADCCMD""","""ADAS-COG Commands""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99817""n.EFF_ACOG.ACOG_4",,"QSTESTCD=""ADCCP""","""ADAS-COG Constructional Praxis""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99817""n.EFF_ACOG.ACOG_5",,"QSTESTCD=""ADCIP""","""ADAS-COG Ideational Praxis""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99817""n.EFF_ACOG.ACOG_6",,"QSTESTCD=""ADCOR""","""ADAS-COG Orientation""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99817""n.EFF_ACOG.ACOG_7",,"QSTESTCD=""ADCRG""","""ADAS-COG Word Recognition""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99817""n.EFF_ACOG.ACOG_8",,"QSTESTCD=""ADCSL""","""ADAS-COG Language""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99817""n.EFF_ACOG.ACOG_9",,"QSTESTCD=""ADCCMP""","""ADAS-COG Comprehension""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99817""n.EFF_ACOG.ACOG_TOT",,"QSTESTCD=""ADASTOT""","""ADAS-COG Total""",Topic,(ADCTC),Y
QSMMSE,VISIT,"""HLU_99817""n.EFF_MMSE.ANALYSIS_DAY",,,"""Nominal or Window Day for Analysis""",Timing,(VIS),Y
QSMMSE,QSTESTCD,"""HLU_99817""n.EFF_MMSE.MMSE_A1",,"QSTESTCD=""MMS101""","""MMSE Orientation Time""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99817""n.EFF_MMSE.MMSE_A2",,"QSTESTCD=""MMS102""","""MMSE Orientation Place""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99817""n.EFF_MMSE.MMSE_B",,"QSTESTCD=""MMS103""","""MMSE Registration""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99817""n.EFF_MMSE.MMSE_C",,"QSTESTCD=""MMS104""","""MMSE Attention and Calculation""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99817""n.EFF_MMSE.MMSE_D",,"QSTESTCD=""MMS105""","""MMSE Recall""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99817""n.EFF_MMSE.MMSE_E1",,"QSTESTCD=""MMS106""","""Language - Naming""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99817""n.EFF_MMSE.MMSE_E2",,"QSTESTCD=""MMS107""","""Language - Repetition""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99817""n.EFF_MMSE.MMSE_E3",,"QSTESTCD=""MMS108""","""Language - Three-stage command""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99817""n.EFF_MMSE.MMSE_E4",,"QSTESTCD=""MMS109""","""Language - Reading""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99817""n.EFF_MMSE.MMSE_E5",,"QSTESTCD=""MMS110""","""Language - Writing""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99817""n.EFF_MMSE.MMSE_E6",,"QSTESTCD=""MMS111""","""Language - Copying""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99817""n.EFF_MMSE.MMSE_SCORE_CRF",,"QSTESTCD=""MMS1TOT""","""MMSE Total CRF""",Topic,(MMSE),Y
DM,COUNTRY,"""HLU_99819""n.CORE_PAT.COUNTRY",,,"""Country Code""",RecordQualifier,(ISO3166),Y
DM,RACE,"""HLU_99819""n.CORE_PAT.RACE",,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,"""HLU_99819""n.CORE_PAT.RACE_S",,,"""Patient Race, Other Description""",RecordQualifier,(ETHNIC),Y
DM,SEX,"""HLU_99819""n.CORE_PAT.SEX",,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,"""HLU_99819""n.CORE_PAT.TREAT",,,"""Randomised Treatment""",RecordQualifier,(ARMCD),Y
SUPPDM,QNAM,"""HLU_99819""n.CORE_PAT.pop_full",,"QNAM=""FASFL""","""""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_99819""n.CORE_PAT.pop_full",,,"""""",,(NY),Y
SUPPDM,QNAM,"""HLU_99819""n.CORE_PAT.pop_full_99679",,"QNAM=""FASFL""","""POP_FULL""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_99819""n.CORE_PAT.pop_full_99679",,,"""POP_FULL""",,(NY),Y
SUPPDM,QNAM,"""HLU_99819""n.CORE_PAT.pop_rand_99679",,"QNAM=""RANDFL""","""POP_RAND""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_99819""n.CORE_PAT.pop_rand_99679",,,"""POP_RAND""",,(NY),Y
SUPPDM,QNAM,"""HLU_99819""n.CORE_PAT.pop_treat",,"QNAM=""ITTFL""","""""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_99819""n.CORE_PAT.pop_treat",,,"""""",,(NY),Y
SUPPDM,QNAM,"""HLU_99819""n.CORE_PAT.pop_treat_99679",,"QNAM=""ITTFL""","""POP_TREAT""",,(POPINDC),Y
SUPPDM,QVAL,"""HLU_99819""n.CORE_PAT.pop_treat_99679",,,"""POP_TREAT""",,(NY),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_10",,"QSTESTCD=""ADCDIF01""","""10. Word finding difficulty""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_11",,"QSTESTCD=""ADCRI01""","""11. Remembering test instructions""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_1_1",,"QSTESTCD=""ADCRLT01""","""1. I Word Recall task Trial I""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_1_2",,"QSTESTCD=""ADCRLT02""","""1.II Word Recall task Trial II""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_1_3",,"QSTESTCD=""ADCRLT03""","""1.III Word Recall task Trial III""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_2_1",,"QSTESTCD=""ADCOF01""","""2. A. Objects""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_2_2",,"QSTESTCD=""ADCOF02""","""2. B. Fingers""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_3_B",,"QSTESTCD=""ADCCMD01""","""3. Commands - Make a fist""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_3_C",,"QSTESTCD=""ADCCMD02""","""3. Commands - Point to the ceiling/floor""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_3_D",,"QSTESTCD=""ADCCMD03""","""3. Commands - Pencil on top of the card/""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_3_E",,"QSTESTCD=""ADCCMD04""","""3. Commands - Watch on other side of pen""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_3_F",,"QSTESTCD=""ADCCMD05""","""3. Commands - Tap each shoulder twice""",Topic,(ADCTC),Y
QSADASCOG,QSSTAT,"""HLU_99819""n.EFF_ADASCOG.ADAS_4_A",,"if QSTESTCD in (""ADCCP01"",""ADCCP02"",""ADCCP03"",""ADCCP04"") and adas_4_a=1 then QSSTAT=""NOT DONE"";else if QSTESTCD in (""ADCCP01"",""ADCCP02"",""ADCCP03"",""ADCCP04"") and adas_4_b=1 then QSSTAT=""NOT DONE"";",,RecordQualifier,(ND),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_4_B",,"QSTESTCD=""ADCCP00B""","""4. Constr. - Pt. drew no forms...""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_4_C",,"QSTESTCD=""ADCCP01""","""4. Constr. - Circle""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_4_D",,"QSTESTCD=""ADCCP02""","""4. Constr. - Two overlapping rectangles""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_4_E",,"QSTESTCD=""ADCCP03""","""4. Constr. - Rhombus""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_4_F",,"QSTESTCD=""ADCCP04""","""4. Constr. - Cube""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_5_B",,"QSTESTCD=""ADCIP01""","""5. Ideat. - Fold a letter""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_5_C",,"QSTESTCD=""ADCIP02""","""5. Ideat. - Put letter in envelope""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_5_D",,"QSTESTCD=""ADCIP03""","""5. Ideat. - Seal envelope""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_5_E",,"QSTESTCD=""ADCIP04""","""5. Ideat. - Address envelope""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_5_F",,"QSTESTCD=""ADCIP05""","""5. Ideat. - Indicate where stamp goes""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_B",,"QSTESTCD=""ADCOR01""","""6. Orient - Full name""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_C",,"QSTESTCD=""ADCOR02""","""6. Orient - Month""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_D",,"QSTESTCD=""ADCOR03""","""6. Orient - Date""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_E",,"QSTESTCD=""ADCOR04""","""6. Orient - Year""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_F",,"QSTESTCD=""ADCOR05""","""6. Orient - Day""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_G",,"QSTESTCD=""ADCOR06""","""6. Orient - Season""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_H",,"QSTESTCD=""ADCOR07""","""6. Orient - Place""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_6_I",,"QSTESTCD=""ADCOR08""","""6. Orient - Time of day""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_7_1",,"QSTESTCD=""ADCRGT01""","""7. Word Recog - Trial I""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_7_2",,"QSTESTCD=""ADCRGT02""","""7. Word Recog. - Trial II""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_7_3",,"QSTESTCD=""ADCRGT03""","""7. Word Recog. - Trial III""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_8",,"QSTESTCD=""ADCSL01""","""8. Language""",Topic,(ADCTC),Y
QSADASCOG,QSTESTCD,"""HLU_99819""n.EFF_ADASCOG.ADAS_9",,"QSTESTCD=""ADCCMP01""","""9. Comprehension of spoken language""",Topic,(ADCTC),Y
QSMMSE,VISIT,"""HLU_99819""n.EFF_MMSE.ANALYSIS_DAY",,,"""Nominal or Window Day for Analysis""",Timing,(VIS),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_A1",,"QSTESTCD=""MMS101""","""Time""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_A1_1",,"QSTESTCD=""MMS101C""","""Time - Month""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_A1_2",,"QSTESTCD=""MMS101D""","""Time - Day""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_A1_3",,"QSTESTCD=""MMS101A""","""Time - Year""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_A1_4",,"QSTESTCD=""MMS101E""","""Time - Day of week""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_A1_5",,"QSTESTCD=""MMS101B""","""Time - season""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_A2",,"QSTESTCD=""MMS102""","""Place""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_A2_1",,"QSTESTCD=""MMS102A""","""Place - State""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_A2_2",,"QSTESTCD=""MMS102C""","""Place - City""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_A2_3",,"QSTESTCD=""MMS102F""","""Place - Part of city""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_A2_4",,"QSTESTCD=""MMS102D""","""Place - Building""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_A2_5",,"QSTESTCD=""MMS102E""","""Place - Floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_B",,"QSTESTCD=""MMS103""","""Registration""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_B_1",,"QSTESTCD=""MMS103A""","""Registration - Apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_B_2",,"QSTESTCD=""MMS103C""","""Registration - Table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_B_3",,"QSTESTCD=""MMS103B""","""Registration - Penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_C",,"QSTESTCD=""MMS104""","""Attention and Calculation""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_C_1",,"QSTESTCD=""MMS104A""","""Attention and Calculation - Num1 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_C_2",,"QSTESTCD=""MMS104B""","""Attention and Calculation - Num2 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_C_3",,"QSTESTCD=""MMS104C""","""Attention and Calculation - Num3 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_C_4",,"QSTESTCD=""MMS104D""","""Attention and Calculation - Num4 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_C_5",,"QSTESTCD=""MMS104E""","""Attention and Calculation - Num5 Correct""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_D",,"QSTESTCD=""MMS105""","""Recall""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_D_1",,"QSTESTCD=""MMS105A""","""Recall - Apple""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_D_2",,"QSTESTCD=""MMS105C""","""Recall - Table""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_D_3",,"QSTESTCD=""MMS105B""","""Recall - Penny""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_E1",,"QSTESTCD=""MMS106""","""Language - Naming""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_E1_1",,"QSTESTCD=""MMS106B""","""Language - naming - watch""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_E1_2",,"QSTESTCD=""MMS106A""","""Language - naming - pencil""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_E2",,"QSTESTCD=""MMS107""","""Language - Repetition""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_E3",,"QSTESTCD=""MMS108""","""Language - Three-stage command""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_E3_1",,"QSTESTCD=""MMS108A""","""Language - Three-stage command - Paper in right hand""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_E3_2",,"QSTESTCD=""MMS108B""","""Language - Three-stage command - paper folded""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_E3_3",,"QSTESTCD=""MMS108C""","""Language - Three-stage command - Paper placed on floor""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_E4",,"QSTESTCD=""MMS109""","""Language - Reading""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_E5",,"QSTESTCD=""MMS110""","""Language - Writing""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_E6",,"QSTESTCD=""MMS111""","""Language - Copying""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,"""HLU_99819""n.EFF_MMSE.MMSE_SCORE_CRF",,"QSTESTCD=""MMS1TOT""","""MMSE Total CRF""",Topic,(MMSE),Y
TA,ARMCD,CTRL.TA.ARMCD,,,,Topic,(ARMCD),Y
TA,DOMAIN,CTRL.TA.DOMAIN,,,,Identifier,(DOMAIN),Y
TA,ELEMENT,CTRL.TA.ELEMENT,,,,SynonymQualifier,(ELEMENT),Y
TA,EPOCH,CTRL.TA.EPOCH,,,,Timing,(EPOCH),Y
TA,ETCD,CTRL.TA.ETCD,,,,RecordQualifier,(ETCD),Y
TS,DOMAIN,CTRL.TS.DOMAIN,,,,Identifier,(DOMAIN),Y
TS,TSPARM,CTRL.TS.TSPARM,,,,SynonymQualifier,(TSPARM),Y
TS,TSPARMCD,CTRL.TS.TSPARMCD,,,,Topic,(TSPARMCD),Y
QSMMSE,QSTESTCD,MRZ_9403.CORE_PAT.B_MMSE,,"QSTESTCD=""MMS1TOT""","""Baseline/Screening MMSE Score""",Topic,(MMSE),Y
DM,COUNTRY,MRZ_9403.CORE_PAT.COUNTRY,,,"""Country Code""",RecordQualifier,(ISO3166),Y
SUPPDM,QNAM,MRZ_9403.CORE_PAT.POP_FULL,,"QNAM=""FASFL""","""Full Analysis Set""",,(POPINDC),Y
SUPPDM,QVAL,MRZ_9403.CORE_PAT.POP_FULL,,,"""Full Analysis Set""",,(NY),Y
SUPPDM,QNAM,MRZ_9403.CORE_PAT.POP_RAND,,"QNAM=""RANDFL""","""Randomised Set""",,(POPINDC),Y
SUPPDM,QVAL,MRZ_9403.CORE_PAT.POP_RAND,,,"""Randomised Set""",,(NY),Y
SUPPDM,QNAM,MRZ_9403.CORE_PAT.POP_TREAT,,"QNAM=""ITTFL""","""Treated Set""",,(POPINDC),Y
SUPPDM,QVAL,MRZ_9403.CORE_PAT.POP_TREAT,,,"""Treated Set""",,(NY),Y
DM,RACE,MRZ_9403.CORE_PAT.RACE,,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,MRZ_9403.CORE_PAT.RACE_S,,,"""Patient Race, Other Description""",RecordQualifier,(ETHNIC),Y
QSMMSE,VISIT,MRZ_9403.CORE_PAT.REF_MODULE,,,"""Dataset reference""",Timing,(VIS),Y
DM,SEX,MRZ_9403.CORE_PAT.SEX,,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,MRZ_9403.CORE_PAT.TREAT,,,"""Treatment Code""",RecordQualifier,(ARMCD),Y
DM,COUNTRY,MRZ_9605.CORE_PAT.COUNTRY,,,"""Country Code""",RecordQualifier,(ISO3166),Y
SUPPDM,QNAM,MRZ_9605.CORE_PAT.POP_FULL,,"QNAM=""FASFL""","""Full Analysis Set""",,(POPINDC),Y
SUPPDM,QVAL,MRZ_9605.CORE_PAT.POP_FULL,,,"""Full Analysis Set""",,(NY),Y
SUPPDM,QNAM,MRZ_9605.CORE_PAT.POP_RAND,,"QNAM=""RANDFL""","""Randomised Set""",,(POPINDC),Y
SUPPDM,QVAL,MRZ_9605.CORE_PAT.POP_RAND,,,"""Randomised Set""",,(NY),Y
SUPPDM,QNAM,MRZ_9605.CORE_PAT.POP_TREAT,,"QNAM=""ITTFL""","""Treated Set""",,(POPINDC),Y
SUPPDM,QVAL,MRZ_9605.CORE_PAT.POP_TREAT,,,"""Treated Set""",,(NY),Y
DM,RACE,MRZ_9605.CORE_PAT.RACE,,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,MRZ_9605.CORE_PAT.RACE_S,,,"""Patient Race, Other Description""",RecordQualifier,(ETHNIC),Y
DM,SEX,MRZ_9605.CORE_PAT.SEX,,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,MRZ_9605.CORE_PAT.TREAT,,,"""Treatment Code""",RecordQualifier,(ARMCD),Y
QSMMSE,VISIT,MRZ_9605.EFF_MMSE.ANALYSIS_DAY,,,"""Nominal or Window Day for Analysis""",Timing,(VIS),Y
QSMMSE,QSTESTCD,MRZ_9605.EFF_MMSE.MMSE_A1,,"QSTESTCD=""MMS101""","""MMSE Orientation Time""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,MRZ_9605.EFF_MMSE.MMSE_A2,,"QSTESTCD=""MMS102""","""MMSE Orientation Place""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,MRZ_9605.EFF_MMSE.MMSE_B,,"QSTESTCD=""MMS103""","""MMSE Registration""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,MRZ_9605.EFF_MMSE.MMSE_C,,"QSTESTCD=""MMS104""","""MMSE Attention""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,MRZ_9605.EFF_MMSE.MMSE_D,,"QSTESTCD=""MMS105""","""MMSE Recall""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,MRZ_9605.EFF_MMSE.MMSE_E1,,"QSTESTCD=""MMS106""","""MMSE Language - Naming""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,MRZ_9605.EFF_MMSE.MMSE_E2,,"QSTESTCD=""MMS107""","""MMSE Language - Repetition""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,MRZ_9605.EFF_MMSE.MMSE_E3,,"QSTESTCD=""MMS108""","""MMSE Language - Three-stage command""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,MRZ_9605.EFF_MMSE.MMSE_E4,,"QSTESTCD=""MMS109""","""MMSE Language - Reading""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,MRZ_9605.EFF_MMSE.MMSE_E5,,"QSTESTCD=""MMS110""","""MMSE Language - Writing""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,MRZ_9605.EFF_MMSE.MMSE_E6,,"QSTESTCD=""MMS111""","""MMSE Language - Copying""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,MRZ_9605.EFF_MMSE.MMSE_TOT,,"QSTESTCD=""MMS1TOT""","""MMSE Total Score""",Topic,(MMSE),Y
QSMMSE,QSTESTCD,MRZ_9901.CORE_PAT.B_MMSE,,"QSTESTCD=""MMS1TOT""","""Baseline/Screening MMSE Score""",Topic,(MMSE),Y
DM,COUNTRY,MRZ_9901.CORE_PAT.COUNTRY,,,"""Country Code""",RecordQualifier,(ISO3166),Y
SUPPDM,QNAM,MRZ_9901.CORE_PAT.POP_FULL,,"QNAM=""FASFL""","""Analysis Population - Full Analysis Set?""",,(POPINDC),Y
SUPPDM,QVAL,MRZ_9901.CORE_PAT.POP_FULL,,,"""Analysis Population - Full Analysis Set?""",,(NY),Y
SUPPDM,QNAM,MRZ_9901.CORE_PAT.POP_RAND,,"QNAM=""RANDFL""","""Analysis Population - Randomised Set?""",,(POPINDC),Y
SUPPDM,QVAL,MRZ_9901.CORE_PAT.POP_RAND,,,"""Analysis Population - Randomised Set?""",,(NY),Y
SUPPDM,QNAM,MRZ_9901.CORE_PAT.POP_TREAT,,"QNAM=""ITTFL""","""Analysis Population - Treated Set?""",,(POPINDC),Y
SUPPDM,QVAL,MRZ_9901.CORE_PAT.POP_TREAT,,,"""Analysis Population - Treated Set?""",,(NY),Y
DM,RACE,MRZ_9901.CORE_PAT.RACE,,,"""Patient Race""",RecordQualifier,(RACE),Y
DM,ETHNIC,MRZ_9901.CORE_PAT.RACE_S,,,"""Patient Race, Other Description""",RecordQualifier,(ETHNIC),Y
QSMMSE,VISIT,MRZ_9901.CORE_PAT.REF_MODULE,,,"""Dataset reference""",Timing,(VIS),Y
DM,SEX,MRZ_9901.CORE_PAT.SEX,,,"""Patient Sex""",RecordQualifier,(SEX),Y
DM,ARMCD,MRZ_9901.CORE_PAT.TREAT,,,"""Treatment Code""",RecordQualifier,(ARMCD),Y
DM,AGEU,SDTM.DM.AGEU,,"IF AGE^=. then AGEU=""YEARS"";","""Age Units""",VariableQualifier,(AGEU),Y
TV,DOMAIN,"proc sql; create table TV as  select distinct STUDYID,""TV"" as DOMAIN,VISITNUM,VISIT,VISITDY,""START OF VISIT"" as TVSTRL from sdtm.sv;quit;",,,,Identifier,(DOMAIN),Y
;;;;
run;

proc sql;
create table sv1 as
select a.* from _values_ a left join _assignments_ b
on a.origin=b.origin and a.column=b.column and a.originwhere=b.originwhere
where b.origin is missing;
quit;

and this is the log:

24         data WORK._ASSIGNMENTS_;
25           infile datalines dsd truncover;
26           input COLUMN:$32. VALUE:$32. ORIGIN:$1000. ORIGINWHERE:$1000.;
27         datalines4;

NOTE: The data set WORK._ASSIGNMENTS_ has 476 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.02 seconds
      
504        ;;;;

505        run;
506        
507        data WORK._VALUES_;
508          infile datalines dsd truncover;
509          input TABLE:$32. COLUMN:$32. ORIGIN:$1000. ORIGINWHERE:$1000. ALGORITHM:$1000. ORIGINDESCRIPTION:$1000. ROLE:$200.
509      ! TERM:$80. MAPSUBMITTED:$1.;
510        datalines4;

NOTE: The data set WORK._VALUES_ has 706 observations and 9 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.02 seconds
      
1217       ;;;;

1218       run;
1219       
1220       proc sql;
1221       create table sv1 as
1222       select a.* from _values_ a left join _assignments_ b
1223       on a.origin=b.origin and a.column=b.column and a.originwhere=b.originwhere
1224       where b.origin is missing;
2                                                          Das SAS System                              08:03 Tuesday, April 25, 2017

NOTE: Table WORK.SV1 created, with 230 rows and 9 columns.

1225       quit;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.08 seconds
      cpu time            0.06 seconds

voila, 230 observations.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX
0 Likes
alexdsa310
Obsidian | Level 7 alexdsa310
Obsidian | Level 7

Re: proc sql - help needed

Posted 04-25-2017 02:34 AM (497 views)  |   In reply to Kurt_Bremser

When i run this i get 230 as you get but for my data which is same i get 706. is it somethign with formats which i need to change?

0 Likes
alexdsa310
Obsidian | Level 7 alexdsa310
Obsidian | Level 7

Re: proc sql - help needed

Posted 04-25-2017 02:44 AM (493 views)  |   In reply to alexdsa310

Also if we use column then we will not get the rest of column variables which are in _values_ for ex: column=country.

These will not come on sv1.

0 Likes
Kurt_Bremser
Super User Kurt_Bremser
Super User

Re: proc sql - help needed

Posted 04-25-2017 02:55 AM (489 views)  |   In reply to alexdsa310
@alexdsa310 wrote:

When i run this i get 230 as you get but for my data which is same i get 706. is it somethign with formats which i need to change?

I copied your example data from the .sas files you attached. Different data will yield different results. We can only give you examples for code that works with example data. Adapting the logic of the code to your actual data will be your job in the long run.

Copy the complete code I used (including the data steps that create the datasets) and run it in your environment. If the result is different, post the log of all three steps. There might be a hint in there.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX
0 Likes
alexdsa310
Obsidian | Level 7 alexdsa310
Obsidian | Level 7

Re: proc sql - help needed

Posted 04-25-2017 04:29 AM (485 views)  |   In reply to Kurt_Bremser

Thanks kurt,

 

I will figure it out what is going wrong with my data. The one which you are using is giving same result as you mentioned.

 

Also column should not be kept as in _assignments_ there is only few columns and _values_ have more ex: country and these are not coming in the final dataset. 

0 Likes

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 22 replies
  • ‎04-20-2017 07:08 AM
  • 1746 views
  • 3 likes
  • 3 in conversation