Re: How to match merge columns and map the fields based on matching va...

Ravindra_ · Posted 08-27-2022 08:05 AM

I have a table that looks like below

Data d1;
infile datalines dsd; 
input 
Frequency : $17.
FrequencyN
Severity : $11.
SeverityN
Interference :$12.
InterferenceN
Composite
Paramcd : $7.
Combination :$3.
;
datalines;
Never,0,None,0,Not at all,0,0,PRO0117,FSI
Rarely,1,None,0,Not at all,0,0,PRO0117,FSI
Rarely,1,None,0,A little bit,1,1,PRO0117,FSI
Rarely,1,None,0,Somewhat,2,1,PRO0117,FSI
Rarely,1,None,0,Quite a bit,3,2,PRO0117,FSI
Rarely,1,None,0,Very Much,4,2,PRO0117,FSI
Rarely,1,Mild,1,Not at all,0,1,PRO0117,FSI
Rarely,1,Mild,1,A little bit,1,1,PRO0117,FSI
Rarely,1,Mild,1,Somewhat,2,1,PRO0117,FSI
Rarely,1,Mild,1,Quite a bit,3,2,PRO0117,FSI
Rarely,1,Mild,1,Very Much,4,2,PRO0117,FSI
Rarely,1,Moderate,2,Not at all,0,1,PRO0117,FSI
Rarely,1,Moderate,2,A little bit,1,2,PRO0117,FSI
Rarely,1,Moderate,2,Somewhat,2,2,PRO0117,FSI
Rarely,1,Moderate,2,Quite a bit,3,2,PRO0117,FSI
Rarely,1,Moderate,2,Very Much,4,3,PRO0117,FSI
Rarely,1,Severe,3,Not at all,0,2,PRO0117,FSI
Rarely,1,Severe,3,A little bit,1,2,PRO0117,FSI
Rarely,1,Severe,3,Somewhat,2,2,PRO0117,FSI
Rarely,1,Severe,3,Quite a bit,3,3,PRO0117,FSI
Rarely,1,Severe,3,Very Much,4,3,PRO0117,FSI
Rarely,1,Very Severe,4,Not at all,0,2,PRO0117,FSI
Rarely,1,Very Severe,4,A little bit,1,2,PRO0117,FSI
Rarely,1,Very Severe,4,Somewhat,2,3,PRO0117,FSI
Rarely,1,Very Severe,4,Quite a bit,3,3,PRO0117,FSI
Rarely,1,Very Severe,4,Very Much,4,3,PRO0117,FSI
Occasionally,2,None,0,Not at all,0,0,PRO0117,FSI
Occasionally,2,None,0,A little bit,1,1,PRO0117,FSI
Occasionally,2,None,0,Somewhat,2,1,PRO0117,FSI
Occasionally,2,None,0,Quite a bit,3,2,PRO0117,FSI
Occasionally,2,None,0,Very Much,4,2,PRO0117,FSI
Occasionally,2,Mild,1,Not at all,0,1,PRO0117,FSI
Occasionally,2,Mild,1,A little bit,1,1,PRO0117,FSI
Occasionally,2,Mild,1,Somewhat,2,1,PRO0117,FSI
Occasionally,2,Mild,1,Quite a bit,3,2,PRO0117,FSI
Occasionally,2,Mild,1,Very Much,4,2,PRO0117,FSI
Occasionally,2,Moderate,2,Not at all,0,2,PRO0117,FSI
Occasionally,2,Moderate,2,A little bit,1,2,PRO0117,FSI
Occasionally,2,Moderate,2,Somewhat,2,2,PRO0117,FSI
Occasionally,2,Moderate,2,Quite a bit,3,3,PRO0117,FSI
Occasionally,2,Moderate,2,Very Much,4,3,PRO0117,FSI
Occasionally,2,Severe,3,Not at all,0,2,PRO0117,FSI
Occasionally,2,Severe,3,A little bit,1,2,PRO0117,FSI
Occasionally,2,Severe,3,Somewhat,2,2,PRO0117,FSI
Occasionally,2,Severe,3,Quite a bit,3,3,PRO0117,FSI,
Occasionally,2,Severe,3,Very Much,4,3,PRO0117,FSI
Occasionally,2,Very Severe,4,Not at all,0,2,PRO0117,FSI
Occasionally,2,Very Severe,4,A little bit,1,2,PRO0117,FSI
Occasionally,2,Very Severe,4,Somewhat,2,3,PRO0117,FSI
Occasionally,2,Very Severe,4,Quite a bit,3,3,PRO0117,FSI
Occasionally,2,Very Severe,4,Very Much,4,3,PRO0117,FSI
Frequently,3,None,0,Not at all,0,1,PRO0117,FSI
Frequently,3,None,0,A little bit,1,1,PRO0117,FSI
Frequently,3,None,0,Somewhat,2,1,PRO0117,FSI
Frequently,3,None,0,Quite a bit,3,2,PRO0117,FSI
Frequently,3,None,0,Very Much,4,2,PRO0117,FSI
Frequently,3,Mild,1,Not at all,0,1,PRO0117,FSI
Frequently,3,Mild,1,A little bit,1,1,PRO0117,FSI,
Frequently,3,Mild,1,Somewhat,2,1,PRO0117,FSI
Frequently,3,Mild,1,Quite a bit,3,2,PRO0117,FSI
Frequently,3,Mild,1,Very Much,4,2,PRO0117,FSI
Frequently,3,Moderate,2,Not at all,0,2,PRO0117,FSI
Frequently,3,Moderate,2,A little bit,1,2,PRO0117,FSI
Frequently,3,Moderate,2,Somewhat,2,2,PRO0117,FSI
Frequently,3,Moderate,2,Quite a bit,3,3,PRO0117,FSI
Frequently,3,Moderate,2,Very Much,4,3,PRO0117,FSI
Frequently,3,Severe,3,Not at all,0,2,PRO0117,FSI
Frequently,3,Severe,3,A little bit,1,2,PRO0117,FSI
Frequently,3,Severe,3,Somewhat,2,3,PRO0117,FSI
Frequently,3,Severe,3,Quite a bit,3,3,PRO0117,FSI
Frequently,3,Severe,3,Very Much,4,3,PRO0117,FSI
Frequently,3,Very Severe,4,Not at all,0,2,PRO0117,FSI
Frequently,3,Very Severe,4,A little bit,1,2,PRO0117,FSI
Frequently,3,Very Severe,4,Somewhat,2,3,PRO0117,FSI
Frequently,3,Very Severe,4,Quite a bit,3,3,PRO0117,FSI
Frequently,3,Very Severe,4,Very Much,4,3,PRO0117,FSI
Almost Constantly,4,None,0,Not at all,0,1,PRO0117,FSI
Almost Constantly,4,None,0,A little bit,1,1,PRO0117,FSI
Almost Constantly,4,None,0,Somewhat,2,1,PRO0117,FSI
Almost Constantly,4,None,0,Quite a bit,3,2,PRO0117,FSI
Almost Constantly,4,None,0,Very Much,4,2,PRO0117,FSI
Almost Constantly,4,Mild,1,Not at all,0,1,PRO0117,FSI,
Almost Constantly,4,Mild,1,A little bit,1,1,PRO0117,FSI
Almost Constantly,4,Mild,1,Somewhat,2,2,PRO0117,FSI
Almost Constantly,4,Mild,1,Quite a bit,3,2,PRO0117,FSI
Almost Constantly,4,Mild,1,Very Much,4,3,PRO0117,FSI
Almost Constantly,4,Moderate,2,Not at all,0,2,PRO0117,FSI
Almost Constantly,4,Moderate,2,A little bit,1,2,PRO0117,FSI
Almost Constantly,4,Moderate,2,Somewhat,2,2,PRO0117,FSI
Almost Constantly,4,Moderate,2,Quite a bit,3,3,PRO0117,FSI
Almost Constantly,4,Moderate,2,Very Much,4,3,PRO0117,FSI
Almost Constantly,4,Severe,3,Not at all,0,2,PRO0117,FSI
Almost Constantly,4,Severe,3,A little bit,1,2,PRO0117,FSI
Almost Constantly,4,Severe,3,Somewhat,2,3,PRO0117,FSI
Almost Constantly,4,Severe,3,Quite a bit,3,3,PRO0117,FSI
Almost Constantly,4,Severe,3,Very Much,4,3,PRO0117,FSI
Almost Constantly,4,Very Severe,4,Not at all,0,2,PRO0117,FSI
Almost Constantly,4,Very Severe,4,A little bit,1,2,PRO0117,FSI
Almost Constantly,4,Very Severe,4,Somewhat,2,3,PRO0117,FSI
Almost Constantly,4,Very Severe,4,Quite a bit,3,3,PRO0117,FSI
Almost Constantly,4,Very Severe,4,Very Much,4,3,PRO0117,FSI
Never,0,None,0,,.,0,PRO0110, PRO0111,FS
Rarely,1,None,0,,.,1,PRO0110, PRO0111,FS
Rarely,1,Mild,1,,.,1,PRO0110, PRO0111,FS
Rarely,1,Moderate,2,,.,1,PRO0110, PRO0111,FS
Rarely,1,Severe,3,,.,2,PRO0110, PRO0111,FS
Rarely,1,Very Severe,4,,.,2,PRO0110, PRO0111,FS
Occasionally,2,None,0,,.,1,PRO0110, PRO0111,FS
Occasionally,2,Mild,1,,.,1,PRO0110, PRO0111,FS
Occasionally,2,Moderate,2,,.,2,PRO0110, PRO0111,FS
Occasionally,2,Severe,3,,.,2,PRO0110, PRO0111,FS
Occasionally,2,Very Severe,4,,.,2,PRO0110, PRO0111,FS
Frequently,3,None,0,,.,1,PRO0110, PRO0111,FS
Frequently,3,Mild,1,,.,1,PRO0110, PRO0111,FS
Frequently,3,Moderate,2,,.,2,PRO0110, PRO0111,FS
Frequently,3,Severe,3,,.,3,PRO0110, PRO0111,FS
Frequently,3,Very Severe,4,,.,3,PRO0110, PRO0111,FS
Almost Constantly,4,None,0,,.,1,PRO0110, PRO0111,FS
Almost Constantly,4,Mild,1,,.,1,PRO0110, PRO0111,FS
Almost Constantly,4,Moderate,2,,.,2,PRO0110, PRO0111,FS
Almost Constantly,4,Severe,3,,.,3,PRO0110, PRO0111,FS
Almost Constantly,4,Very Severe,4,,.,3,PRO0110, PRO0111,FS
,.,None,0,Not at all,0,0,PRO0108,SI
,.,Mild,1,Not at all,0,1,PRO0108,SI
,.,Mild,1,A little bit,1,1,PRO0108,SI
,.,Mild,1,Somewhat,2,1,PRO0108,SI
,.,Mild,1,Quite a bit,3,2,PRO0108,SI
,.,Mild,1,Very Much,4,2,PRO0108,SI
,.,Moderate,2,Not at all,0,1,PRO0108,SI
,.,Moderate,2,A little bit,1,1,PRO0108,SI
,.,Moderate,2,Somewhat,2,2,PRO0108,SI
,.,Moderate,2,Quite a bit,3,2,PRO0108,SI
,.,Moderate,2,Very Much,4,3,PRO0108,SI
,.,Severe,3,Not at all,0,1,PRO0108,SI
,.,Severe,3,A little bit,1,2,PRO0108,SI
,.,Severe,3,Somewhat,2,2,PRO0108,SI
,.,Severe,3,Quite a bit,3,3,PRO0108,SI
,.,Severe,3,Very Much,4,3,PRO0108,SI
,.,Very Severe,4,Not at all,0,2,PRO0108,SI
,.,Very Severe,4,A little bit,1,2,PRO0108,SI
,.,Very Severe,4,Somewhat,2,2,PRO0108,SI
,.,Very Severe,4,Quite a bit,3,3,PRO0108,SI
,.,Very Severe,4,Very Much,4,3,PRO0108,SI
Never,0,,.,Not at all,0,0,,FI
Rarely,1,,.,Not at all,0,1,,FI
Rarely,1,,.,A little bit,1,1,,FI
Rarely,1,,.,Somewhat,2,1,,FI
Rarely,1,,.,Quite a bit,3,2,,FI
Rarely,1,,.,Very Much,4,2,,FI
Occasionally,2,,.,Not at all,0,1,,FI
Occasionally,2,,.,A little bit,1,1,,FI
Occasionally,2,,.,Somewhat,2,1,,FI
Occasionally,2,,.,Quite a bit,3,2,,FI
Occasionally,2,,.,Very Much,4,2,,FI
Frequently,3,,.,Not at all,0,1,,FI
Frequently,3,,.,A little bit,1,1,,FI
Frequently,3,,.,Somewhat,2,2,,FI
Frequently,3,,.,Quite a bit,3,3,,FI
Frequently,3,,.,Very Much,4,3,,FI
Almost Constantly,4,,.,Not at all,0,1,,FI
Almost Constantly,4,,.,A little bit,1,1,,FI
Almost Constantly,4,,.,Somewhat,2,2,,FI
Almost Constantly,4,,.,Quite a bit,3,3,,FI
Almost Constantly,4,,.,Very Much,4,3,,FI
Never,0,,.,,.,0,PRO0116,F
Rarely,1,,.,,.,1,PRO0116,F
Occasionally,2,,.,,.,1,PRO0116,F
Frequently,3,,.,,.,2,PRO0116,F
Almost Constantly,4,,.,,.,3,PRO0116,F
,.,None,0,,.,0,PRO0102, PRO0104,S
,.,Mild,1,,.,1,PRO0102, PRO0104,S
,.,Moderate,2,,.,2,PRO0102, PRO0104,S
,.,Severe,3,,.,3,PRO0102, PRO0104,S
,.,Very Severe,4,,.,3,PRO0102, PRO0104,S
,.,,.,Not at all,0,0,,I
,.,,.,A little bit,1,1,,I
,.,,.,Somewhat,2,1,,I
,.,,.,Quite a bit,3,2,,I
,.,,.,Very Much,4,2,,I

