Solved: How to map few columns from a dataset to the whole dataset of the othe... - Page 2

Tom · Posted 08-19-2022 07:59 PM

The purpose of the POINT= option on the SET statement is to allow the data step to re-read the datasets multiple times.

The two loops iterate over the two input datasets. The NOBS= option of the SET statement is used to learn how many observations there are in each. Since you created N+1 copies of the data when there were N observations in the parameter table I had it loop from zero instead of from 1 to add those extra observations.

I put the loop over the parameter dataset on the outside to match how your example output was built. You could nest them the other way and generate the same data, just sorted in a different order.

In the inner loop it reads each observation from the main dataset. When the loop counter for parameter dataset is not zero then it is used to pull in that observation from the parameter data, which will overwrite the values for all of those variables that are common between the two datasets. Replacing so many variables with values read from another dataset would require much more code if they did not have the same name. That is also why it was important to make sure that the PARAMNN variable had the same name on both datasets and that the character variables had the same LENGTH.

The OUTPUT statement is needed to generate multiple observations since the data step only executes one iteration.

The STOP statement is needed because the normal stopping method will not work. Most data steps stop when they read past the end of the input (either input dataset or input text file). But because the POINT= is reading existing observations it will never try to read past the end of the input datasets.

Ravindra_ · Posted 08-20-2022 08:08 AM

Thanks a lot for sharing the knowledge Tom, i had saved this in my local drive for future use

Ravindra_ · Posted 08-21-2022 01:12 PM

@Tom please don't mind if i am asking too much on this thread as my following question as well comes under similar scenario i am putting my request in the same thread. I had used the output that was generated and created my desired output by merging with other dataset that i call as scoring dataset. I had hard coded most of my program using some proc transpose and manually entered the values to map every subject and visit to calculate the aval variable. let me provide more details on the dataset that i had used.

The below is my example dataset a.

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 below is my example dataset b.

Data b;
infile datalines dsd; 
input 
USUBJID	: $20.
TRT01PN	
TRTFL : $1.	
TRT01P : $13.	
AVISITN	
AVISIT	: $7.
AVAL	
AVALC	: $10.
ABLFL : $1.	
BASE	
CHG	
RANDFL	: $1.
PEPFL : $1.	
PARAMNN	
PARAMCD	: $8.
PARAM	: $52.
PARCAT5N	
PARCAT5	: $9.
PARCAT6N	
PARCAT6	: $4.
NFBSIVFL : $1.;
datalines;																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,3,NEVER,Y,1,.,Y,Y,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,1,NONE,Y,1,.,Y,Y,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,3,NEVER,Y,1,.,Y,Y,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,1,NONE,Y,1,.,Y,Y,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,105,C01_V01,1,NONE,Y,1,.,Y,Y,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,106,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)",5,PRO-CTCAE,1,ITEM,Y	
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,3,NEVER,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,3,NEVER,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,105,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,106,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,3,NEVER,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,3,NEVER,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,105,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,106,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y	
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,3,NEVER,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite))",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,3,NEVER,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,105,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,106,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y
;
run;

The below is my example final dataset.

Data out;
infile datalines dsd; 
input 

USUBJID : $20.
RANDFL : $1.
PEPFL
TRTFL : $1.
TRT01P : $20.
TRT01PN8
TRTPN
PARAMNN : F8.
PARAMCD : $8.
PARAM : $52.
PARAML
TYPEAE
AVISITN : BEST32.
AVISIT : $40.
VISLBL : $200.
AVAL : BEST32.
AVALC : $200.
AVALADJU : $200.
ABLFL : $1.
BASE : BEST32.
CHG
CHGWBFL
CHGWBFLN
MLDFL
SVRFL
NFBSIVFL
PARCAT5N : F8.
PARCAT5 : $9.
PARCAT6N : F8.
PARCAT6 : $10.
AVALOLD
BASEOLD
;
datalines;


