Data management

Accepted Solution Solved
Reply
Contributor
Posts: 67
Accepted Solution

Data management

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

 

 

 


Accepted Solutions
Solution
a week ago
Super User
Posts: 6,762

Re: Data management

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

 

data want;

set have;

retain b;

if a > b then b = a;

run;

View solution in original post


All Replies
Valued Guide
Posts: 564

Re: Data management

What have you tried so far?

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

grafik.png

 

You will want to look-up the retain statement.

Solution
a week ago
Super User
Posts: 6,762

Re: Data management

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

 

data want;

set have;

retain b;

if a > b then b = a;

run;

Contributor
Posts: 67

Re: Data management

Posted in reply to Astounding

Thanks for that ! It is a possibility !

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 61 views
  • 0 likes
  • 3 in conversation