topic Update value with criteria in New SAS User

Update value with criteria

cmemtsa — Thu, 08 Oct 2020 08:45:18 GMT

data T;
input ID L EXP;
Datalines;
1 1 10
1 2 10
1 2 20
1 3 30
2 1 10
2 1 10
2 2 60
3 2 60
;



data want;
set t;
by id;
if first.id and first.L > 1 then exp=. ;

run;

Hi,

in this sample I want to update exp to null in case that in every first ID the first L is >1 which is the case with ID = 3

Where is the mistake in the code?

Thanks for the help.

Re: Update value with criteria

Kurt_Bremser — Thu, 08 Oct 2020 08:51:31 GMT

A first. variable is only created for variables named in the BY statement, and it is boolean, meaning it will only take on the values 0 or 1.

Corrected code:

data want;
set t;
by id;
if first.id and L > 1 then exp = .;
run;

Re: Update value with criteria

cmemtsa — Thu, 08 Oct 2020 08:57:31 GMT

Thanks! That's correct.