;
run;

The above is the different combination of frequency, severity and interference that gives different values of final composite score.

I had merged this with my master dataset to get the composite value mapped but i have got many duplicate record issues and i am struggling to resolve this.

The master dataset looks like this

Data master;
infile datalines dsd; 
input 
USUBJID : $20.
TRTFL : $1.
AVISITN 
AVAL
AVALC : $10.
PARAMNN : F8.
PARAMCD : $8.
PARAM : $52.
;
datalines;
1280-0022-1036002001,Y,101,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,101,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,101,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,101,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,101,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,101,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,101,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,101,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,101,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,101,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,101,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,101,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,101,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1301,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1401,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,201,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,201,2,MILD,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1301,2,MILD,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1401,2,MILD,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,201,2,MILD,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1301,2,MILD,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1401,2,MILD,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,201,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,201,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,201,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,201,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,201,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,201,3,OCCASIONALLY,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1301,3,OCCASIONALLY,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1401,3,OCCASIONALLY,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,201,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,201,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,201,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,201,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1301,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1401,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,301,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,301,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,301,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,301,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,301,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,301,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,301,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,301,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,301,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,301,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,301,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,301,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,301,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1301,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1401,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,401,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,401,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,401,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,401,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,401,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,401,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,401,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,401,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,401,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,401,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,401,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,401,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,401,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1301,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1401,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,501,.,,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1301,.,,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1401,.,,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,501,.,,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1301,.,,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1401,.,,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,501,.,,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1301,.,,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1401,.,,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,501,.,,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1301,.,,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1401,.,,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,501,.,,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1301,.,,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1401,.,,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,501,.,,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1301,.,,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1401,.,,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,501,.,,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1301,.,,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1401,.,,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,501,.,,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1301,.,,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1401,.,,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,501,.,,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1301,.,,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1401,.,,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,501,.,,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1301,.,,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1401,.,,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,501,.,,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1301,.,,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1401,.,,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,501,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1301,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1401,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,501,.,,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1301,.,,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1401,.,,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,601,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,601,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,601,2,MILD,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1301,2,MILD,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1401,2,MILD,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,601,2,A LITTLE BIT,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1301,2,A LITTLE BIT,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1401,2,A LITTLE BIT,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,601,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,601,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,601,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,601,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,601,2,RARELY,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1301,2,RARELY,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1401,2,RARELY,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,601,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,601,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,601,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,601,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1301,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1401,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,701,.,,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1301,.,,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1401,.,,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,701,.,,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1301,.,,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1401,.,,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,701,.,,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1301,.,,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1401,.,,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,701,.,,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1301,.,,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1401,.,,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,701,.,,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1301,.,,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1401,.,,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,701,.,,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1301,.,,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1401,.,,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,701,.,,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1301,.,,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1401,.,,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,701,.,,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1301,.,,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1401,.,,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,701,.,,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1301,.,,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1401,.,,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,701,.,,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1301,.,,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1401,.,,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,701,.,,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1301,.,,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1401,.,,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,701,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1301,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1401,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,701,.,,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1301,.,,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1401,.,,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,801,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,801,2,MILD,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1301,2,MILD,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1401,2,MILD,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,801,3,MODERTATE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1301,3,MODERTATE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1401,3,MODERTATE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,801,2,A LITTLE BIT,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1301,2,A LITTLE BIT,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1401,2,A LITTLE BIT,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,801,2,RARELY,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1301,2,RARELY,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1401,2,RARELY,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,801,2,MILD,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1301,2,MILD,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1401,2,MILD,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,801,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,801,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,801,4,FREQUENTLY,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1301,4,FREQUENTLY,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1401,4,FREQUENTLY,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,801,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,801,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,801,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,801,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1301,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1401,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,901,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,901,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,901,2,MILD,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1301,2,MILD,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1401,2,MILD,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,901,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,901,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,901,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,901,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,901,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,901,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,901,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,901,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,901,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,901,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1301,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1401,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1001,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1001,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1001,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1001,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1001,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1001,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1001,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1001,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1001,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1001,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1001,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1001,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1001,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1301,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1401,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1101,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1101,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1101,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1101,.,,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1301,.,,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1401,.,,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1101,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1101,.,,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1301,.,,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1401,.,,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1101,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1101,.,,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1301,.,,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1401,.,,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1101,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1101,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1101,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1101,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1301,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1401,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1101,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1301,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1401,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1201,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,43,PRO0102S,"PRO-CTCAE Difficulty Swallowing (Severity)"
1280-0022-1036002001,Y,1201,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1301,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1401,1,NONE,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)"
1280-0022-1036002001,Y,1201,2,MILD,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1301,2,MILD,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1401,2,MILD,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)"
1280-0022-1036002001,Y,1201,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1301,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1401,1,NOT AT ALL,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)"
1280-0022-1036002001,Y,1201,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)"
1280-0022-1036002001,Y,1201,.,,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1301,.,,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1401,.,,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)"
1280-0022-1036002001,Y,1201,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)"
1280-0022-1036002001,Y,1201,.,,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1301,.,,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1401,.,,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)"
1280-0022-1036002001,Y,1201,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)"
1280-0022-1036002001,Y,1201,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1301,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1401,1,NEVER,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1201,.,,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1301,.,,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1401,.,,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1201,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1301,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1401,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1201,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1301,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1401,1,N,55,PRO0123P,"PRO-CTCAE Rash"

