DATA Step, Macro, Functions and more

Post-Baseline Efficacy Data Flag

Reply
Occasional Contributor
Posts: 15

Post-Baseline Efficacy Data Flag

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;

PROC Star
Posts: 2,318

Re: Post-Baseline Efficacy Data Flag

[ Edited ]

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.

Ask a Question
Discussion stats
  • 1 reply
  • 87 views
  • 0 likes
  • 2 in conversation