1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,101,C01_V01,Baseline,0,NONE,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,201,C02_V01,Cycle 2,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,301,C03_V01,Cycle 3,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,401,C04_V01,Cycle 4,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,601,C06_V01,Cycle 6,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,801,C08_V01,Cycle 8,0,NONE,,,0,0,N,0,N,N,N,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,901,C09_V01,Cycle 9,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,1001,C10_V01,Cycle 10,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,1101,C11_V01,Cycle 11,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,1201,C12_V01,Cycle 12,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,1301,Max_Level,Max_Level,0,NONE,,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,43,PRO0102S,PRO-CTCAE Difficulty Swallowing (Severity),Difficulty Swallowing (02),Severity,1401,Max_Adjusted_Level,Max_Adjusted_Level,0,NONE,No worse than baseline,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,101,C01_V01,Baseline,0,NONE,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,201,C02_V01,Cycle 2,1,MILD,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,301,C03_V01,Cycle 3,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,401,C04_V01,Cycle 4,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,601,C06_V01,Cycle 6,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,801,C08_V01,Cycle 8,1,MILD,,,0,1,Y,1,Y,N,N,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,901,C09_V01,Cycle 9,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,1001,C10_V01,Cycle 10,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,1101,C11_V01,Cycle 11,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,1201,C12_V01,Cycle 12,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,1301,Max_Level,Max_Level,1,MILD,,,0,1,Y,1,Y,N,,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,44,PRO0104S,PRO-CTCAE Skin Cracking Corners Mouth (Severity),Skin Cracking Corners Mouth (04),Severity,1401,Max_Adjusted_Level,Max_Adjusted_Level,1,MILD,Mild/Moderate or Rarely/Occasionally or A little bit/Somewhat,,0,1,Y,1,Y,N,,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,101,C01_V01,Baseline,0,NONE,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,201,C02_V01,Cycle 2,1,MILD,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,301,C03_V01,Cycle 3,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,401,C04_V01,Cycle 4,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,601,C06_V01,Cycle 6,1,MILD,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,801,C08_V01,Cycle 8,2,MODERTATE,,,0,2,Y,1,Y,N,N,5,PRO-CTCAE,1,ITEM,3,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,901,C09_V01,Cycle 9,1,MILD,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,1001,C10_V01,Cycle 10,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,1101,C11_V01,Cycle 11,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,1201,C12_V01,Cycle 12,1,MILD,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,1301,Max_Level,Max_Level,2,MODERTATE,,,0,2,Y,1,Y,N,,5,PRO-CTCAE,1,ITEM,3,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,45,PRO0108S,PRO-CTCAE Decreased Appetite at Worst (Severity),Decreased Appetite at Worst (08),Severity,1401,Max_Adjusted_Level,Max_Adjusted_Level,2,MODERTATE,Mild/Moderate or Rarely/Occasionally or A little bit/Somewhat,,0,2,Y,1,Y,N,,5,PRO-CTCAE,1,ITEM,3,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,101,C01_V01,Baseline,0,NOT AT ALL,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,201,C02_V01,Cycle 2,0,NOT AT ALL,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,301,C03_V01,Cycle 3,0,NOT AT ALL,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,401,C04_V01,Cycle 4,0,NOT AT ALL,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,601,C06_V01,Cycle 6,1,A LITTLE BIT,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,801,C08_V01,Cycle 8,1,A LITTLE BIT,,,0,1,Y,1,Y,N,N,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,901,C09_V01,Cycle 9,0,NOT AT ALL,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,1001,C10_V01,Cycle 10,0,NOT AT ALL,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,1101,C11_V01,Cycle 11,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,1201,C12_V01,Cycle 12,0,NOT AT ALL,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,1301,Max_Level,Max_Level,1,A LITTLE BIT,,,0,1,Y,1,Y,N,,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,46,PRO0108I,PRO-CTCAE Decreased Appetite at Worst (Interference),Decreased Appetite at Worst (08),Interference,1401,Max_Adjusted_Level,Max_Adjusted_Level,1,A LITTLE BIT,Mild/Moderate or Rarely/Occasionally or A little bit/Somewhat,,0,1,Y,1,Y,N,,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,101,C01_V01,Baseline,0,NEVER,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,201,C02_V01,Cycle 2,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,301,C03_V01,Cycle 3,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,401,C04_V01,Cycle 4,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,601,C06_V01,Cycle 6,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,801,C08_V01,Cycle 8,1,RARELY,,,0,1,Y,1,Y,N,N,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,901,C09_V01,Cycle 9,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,1001,C10_V01,Cycle 10,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,1101,C11_V01,Cycle 11,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,1201,C12_V01,Cycle 12,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,1301,Max_Level,Max_Level,1,RARELY,,,0,1,Y,1,Y,N,,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,47,PRO0110F,PRO-CTCAE Vomiting (Frequency),Vomiting (10),Frequency,1401,Max_Adjusted_Level,Max_Adjusted_Level,1,RARELY,Mild/Moderate or Rarely/Occasionally or A little bit/Somewhat,,0,1,Y,1,Y,N,,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,101,C01_V01,Baseline,0,NONE,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,201,C02_V01,Cycle 2,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,301,C03_V01,Cycle 3,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,401,C04_V01,Cycle 4,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,601,C06_V01,Cycle 6,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,801,C08_V01,Cycle 8,1,MILD,,,0,1,Y,1,Y,N,N,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,901,C09_V01,Cycle 9,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,1001,C10_V01,Cycle 10,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,1101,C11_V01,Cycle 11,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,1201,C12_V01,Cycle 12,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,1301,Max_Level,Max_Level,1,MILD,,,0,1,Y,1,Y,N,,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,48,PRO0110S,PRO-CTCAE Vomiting (Severity),Vomiting (10),Severity,1401,Max_Adjusted_Level,Max_Adjusted_Level,1,MILD,Mild/Moderate or Rarely/Occasionally or A little bit/Somewhat,,0,1,Y,1,Y,N,,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,101,C01_V01,Baseline,0,NEVER,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,201,C02_V01,Cycle 2,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,301,C03_V01,Cycle 3,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,401,C04_V01,Cycle 4,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,601,C06_V01,Cycle 6,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,801,C08_V01,Cycle 8,0,NEVER,,,0,0,N,0,N,N,N,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,901,C09_V01,Cycle 9,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,1001,C10_V01,Cycle 10,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,1101,C11_V01,Cycle 11,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,1201,C12_V01,Cycle 12,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,1301,Max_Level,Max_Level,0,NEVER,,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,49,PRO0111F,PRO-CTCAE Heartburn (Frequency),Heartburn (11),Frequency,1401,Max_Adjusted_Level,Max_Adjusted_Level,0,NEVER,No worse than baseline,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,101,C01_V01,Baseline,0,NONE,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,201,C02_V01,Cycle 2,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,301,C03_V01,Cycle 3,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,401,C04_V01,Cycle 4,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,601,C06_V01,Cycle 6,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,801,C08_V01,Cycle 8,0,NONE,,,0,0,N,0,N,N,N,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,901,C09_V01,Cycle 9,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,1001,C10_V01,Cycle 10,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,1101,C11_V01,Cycle 11,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,1201,C12_V01,Cycle 12,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,1301,Max_Level,Max_Level,0,NONE,,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,50,PRO0111S,PRO-CTCAE Heartburn (Severity),Heartburn (11),Severity,1401,Max_Adjusted_Level,Max_Adjusted_Level,0,NONE,No worse than baseline,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,101,C01_V01,Baseline,0,NEVER,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,201,C02_V01,Cycle 2,2,OCCASIONALLY,,,0,2,Y,1,Y,N,Y,5,PRO-CTCAE,1,ITEM,3,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,301,C03_V01,Cycle 3,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,401,C04_V01,Cycle 4,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,601,C06_V01,Cycle 6,1,RARELY,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,1,ITEM,2,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,801,C08_V01,Cycle 8,3,FREQUENTLY,,,0,3,Y,1,Y,Y,N,5,PRO-CTCAE,1,ITEM,4,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,901,C09_V01,Cycle 9,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,1001,C10_V01,Cycle 10,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,1101,C11_V01,Cycle 11,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,1201,C12_V01,Cycle 12,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,1301,Max_Level,Max_Level,3,FREQUENTLY,,,0,3,Y,1,Y,Y,,5,PRO-CTCAE,1,ITEM,4,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,51,PRO0116F,PRO-CTCAE Diarrhoea (Frequency),Diarrhoea (16),Frequency,1401,Max_Adjusted_Level,Max_Adjusted_Level,3,FREQUENTLY,Severe/Very Severe or Frequently/Almost certainly or Quite a bit/Very much,,0,3,Y,1,Y,Y,,5,PRO-CTCAE,1,ITEM,4,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,101,C01_V01,Baseline,0,NEVER,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,201,C02_V01,Cycle 2,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,301,C03_V01,Cycle 3,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,401,C04_V01,Cycle 4,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,601,C06_V01,Cycle 6,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,801,C08_V01,Cycle 8,0,NEVER,,,0,0,N,0,N,N,N,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,901,C09_V01,Cycle 9,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,1001,C10_V01,Cycle 10,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,1101,C11_V01,Cycle 11,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,1201,C12_V01,Cycle 12,0,NEVER,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,1301,Max_Level,Max_Level,0,NEVER,,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,52,PRO0117F,PRO-CTCAE Pain in Abdomen (Frequency),Pain in Abdomen (17),Frequency,1401,Max_Adjusted_Level,Max_Adjusted_Level,0,NEVER,No worse than baseline,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,101,C01_V01,Baseline,0,NONE,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,201,C02_V01,Cycle 2,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,301,C03_V01,Cycle 3,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,401,C04_V01,Cycle 4,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,601,C06_V01,Cycle 6,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,801,C08_V01,Cycle 8,0,NONE,,,0,0,N,0,N,N,N,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,901,C09_V01,Cycle 9,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,1001,C10_V01,Cycle 10,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,1101,C11_V01,Cycle 11,0,NONE,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,1201,C12_V01,Cycle 12,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,1301,Max_Level,Max_Level,0,NONE,,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,53,PRO0117S,PRO-CTCAE Pain in Abdomen (Severity),Pain in Abdomen (17),Severity,1401,Max_Adjusted_Level,Max_Adjusted_Level,0,NONE,No worse than baseline,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,101,C01_V01,Baseline,0,NOT AT ALL,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,201,C02_V01,Cycle 2,0,NOT AT ALL,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,301,C03_V01,Cycle 3,0,NOT AT ALL,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,401,C04_V01,Cycle 4,0,NOT AT ALL,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,601,C06_V01,Cycle 6,0,NOT AT ALL,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,801,C08_V01,Cycle 8,0,NOT AT ALL,,,0,0,N,0,N,N,N,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,901,C09_V01,Cycle 9,0,NOT AT ALL,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,1001,C10_V01,Cycle 10,0,NOT AT ALL,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,1101,C11_V01,Cycle 11,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,1201,C12_V01,Cycle 12,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,1301,Max_Level,Max_Level,0,NOT AT ALL,,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,54,PRO0117I,PRO-CTCAE Pain in Abdomen (Interference),Pain in Abdomen (17),Interference,1401,Max_Adjusted_Level,Max_Adjusted_Level,0,NOT AT ALL,No worse than baseline,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,101,C01_V01,Baseline,0,N,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,201,C02_V01,Cycle 2,0,N,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,301,C03_V01,Cycle 3,0,N,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,401,C04_V01,Cycle 4,0,N,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,601,C06_V01,Cycle 6,0,N,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,1,ITEM,.,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,801,C08_V01,Cycle 8,0,N,,,0,0,N,0,N,N,N,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,901,C09_V01,Cycle 9,0,N,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,1001,C10_V01,Cycle 10,0,N,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,1101,C11_V01,Cycle 11,0,N,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,1201,C12_V01,Cycle 12,0,N,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,1301,Max_Level,Max_Level,0,N,,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,55,PRO0123P,PRO-CTCAE Rash,Rash (23),Presence/Absence,1401,Max_Adjusted_Level,Max_Adjusted_Level,0,N,No worse than baseline,,0,0,N,0,N,N,,5,PRO-CTCAE,1,ITEM,1,1
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,101,C01_V01,Baseline,0,,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,201,C02_V01,Cycle 2,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,301,C03_V01,Cycle 3,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,401,C04_V01,Cycle 4,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,601,C06_V01,Cycle 6,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,801,C08_V01,Cycle 8,0,,,,0,0,N,0,N,N,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,901,C09_V01,Cycle 9,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,1001,C10_V01,Cycle 10,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,1101,C11_V01,Cycle 11,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,1201,C12_V01,Cycle 12,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,1301,Max_Level,Max_Level,0,,,,0,0,N,0,N,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,60,PRO0102C,PRO-CTCAE Difficulty Swallowing (Composite),Difficulty Swallowing (02),Composite,1401,Max_Adjusted_Level,Max_Adjusted_Level,0,,No worse than baseline,,0,0,N,0,N,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,101,C01_V01,Baseline,0,,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,201,C02_V01,Cycle 2,1,,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,301,C03_V01,Cycle 3,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,401,C04_V01,Cycle 4,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,601,C06_V01,Cycle 6,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,801,C08_V01,Cycle 8,1,,,,0,1,Y,1,Y,N,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,901,C09_V01,Cycle 9,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,1001,C10_V01,Cycle 10,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,1101,C11_V01,Cycle 11,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,1201,C12_V01,Cycle 12,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,1301,Max_Level,Max_Level,1,,,,0,1,Y,1,Y,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,61,PRO0104C,PRO-CTCAE Skin Cracking Corners Mouth (Composite),Skin Cracking Corners Mouth (04),Composite,1401,Max_Adjusted_Level,Max_Adjusted_Level,1,,Mild/Moderate or Rarely/Occasionally or A little bit/Somewhat,,0,1,Y,1,Y,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,101,C01_V01,Baseline,0,,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,201,C02_V01,Cycle 2,1,,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,301,C03_V01,Cycle 3,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,401,C04_V01,Cycle 4,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,601,C06_V01,Cycle 6,1,,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,801,C08_V01,Cycle 8,1,,,,0,1,Y,1,Y,N,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,901,C09_V01,Cycle 9,1,,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,1001,C10_V01,Cycle 10,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,1101,C11_V01,Cycle 11,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,1201,C12_V01,Cycle 12,1,,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,1301,Max_Level,Max_Level,1,,,,0,1,Y,1,Y,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,62,PRO0108C,PRO-CTCAE Decreased Appetite at Worst (Composite),Decreased Appetite at Worst (08),Composite,1401,Max_Adjusted_Level,Max_Adjusted_Level,1,,Mild/Moderate or Rarely/Occasionally or A little bit/Somewhat,,0,1,Y,1,Y,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,101,C01_V01,Baseline,0,,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,201,C02_V01,Cycle 2,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,301,C03_V01,Cycle 3,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,401,C04_V01,Cycle 4,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,601,C06_V01,Cycle 6,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,801,C08_V01,Cycle 8,1,,,,0,1,Y,1,Y,N,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,901,C09_V01,Cycle 9,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,1001,C10_V01,Cycle 10,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,1101,C11_V01,Cycle 11,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,1201,C12_V01,Cycle 12,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,1301,Max_Level,Max_Level,1,,,,0,1,Y,1,Y,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,63,PRO0110C,PRO-CTCAE Vomiting (Composite),Vomiting (10),Composite,1401,Max_Adjusted_Level,Max_Adjusted_Level,1,,Mild/Moderate or Rarely/Occasionally or A little bit/Somewhat,,0,1,Y,1,Y,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,101,C01_V01,Baseline,0,,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,201,C02_V01,Cycle 2,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,301,C03_V01,Cycle 3,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,401,C04_V01,Cycle 4,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,601,C06_V01,Cycle 6,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,801,C08_V01,Cycle 8,0,,,,0,0,N,0,N,N,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,901,C09_V01,Cycle 9,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,1001,C10_V01,Cycle 10,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,1101,C11_V01,Cycle 11,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,1201,C12_V01,Cycle 12,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,1301,Max_Level,Max_Level,0,,,,0,0,N,0,N,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,64,PRO0111C,PRO-CTCAE Heartburn (Composite),Heartburn (11),Composite,1401,Max_Adjusted_Level,Max_Adjusted_Level,0,,No worse than baseline,,0,0,N,0,N,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,101,C01_V01,Baseline,0,,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,201,C02_V01,Cycle 2,1,,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,301,C03_V01,Cycle 3,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,401,C04_V01,Cycle 4,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,601,C06_V01,Cycle 6,1,,,,0,1,Y,1,Y,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,801,C08_V01,Cycle 8,2,,,,0,2,Y,1,Y,N,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,901,C09_V01,Cycle 9,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,1001,C10_V01,Cycle 10,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,1101,C11_V01,Cycle 11,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,1201,C12_V01,Cycle 12,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,1301,Max_Level,Max_Level,2,,,,0,2,Y,1,Y,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,65,PRO0116C,PRO-CTCAE Diarrhoea (Composite),Diarrhoea (16),Composite,1401,Max_Adjusted_Level,Max_Adjusted_Level,2,,Mild/Moderate or Rarely/Occasionally or A little bit/Somewhat,,0,2,Y,1,Y,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,101,C01_V01,Baseline,0,,,Y,0,.,,.,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,201,C02_V01,Cycle 2,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,301,C03_V01,Cycle 3,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,401,C04_V01,Cycle 4,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,501,C05_V01,Cycle 5,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,601,C06_V01,Cycle 6,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,701,C07_V01,Cycle 7,.,,,,0,.,,.,,,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,801,C08_V01,Cycle 8,0,,,,0,0,N,0,N,N,N,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,901,C09_V01,Cycle 9,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,1001,C10_V01,Cycle 10,0,,,,0,0,N,0,N,N,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,1101,C11_V01,Cycle 11,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,1201,C12_V01,Cycle 12,.,,,,0,.,,.,,,Y,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,1301,Max_Level,Max_Level,0,,,,0,0,N,0,N,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
1280-0022-1036002001,Y,Y,Y,Plc+Ev10+Ex25,99201000,2,66,PRO0117C,PRO-CTCAE Pain in Abdomen (Composite),Pain in Abdomen (17),Composite,1401,Max_Adjusted_Level,Max_Adjusted_Level,0,,No worse than baseline,,0,0,N,0,N,N,,5,PRO-CTCAE,4,COMPOSITE,.,.
;
run;