;
run;

Basically the requirement is we have a multiple combination of freq, sev and interference in dataset d1 and there is a corresponding composite score that goes with every combination and they were given in horizontal format and this does apply to all the subjects and with a matching paramcd and in master dataset we have got the similar fields severity, frequency and interference in vertical format, and by taking paramcd into consideration we need to match the severity, frequency and interference from both the datasets and if it matches then the composite score that is relevant to that particular match should come in master dataset.

I had initially did this manually by inputting every combination manually but somehow i got end up with duplicate records, i tried doing this by hash table but was not successful, I had also tried using transpose and then mapping with every combination based on the paramcd but not quite successful.

@Ksharp or anyone else is there any help i can get on this? thanks for taking time in reading this.

mkeintz · Posted 08-27-2022 06:06 PM

What do you expect your desired output dataset to look like? I have no idea.

It appears to me that MASTER is a file of 156 groups of 3-records each. Within each group, all 3 observations have the same values of every variable except AVISITN.

Also the last two obs within each group has AVISTN=1301, and 1401 respectively.

In addition, every group seems to belong to a collection of exactly 13 groups (13*3=39 obs). The first collection has AVISITN=101 as the first obs of each group. In the next collection, every one of the 13 groups starts with AVISITN=201. ... All the way to the last collection having 13 groups with first obs with AVISITN=1201

