topic Re: SAS code help in New SAS User

SAS code help

rashmirao99 — Thu, 20 Feb 2020 13:39:30 GMT

Hi,

I need help with ADAM data ADLB. I need to create a flag variable:

The condition is: If a subject has 4 paramcd has 4 aval values which are same I need to flag the first record as Y. For eample:

paramcd aval Flag

alb 4 Y

alb 4

Hope this is clear.

Thanks

Rashmi.

Re: SAS code help

Kurt_Bremser — Thu, 20 Feb 2020 13:44:13 GMT

If you run this code:

data have;
input paramcd $ aval;
datalines;
alb 4
alb 4
alb 4
alb 4
xxx 1
xxx 2
xxx 2
xxx 2
xxx 2
xxx 2
yyy 1
yyy 2
yyy 3
yyy 2
yyy 2
yyy 2
yyy 3
zzz 1
zzz 2
zzz 2
zzz 3
zzz 2
zzz 2
zzz 2
zzz 3
zzz 3
zzz 3
zzz 3
;

which of the observations should be flagged "Y"?

Re: SAS code help

rashmirao99 — Thu, 20 Feb 2020 17:34:28 GMT

it should flag like this: it should flag only when all the values for paramcd are equal.

alb 4 Y
alb 4
alb 4
alb 4
xxx 1
xxx 2
xxx 2
xxx 2
xxx 2
xxx 2
yyy 1
yyy 2
yyy 3
yyy 2
yyy 2
yyy 2
yyy 3
zzz 1
zzz 2
zzz 2
zzz 3
zzz 2
zzz 2
zzz 2
zzz 3
zzz 3
zzz 3
zzz 3

Thanks.

Re: SAS code help

Kurt_Bremser — Mon, 24 Feb 2020 09:44:03 GMT

Then run this code, based on my earlier "have" dataset:

proc sql;
create table flag as
select
  paramcd,
  case
    when count(distinct aval) = 1
    then 'Y'
    else ' '
  end as flag
from have
group by paramcd
having flag = 'Y';
quit;

data want;
merge
  have
  flag
;
by paramcd;
if not first.paramcd then flag = ' ';
run;