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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.