How are these 12 collections of 13 groups of 3 observations supposed to be matched with the 179 obs in D1?

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Tom · Posted 08-28-2022 12:16 AM

The above is the different combination of frequency, severity and interference that gives different values of final composite score.

Why do you have all of those other variables then?

I had merged this with my master dataset to get the composite value mapped but i have got many duplicate record issues and i am struggling to resolve this.

Show the code you used to "merge". Since the D1 dataset is uniquely defined by the three key variables you mentioned you should not get any increase in observations when merging with it.

How could you even attempt to merge with the other dataset (bad choice for a dataset name by the way) since is has none of the key variables needed to map to the composite score defined by the D1 dataset.

Tom · Posted 08-28-2022 12:33 AM

Are those text strings in one of the variables in the LARGE dataset supposed to somehow indicate that those observations contain the values for the FREQUENCY, SEVERITY, and INTERFERENCE variables in the smaller dataset?

1280-0022-1036002001,Y,701,.,,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1301,.,,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,1401,.,,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)"
1280-0022-1036002001,Y,701,.,,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1301,.,,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,1401,.,,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)"
1280-0022-1036002001,Y,701,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1301,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"
1280-0022-1036002001,Y,1401,.,,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)"

What about the ones that don't have them?

1280-0022-1036002001,Y,1001,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1301,1,N,55,PRO0123P,"PRO-CTCAE Rash"
1280-0022-1036002001,Y,1401,1,N,55,PRO0123P,"PRO-CTCAE Rash"

