BookmarkSubscribeRSS Feed
hcbn
Obsidian | Level 7

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
1 REPLY 1
ballardw
Super User

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register 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.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 362 views
  • 0 likes
  • 2 in conversation