topic Re: By Group processing in SAS Programming

By Group processing

himself — Fri, 07 May 2021 10:50:32 GMT

Hi,

I need help in the following by group processing, such for the same USUBJID, and have AVAL=0 then i need the final output have flag='Y', if that is not the case then populate flag='N'.

data create;
input usubjid $ aval;
cards;
12 1
12 4
12 0
12 2
13 2
13 5
13 6
13 4
13 0
14 5
14 7
14 8
;
run;

proc sort data=create;
  by usubjid aval;
run;

data check;
  set create;
  by usubjid aval;
	if first.usubjid and aval=0 then flag="Y";
run;

Re: By Group processing

PaigeMiller — Fri, 07 May 2021 10:54:51 GMT

This can be done using a RETAIN statement

data check;
    set create;
    by usubjid aval;
    if first.usubjid and aval=0 then flagg="Y"; 
    else flagg="N";
    retain flag;
    if first.usubjid then flag=flagg;
    drop flagg;
run;

Re: By Group processing

himself — Fri, 07 May 2021 11:22:35 GMT

Hi @PaigeMiller, thanks for the feedback, At some point i thought, the following will work fine,
data check1;
set create;
by usubjid aval;
retain flag;
if first.usubjid and aval=0 then flag="Y";
else flag="N";
run;

But what i have realised is that one must "if first.usubjid then flag=flagg;"

Re: By Group processing

FreelanceReinh — Fri, 07 May 2021 11:31:51 GMT

Hi @himself,

@himself wrote:
But what i have realised is that one must "if first.usubjid then flag=flagg;"

A second variable (flagg) can be used, but is not necessary:

data check;
set create;
by usubjid;
retain flag ' ';
if first.usubjid then flag=ifc(aval=0,'Y','N');
run;