I suspect that you need to figure out how to convert that large dataset back into a more normal dataset where there are variables for SEVERITY, FREQUENCY and INTERFERENCE.

Then a simple data step MERGE will let you add the information from the D1 dataset.

Ravindra_ · Posted 08-28-2022 04:12 AM

exactly Tom, "LARGE dataset supposed to somehow indicate that those observations contain the values for the FREQUENCY, SEVERITY, and INTERFERENCE variables in the smaller dataset?"

What about the ones that don't have them? they should not map with the small dataset and they should remain the same.

Tom · Posted 08-28-2022 11:20 AM

So for the large dataset what are the key variables that indicate how to multiple observations should be combined into a single observation?

If looks like the primary identifier is USUBJID and that TRTFL is a subject level value. There is only one subject in your sample.

If looks like the primary identifiers for visits is UBSUBJID and AVISITN. There are 14 visits in your sample.

2175  proc sort data=have(keep=usubjid trtfl) out=subjects nodupkey;
2176    by usubjid;
2177  run;

NOTE: There were 468 observations read from the data set WORK.HAVE.
NOTE: 467 observations with duplicate key values were deleted.
NOTE: The data set WORK.SUBJECTS has 1 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds


2178
2179  proc sort data=have(keep=usubjid trtfl avisitn) out=visits nodupkey;
2180    by usubjid avisitn;
2181  run;

