Y' if subject had returned for at least one post-baseline efficacy assessment: FA.FAORRES is non-missing at anyone of post-baseline visits (Week 4, Week 8, Week 12) for FAOBJ - "Total Inflammatory Lesion Count" or FAOBJ - "Total Non-Inflammatory Lesion Count" or ZA.ZAORRES not missing where ZA.ZATESTCD is "IGA"; "N" if subject had either post-baseline visits but there were no lesion count data; Null for Screen Failures . how to derived flag.?
data fa;
length visit FAOBJ $200 ;
infile datalines dsd truncover;
input subjid $ visit $ visitnum FAOBJ$;
datalines;
0076,V1 Day 1_Baseline, 1, Total Inflammatory Lesion Count
0076,V2 Day 28, 3, Total Inflammatory Lesion Count
0076,V3 Day 56, 4, Total Inflammatory Lesion Count
0076,V4 Day 84_EOT_ET, 5, Total Inflammatory Lesion Count
0076,V4 Day 84_EOT_ET, 5 ,Total Non-Inflammatory Lesion Count
0092,V1 Day 1_Baseline,1,Total Inflammatory Lesion Count
0092,V1 Day 1_Baseline,1,Total Non-Inflammatory Lesion Count
0998,V1 Day 1_Baseline,1,Total Inflammatory Lesion Count
0998,V1 Day 1_Baseline,1,Total Non-Inflammatory Lesion Count
0998,V1 Day 1_Baseline,1,Total Inflammatory Lesion Count
0998,V1 Day 1_Baseline,1,Total Non-Inflammatory Lesion Count
0998,V1 Day 1_Baseline,1,Total Inflammatory Lesion Count
0998,V1 Day 1_Baseline,1,Total Non-Inflammatory Lesion Count
0297,V2 Day 28,3,Total Inflammatory Lesion Count
0297,V2 Day 28,3,Total Non-Inflammatory Lesion Count
0297,V3 Day 56,4,Total Inflammatory Lesion Count
0297,V3 Day 56,4,Total Non-Inflammatory Lesion Count
0297,V3 Day 56,4,Total Inflammatory Lesion Count
0297,V4 Day 84_EOT_ET,5,Total Non-Inflammatory Lesion Count
0490,V1 Day 1_Baseline,1,Total Inflammatory Lesion Count
0490,V1 Day 1_Baseline,1,Total Non-Inflammatory Lesion Count
0490,V2 Day 28,3,Total Inflammatory Lesion Count
0490,V2 Day 28,3,Total Non-Inflammatory Lesion Count
;
run;
data za;
length visit FAOBJ $200 ;
infile datalines dsd truncover;
input subjid $ visit $ visitnum TESTCD$;
datalines;
0076,V1 Day 1_Baseline, 1,IGA
0076,V2 Day 28, 3,IGA
0076,V3 Day 56, 4,IGA
0076,V4 Day 84_EOT_ET, 5, IGA
0076,V4 Day 84_EOT_ET, 5 ,IGA
0092,V1 Day 1_Baseline,1,IGA
0998,V1 Day 1_Baseline,1,IGA
0998,V1 Day 1_Baseline,1,IGA
0297,V1 Day 1_Baseline,1,IGA
0297,V2 Day 28,3,IGA
0297,V3 Day 56,4,IGA
0297,V4 Day 84_EOT_ET,5,IGA
0490,V1 Day 1_Baseline,1,IGA
0490,V2 Day 28,3,IGA
;
RUN;
This is clear as mud.
Please:
1. Format your text
2. Paste the code using either the running man icon or {i}.
3. Provide the expected output
4. Delete your duplicate post.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.