cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
hcbn
Obsidian | Level 7 hcbn
Obsidian | Level 7

Data for rolling sum

Posted 03-08-2019 11:33 AM (1222 views)

Hi

 

Input   
Datedest_idqtyCase_Qty
03Mar201912305012
04Mar20191230500
05Mar20191230500
06Mar20191230500
07Mar20191230500
08Mar20191230550
09Mar20191230500
10Mar20191230500
11Mar20191230500
12Mar20191230500
13Mar20191230500
14Mar20191230500
15Mar20191230560
16Mar20191230500
17Mar20191230500
18Mar20191230500
19Mar20191230500
20Mar20191230500
21Mar20191230500
22Mar201912305412
23Mar20191230500
03Mar201912913012
04Mar20191291300
05Mar20191291320
06Mar20191291300
07Mar20191291300
08Mar20191291310
09Mar20191291300
10Mar20191291300
11Mar20191291300
12Mar20191291340
13Mar20191291300
14Mar20191291300
15Mar20191291300
16Mar20191291300
17Mar20191291300
18Mar20191291300
19Mar20191291320
20Mar20191291300
21Mar20191291300
22Mar201912913512
23Mar20191291300

 

 Output   
Datedest_idqtyFCQ
03Mar20191230500
04Mar20191230500
05Mar20191230500
06Mar20191230500
07Mar20191230500
08Mar201912305512
09Mar20191230500
10Mar20191230500
11Mar20191230500
12Mar20191230500
13Mar20191230500
14Mar20191230500
15Mar20191230560
16Mar20191230500
17Mar20191230500
18Mar20191230500
19Mar20191230500
20Mar20191230500
21Mar20191230500
22Mar201912305412
23Mar20191230500
03Mar20191291300
04Mar20191291300
05Mar201912913212
06Mar20191291300
07Mar20191291300
08Mar20191291310
09Mar20191291300
10Mar20191291300
11Mar20191291300
12Mar20191291340
13Mar20191291300
14Mar20191291300
15Mar20191291300
16Mar20191291300
17Mar20191291300
18Mar20191291300
19Mar20191291320
20Mar20191291300
21Mar20191291300
22Mar201912913512
23Mar20191291300
0 Likes
Reply
1 REPLY 1
ballardw
Super User ballardw
Super User

Re: Data for rolling sum

Posted 03-08-2019 01:56 PM (1202 views)  |   In reply to hcbn

Any rules involved in this description?

I really am not sure what you want to do.

I don't see any sum involved much less "rolling sum" in the title.

0 Likes
Reply

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Watch Mastering the WHERE Clause in PROC SQL on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎03-08-2019 11:33 AM
  • 1223 views
  • 0 likes
  • 2 in conversation