Hello everyone, I have the below sample data. Have more records in original dataset. Just providing few of them.
data lb;
input subjid testcd blfl;
cards;
1 ALB .
1 ALB .
1 ALB .
1 ALB Y
1 ALB Y
1 ALP .
1 ALP .
1 ALP Y
2 ALB .
2 ALB .
2 ALB .
2 ALB Y
2 ALP Y
2 ALP Y
3 ALB Y
3 ALP Y
3 ALP Y
3 ALP Y
4 ALB .
4 ALB .
4 ALB .
4 ALB Y
4 ALP .
4 ALP .
4 ALP .
4 ALP Y
4 ALP Y
4 ALP Y
4 ALT Y
4 ALT Y
;
run;
WANT:
I would like to retrieve all the testcd records that have multiple blfl records per subject like below.
For example, in the selected highlighted records, all the records from the "ALB" testcd are inlcuded where there are multiple records for "BLFL".
If there is single records per subjid per parameter per blfl, it should NOT be considered.
Likewise, if there is single record per blfl, it should NOT be considered.
Please help me!
Thanks!
... View more