BookmarkSubscribeRSS Feed
teja5959
Fluorite | Level 6

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;

1 REPLY 1
ChrisNZ
Tourmaline | Level 20

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.

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 842 views
  • 0 likes
  • 2 in conversation