topic Re: proc sql - help needed in SAS Programming

proc sql - help needed

alexdsa310 — Thu, 20 Apr 2017 11:08:35 GMT

i am using the below step to get obs with origin which are not in _assignments_ and only present in _values_ but not able to get.

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;
quit;

I am not sure where i am wrong as i am using left join.

any help?

Re: proc sql - help needed

Kurt_Bremser — Thu, 20 Apr 2017 11:46:05 GMT

With a left join, you will always get all observations from the first table, and where a match is found in the other tables, their data will be added (left missing otherwise).

What you want might be achieved with

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
where b.origin is missing;
quit;

data sv1;
merge
  _values (in=a)
  _assignments (in=b keep=origin column)
;
by origin column;
if a and not b;
run;

(proper sorting required)

Re: proc sql - help needed

alexdsa310 — Thu, 20 Apr 2017 11:34:45 GMT

Thanks Kurt.

just a small clarification

does

where b_origin is missing;

in proc sql gives origin which is missing ?

i need if origin and column is present in both then i do not need that observation

Re: proc sql - help needed

Kurt_Bremser — Thu, 20 Apr 2017 11:48:17 GMT

When you do a left join on a condition, and no match is found from the right, then the variables from the "right" table will all be set to missing. If a match is found, the variable(s) used in the condition can not be missing, by definition.

Edit: your post called my attention to a typo I made (corrected in the meantime). The condition should be

where b.origin is missing;

Re: proc sql - help needed

alexdsa310 — Thu, 20 Apr 2017 11:54:19 GMT

Thanks once again kurt.

For my final clarification i will get only observations which will not have a common origin and column observations in both the datasets(which is what i need). i.e if i have same origin and column name in both of my datasets then i will ommit that record and only take records which has _values_ where origin and column are different and not present in _assignments_.

Sorry for this. its just for my understanding

Re: proc sql - help needed

Kurt_Bremser — Thu, 20 Apr 2017 12:22:09 GMT

If in doubt, do a test run and look at the results. If puzzled, inquire further.

(Maxim 4 from the Maxims of Maximally Efficient SAS Programmers).

Re: proc sql - help needed

ballardw — Thu, 20 Apr 2017 23:09:37 GMT

@Kurt_Bremser wrote:

If in doubt, do a test run and look at the results. If puzzled, inquire further.

(Maxim 4 from the Maxims of Maximally Efficient SAS Programmers).

@Kurt_Bremser do you have more for that list? My google-fu only returns the Mercenary list (which I strongly suspect was an inspiration to your response).

And now I need some Ovalqwik!

Re: proc sql - help needed

Kurt_Bremser — Fri, 21 Apr 2017 04:23:29 GMT

@ballardw wrote:

@Kurt_Bremser wrote:

If in doubt, do a test run and look at the results. If puzzled, inquire further.

(Maxim 4 from the Maxims of Maximally Efficient SAS Programmers).

@Kurt_Bremser do you have more for that list? My google-fu only returns the Mercenary list (which I strongly suspect was an inspiration to your response).

And now I need some Ovalqwik!

I already have more for that list, and I plan to release it here as an ongoing project, as I expect that many would have valid maxims to contribute. And you are, of course, completely right where the inspiration came from. Tagon's Toughs to the rescue!

Re: proc sql - help needed

Kurt_Bremser — Fri, 21 Apr 2017 07:05:28 GMT

A first draft of the MoMESP has been saved at https://communities.sas.com/t5/SAS-Communities-Library/Maxims-of-Maximally-Efficient-SAS-Programmers/ta-p/352068/message-revision/352068%3A2

Re: proc sql - help needed

alexdsa310 — Mon, 24 Apr 2017 11:16:46 GMT

Hi Kurt,

I tried the same but still facing problems as the variable origin has multiple observations and due the NULL condition it is removing all and i only want to remove if it is same with origin and column and originwhere.

Attached is the sample datasets.

Can you guide me if possible

Re: proc sql - help needed

Kurt_Bremser — Mon, 24 Apr 2017 11:57:13 GMT

These are not SAS datasets, but Excel spreadsheets. Use the macro from https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 to convert your example datasets into data steps for posting as text here.

Those data steps will preserve attributes (lengths, formats), and can be easily copied into SAS. MS Office files are often blocked by firewalls for security reasons.

Also post the code you used, and a quick representation of the expected result (no data step code needed there), as it differs from what you got with the code.

Re: proc sql - help needed

alexdsa310 — Mon, 24 Apr 2017 12:22:09 GMT

I am using the below code

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
where b.origin is missing;
quit;

i need only observations which are in _values_ and not in _assignments_. so if i have a common observation in bothe the datasets with origin,originwhere i do not need them.

Currently it is not working as there are multiple observations of origin with diffirent column and originwhere with the code.

Re: proc sql - help needed

Kurt_Bremser — Mon, 24 Apr 2017 12:59:53 GMT

So you just need originwhere as an additional condition for the join?

Re: proc sql - help needed

alexdsa310 — Mon, 24 Apr 2017 13:06:04 GMT

Yes, i tried adding it in and a.originwhere=b.originwhere but i get few observations which are in _assignments_ coming in my dataset

Re: proc sql - help needed

Kurt_Bremser — Mon, 24 Apr 2017 13:29:22 GMT

Which of the 230 observations you get with:

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;

should not be in the result dataset (just provide observation numbers)?

Re: proc sql - help needed

alexdsa310 — Mon, 24 Apr 2017 14:36:01 GMT

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

Re: proc sql - help needed

Kurt_Bremser — Mon, 24 Apr 2017 14:43:53 GMT

@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.

Re: proc sql - help needed

alexdsa310 — Mon, 24 Apr 2017 15:16:36 GMT

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

Re: proc sql - help needed

Kurt_Bremser — Tue, 25 Apr 2017 06:05:26 GMT

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.

Re: proc sql - help needed

alexdsa310 — Tue, 25 Apr 2017 06:34:15 GMT

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?