Can i know is there an efficient way to achieve this?

Basically the requirement over here is
(For all avisitn up to 1201 and paramcd type is not composite (severity, interference, frequency, presence/absence), AVAL= AVAOLD - 1;
For all avisitn up to 1201 and paramcd type is composite, AVAL based on scoring algorithm - located in Scoring_Table (dataset a))

Tom · Posted 08-21-2022 01:53 PM

I don't understand what you are actually trying to do. Using dataset names like A and B that don't give any context to what the data represents also does not help.

It looks to me like you might just want to create a multilabel format to handle the generation of any summaries where some observations can contribute to multiple summaries.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p1kkf0fl0y3yeon1qxyme7bp7hcn.htm

Or perhaps you are trying to score some data using multiple variables to indicate the combinations? Perhaps you want to use PROC SCORE?

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/statug/statug_score_gettingstarted.htm

Ravindra_ · Posted 08-21-2022 05:40 PM

Thanks for the reply Tom, sorry to say that proc factor and proc score did not helped me.

What actually i am looking for is there are categories in the scoring dataset called Frequency severity and interference, they have a specific scoring combination based on paramcd,

FSI means this paramcd is present in all three categories and some other paramcd's are present in only one or two categories.

for example for paramcd PRO0117 in the first, second and third row the values are as

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,

