topic Re: help with sas code data step in SAS Programming

help with sas code data step

P_S_ — Mon, 24 Feb 2014 00:00:51 GMT

Hello,

I have a data set that has each instances of payments made by account_id.

Here is the sample data.

data test;

infile datalines;

input id $ payment date yymmdd10.;

format date yymmdd10.;

datalines;

1 20 2010-01-31

1 20 2010-02-28

1 40 2010-04-28

1 50 2010-07-02

2 40 2012-01-31

2 50 2012-02-28

2 10 2012-03-28

3 100 2013-02-20

3 200 2014-02-01

4 400 2011-01-31

5 50 2000-01-31

5 30 2001-02-28

6 10 2001-02-02

6 10 2001-03-03

6 10 2001-04-02

6 10 2001-05-03

;

run;

Now I need to keep the rows for each id, until the payment(cumulative payment) is greater than 70. So the final output will look like as follows.

1 20 2010-01-31

1 20 2010-02-28

1 40 2010-04-28

2 40 2012-01-31

2 50 2012-02-28

3 100 2013-02-20

4 400 2011-01-31

5 50 2000-01-31

5 30 2001-02-28

6 10 2001-02-02

6 10 2001-03-03

6 10 2001-04-02

6 10 2001-05-03

Thank you for the help in advance.

Re: help with sas code data step

art297 — Mon, 24 Feb 2014 00:16:30 GMT

Methinks this is the same question I just responded to. No?

Re: help with sas code data step

P_S_ — Tue, 25 Feb 2014 03:00:06 GMT

Yes you did . Thank you.

Re: help with sas code data step

vishal_prof_gmail_com — Tue, 25 Feb 2014 06:33:24 GMT

Hi,

Is the problem resolved? If yes can you share the solution?

Vishal

Re: help with sas code data step

P_S_ — Thu, 27 Feb 2014 05:15:58 GMT

Here is the link. https://communities.sas.com/thread/53243