topic Re: Cumulative records in New SAS User

Cumulative records

RJY — Mon, 01 Apr 2019 03:33:15 GMT

Hello,

I am finding difficult to create cumulative records. Your valuable suggestions will be a great help.

Input data:

ID	sales	week
101	22	40
101	34	40
101	60	40
101	10	41
101	10	42
102	22	40
102	34	41
102	60	41
103	10	40
103	10	40
103	22	41
103	34	42

Required Output:

Id	sales	week	weekg
101	22	40	40-40
101	34	40	40-40
101	60	40	40-40
102	22	40	40-40
103	10	40	40-40
103	10	40	40-40
101	22	40	40-41
101	34	40	40-41
101	60	40	40-41
102	22	40	40-41
103	10	40	40-41
103	10	40	40-41
101	10	41	40-41
102	34	41	40-41
102	60	41	40-41
103	22	41	40-41
101	22	40	40-42
101	34	40	40-42
101	60	40	40-42
102	22	40	40-42
103	10	40	40-42
103	10	40	40-42
101	10	41	40-42
102	34	41	40-42
102	60	41	40-42
103	22	41	40-42
101	10	42	40-42
103	34	42	40-42

I tried with if condition records are getting over written. And, another options is with filter i have to split the data and append.

I am looking for simple solution. Thanks in advance.

Regards,

Re: Cumulative records

andreas_lds — Mon, 01 Apr 2019 06:15:31 GMT

Please post data in usable form. Also add a description of the logic you want applied.

Re: Cumulative records

ballardw — Mon, 01 Apr 2019 15:12:32 GMT

How many levels of "week" are you looking to use this way?

I don't see that as a "cumulative" anything as you are repeating individual values multiple times.

Something like this may be possible with a multilabel format but that could be somewhat fragile as we likely need to know much more about what you are actually doing with the "week" values.

Perhaps it may be better to describe what you would do with the resulting data set. Sometimes new SAS user try to translate a process from an existing one exactly step by step and are unaware of SAS tools that perform some fairly interesting thing using a different approach.