In the first row if all 3 categories are 0 then the composite is 0 and in the second row if Frequency is 1 and severity is o and Interference is 0 even then the composite is 0 and in the third row if the frequency is 1 and severity is 0 and interference is 1 then the composite is 1. The similar pattern of composite scoring is present in dataset b and based on the dataset a we need to map it on dataset b to get the accurate composite score.

So this dataset is a reference for us and i had not merged this to dataset b and instead of that i had mapped everything manually to get the composite score and calculate the further aval value analysis.

Here i was requesting if there any solution where we can avoid this manual process and map them with the dataset b. In the dataset a we have got scores represented in the horizontal format as a reference and this will be applied to any subject, but in dataset b the scoring variable is present in vertical format, so do you have a solution to do this automatically.

I hope i did not confused you, please let me know if you need any clarification from my end. thank you

ballardw · Posted 08-18-2022 03:55 PM

A question about this stuff:

Data d1;
infile datalines dsd; 
input parcat5 : $9. 
      parcat5n  
      parcat6 : $9.
      parcat6n  
      paramcd : $8.
      param : $49. 
      paramn;
datalines;
PRO-CTCAE,5,COMPOSITE,4,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",60
PRO-CTCAE,5,COMPOSITE,4,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",61	
PRO-CTCAE,5,COMPOSITE,4,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",62

