topic Data management in SAS Programming

Data management

DoumbiaS — Tue, 10 Jul 2018 10:32:28 GMT

Hi to all,

Need kind mind about this :

Datahave :

input A @@;
cards;
1441.47 1465.15 1441.36 1360.16 1424.37 1387.12 1346.09 1333.36

Datawant :

input A B;
cards;
1441.47 1441.47
1465.15 1465.15
1441.36 1465.15
1360.16 1465.15
1424.37 1465.15
1387.12 1465.15
1346.09 1465.15
1333.36 1465.15

Where B is computed as : B= max ($A$1: A_n_) that is most greatest value of A since the first line.

Thanks.

B Regards

andreas_lds — Tue, 10 Jul 2018 11:24:43 GMT

What have you tried so far?

Posting code using the running-man-icon is recommended to preserve formatting and white-space.

You will want to look-up the retain statement.

Astounding — Tue, 10 Jul 2018 12:58:51 GMT

As long as your data set does not yet contain B:

data want;

set have;

retain b;

if a > b then b = a;

run;

DoumbiaS — Tue, 10 Jul 2018 14:01:53 GMT

Thanks for that ! It is a possibility !