topic Re: conditional retain debends on amt values in SAS Programming

conditional retain depends on amt values

ger15xxhcker — Wed, 17 Jul 2019 13:28:55 GMT

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!

Re: conditional retain debends on amt values

Patrick — Wed, 17 Jul 2019 13:24:46 GMT

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.

Re: conditional retain debends on amt values

ger15xxhcker — Wed, 17 Jul 2019 15:35:54 GMT

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!