;
run;

My impression just reading this, since I know absolutely nothing about your project, is that the Parcat5n, Parcat6n and Paramn values are codes that basically only mean the text of Parcat5, Parcat6 and Param. Is that in fact the case? If so, that means we only have about half the values to actually worry about and the text maybe belongs in a format and just the keep the code values for manipulating the data.

Also that D1 has apparently fewer variables then the one you called A in the original question, so still is not quite representative of the problem description.

Ravindra_ · Posted 08-18-2022 04:17 PM

Yes they are coded values, we can work further using them, i had posted the required output now, can you please check that and help me

Ravindra_ · Posted 08-18-2022 04:14 PM

the output should look like this as below

Data out;
infile datalines dsd; 
input 
USUBJID	: $20.
TRT01PN	
TRTFL : $1.	
TRT01P : $13.	
AVISITN	
AVISIT	: $7.
AVAL	
AVALC	: $10.
ABLFL : $1.	
BASE	
CHG	
RANDFL	: $1.
PEPFL : $1.	
PARAMNN	
PARAMCD	: $8.
PARAM	: $52.
PARCAT5N	
PARCAT5	: $9.
PARCAT6N	
PARCAT6	: $4.
NFBSIVFL : $1.;
datalines;																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,3,NEVER,Y,1,.,Y,Y,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,1,NONE,Y,1,.,Y,Y,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,3,NEVER,Y,1,.,Y,Y,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,1,NONE,Y,1,.,Y,Y,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,105,C01_V01,1,NONE,Y,1,.,Y,Y,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,106,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)",5,PRO-CTCAE,1,ITEM,Y	
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,3,NEVER,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,3,NEVER,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,105,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,106,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,3,NEVER,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,3,NEVER,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,105,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,106,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y	
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,3,NEVER,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite))",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,3,NEVER,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,105,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,106,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y
;
run;