NOTE: There were 468 observations read from the data set WORK.HAVE.
NOTE: 454 observations with duplicate key values were deleted.
NOTE: The data set WORK.VISITS has 14 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

What is the next level in the hierarchy?

Tom · Posted 08-28-2022 11:49 AM

Transposing the values it not really that hard IF you understand your data.

Let's assume that you have some set of key variables that identify the group of values that go together.

Then make sure the data is sorted by those and process each group to create the three variables.

Since your existing dataset is too unwieldy to serve as a useful explanatory example code let's make up some clearer variable names. Say how a vertically structured dataset that consists of a group of subjects that each have one or more visits and got one or more multipart questions. So we might use variables named SUBJECT, VISIT, QUESTION, SUBQUESTION, VALUE to represent that data. Your problem is that it kind of looks like you mgiht have QUESTION and SUBQUESTION mashed up into one variable? But perhaps one of those other variables with the codes can be used to group the questions together? If not then add a step to tease out the question and subquestion from the text.

So now to reduce the dataset to one observation per question that has answers to the three subquestions as separate variables you might do something like:

data wider ;
   do until(last.question);
      set have;
      by subject visit quesiton ;
      if subquestion='SEVERITY' then SEVERITY=value;
      else if subquestion='FREQUENCY' then FREQUENCY=value;
      else if subquesiton='INTERFERENCE' then INTERFERENCE=value;  
   end;
   drop subquesiton value;
run;

Now you can sort D1 and WIDER by SEVERITY FREQUENCY INTERFERENCE and merge them to pull any lookup values from D1 and attach them to WIDER.

If you need to revert the result back the TALL structure then you will need to reverse the process, perhaps needing the define new values of the QUESTION/SUBQUESITON pair to be able to store the value of the variables pulled from D1 into the TALL structure.

How to match merge columns and map the fields based on matching values

Re: How to match merge columns and map the fields based on matching values

Re: How to match merge columns and map the fields based on matching values

Re: How to match merge columns and map the fields based on matching values

Re: How to match merge columns and map the fields based on matching values

Re: How to match merge columns and map the fields based on matching values

Re: How to match merge columns and map the fields based on matching values

Classroom Training Available!