conditional retain depends on amt values

[ger15xxhcker]

Hello!

This is my test table. I would have 3 questions.

ID   amt   

1   10

1   12

1   50

1   52

2   10 

2   11

2   13

3   60

3   65

3   120

1. If, after the first two occurrences, the difference is greater than 20% compared to the third one, then do one flg how can i do it?

2. Same table but I'd like to mark only if the amount fields do not change and always the same how can i do it?

3. Same table but I'd like to mark only if the amount fields always changeing. How can i do it?.(each is different)

ID   amt   

1   10

1   12

1   50

1   52

2   10 

2   11

2   13

3   60

3   65

3   120

1. eg:

new final table looks like:

Id flg

1 y

2 n

Thanks for your help!

[Patrick]

I can't find the two questions but just 3 requirements. What have you tried already?

May be post the code you've got already (even if not working), a data step reading the data and then show us the desired result.

[ger15xxhcker]

Thank you for your guidance! Unfortunately I don't know how to start with it 😕

data test;
 input id amt;
 datalines;
 1 5
 1 5
 1 106
 2 90
 2 100
 3 111
 3 111
 3 111
 3 111
 4 837
 4 838
 4 839
 ;
run;

data want01; /*01 after the first two occurrences, the difference is greater than 20% compared to the third one*/
 input id flg$;
 datalines;
 1 Y
 ;
run;
data want02; /*02 where the amt field is constant*/
 input id flg$;
 datalines;
 3 Y
 ;
run;
data want03; /*03 where the amt field always changeing*/
 input id flg$;
 datalines;
 2 Y
 4 Y
 ;
run;

Thanks for your reply!