Ravindra_ · Posted 08-18-2022 04:32 PM

the output should look like below

Data out;
infile datalines dsd; 
input 
USUBJID	: $20.
TRT01PN	
TRTFL : $1.	
TRT01P : $13.	
AVISITN	
AVISIT	: $7.
AVAL	
AVALC	: $10.
ABLFL : $1.	
BASE	
CHG	
RANDFL	: $1.
PEPFL : $1.	
PARAMNN	
PARAMCD	: $8.
PARAM	: $52.
PARCAT5N	
PARCAT5	: $9.
PARCAT6N	
PARCAT6	: $4.
NFBSIVFL : $1.;
datalines;																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,44,PRO0104S,"PRO-CTCAE Skin Cracking Corners Mouth (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,45,PRO0108S,"PRO-CTCAE Decreased Appetite at Worst (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,46,PRO0108I,"PRO-CTCAE Decreased Appetite at Worst (Interference)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,3,NEVER,Y,1,.,Y,Y,47,PRO0110F,"PRO-CTCAE Vomiting (Frequency)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,1,NONE,Y,1,.,Y,Y,48,PRO0110S,"PRO-CTCAE Vomiting (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,3,NEVER,Y,1,.,Y,Y,49,PRO0111F,"PRO-CTCAE Heartburn (Frequency)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,1,NONE,Y,1,.,Y,Y,50,PRO0111S,"PRO-CTCAE Heartburn (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,51,PRO0116F,"PRO-CTCAE Diarrhoea (Frequency)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,52,PRO0117F,"PRO-CTCAE Pain in Abdomen (Frequency)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,105,C01_V01,1,NONE,Y,1,.,Y,Y,53,PRO0117S,"PRO-CTCAE Pain in Abdomen (Severity)",5,PRO-CTCAE,1,ITEM,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,106,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,54,PRO0117I,"PRO-CTCAE Pain in Abdomen (Interference)",5,PRO-CTCAE,1,ITEM,Y	
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,3,NEVER,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,3,NEVER,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,105,C01_V01,1,NONE,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																					
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,106,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,60,PRO0102C,"PRO-CTCAE Difficulty Swallowing (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,3,NEVER,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,3,NEVER,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,105,C01_V01,1,NONE,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,106,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,61,PRO0104C,"PRO-CTCAE Skin Cracking Corners Mouth (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y	
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,101,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,102,C01_V01,3,NEVER,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite))",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,103,C01_V01,3,NEVER,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,104,C01_V01,3,NEVER,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,105,C01_V01,1,NONE,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y																						
1280-0022-1036002001,99201000,Y,Plc+Ev10+Ex25,106,C01_V01,4,NOT AT ALL,Y,1,.,Y,Y,62,PRO0108C,"PRO-CTCAE Decreased Appetite at Worst (Composite)",5,PRO-CTCAE,4,COMPOSITE,Y
;
run;

Reeza · Posted 08-19-2022 12:57 PM

Sorry, I'm not seeing/recognizing the pattern for the join 😞

Re: How to map few columns from a dataset to the whole dataset of the other with few similar variabl

Re: How to map few columns from a dataset to the whole dataset of the other with few similar variabl

Re: How to map few columns from a dataset to the whole dataset of the other with few similar variabl

Re: How to map few columns from a dataset to the whole dataset of the other with few similar variabl

Re: How to map few columns from a dataset to the whole dataset of the other with few similar variabl

Re: How to map few columns from a dataset to the whole dataset of the other with few similar variabl

Re: How to map few columns from a dataset to the whole dataset of the other with few similar variabl

Re: How to map few columns from a dataset to the whole dataset of the other with few similar variabl

Re: How to map few columns from a dataset to the whole dataset of the other with few similar variabl

Re: How to map few columns from a dataset to the whole dataset of the other with few similar variabl

SAS Innovate 2025: Save the Date

SAS Training: Just a Click Away