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: 
hcbn
‎03-21-2019
  • 35 Posts
  • 1 Likes Given
  • 0 Solutions
  • 2 Likes Received

Data for rolling sum

by Obsidian | Level 7 in New SAS User
‎03-08-2019 11:33 AM
‎03-08-2019 11:33 AM
Hi   Input       Date dest_id qty Case_Qty 03Mar2019 12305 0 12 04Mar2019 12305 0 0 05Mar2019 12305 0 0 06Mar2019 12305 0 0 07Mar2019 12305 0 0 08Mar2019 12305 5 0 09Mar2019 12305 0 0 10Mar2019 12305 0 0 11Mar2019 12305 0 0 12Mar2019 12305 0 0 13Mar2019 12305 0 0 14Mar2019 12305 0 0 15Mar2019 12305 6 0 16Mar2019 12305 0 0 17Mar2019 12305 0 0 18Mar2019 12305 0 0 19Mar2019 12305 0 0 20Mar2019 12305 0 0 21Mar2019 12305 0 0 22Mar2019 12305 4 12 23Mar2019 12305 0 0 03Mar2019 12913 0 12 04Mar2019 12913 0 0 05Mar2019 12913 2 0 06Mar2019 12913 0 0 07Mar2019 12913 0 0 08Mar2019 12913 1 0 09Mar2019 12913 0 0 10Mar2019 12913 0 0 11Mar2019 12913 0 0 12Mar2019 12913 4 0 13Mar2019 12913 0 0 14Mar2019 12913 0 0 15Mar2019 12913 0 0 16Mar2019 12913 0 0 17Mar2019 12913 0 0 18Mar2019 12913 0 0 19Mar2019 12913 2 0 20Mar2019 12913 0 0 21Mar2019 12913 0 0 22Mar2019 12913 5 12 23Mar2019 12913 0 0    Output       Date dest_id qty FCQ 03Mar2019 12305 0 0 04Mar2019 12305 0 0 05Mar2019 12305 0 0 06Mar2019 12305 0 0 07Mar2019 12305 0 0 08Mar2019 12305 5 12 09Mar2019 12305 0 0 10Mar2019 12305 0 0 11Mar2019 12305 0 0 12Mar2019 12305 0 0 13Mar2019 12305 0 0 14Mar2019 12305 0 0 15Mar2019 12305 6 0 16Mar2019 12305 0 0 17Mar2019 12305 0 0 18Mar2019 12305 0 0 19Mar2019 12305 0 0 20Mar2019 12305 0 0 21Mar2019 12305 0 0 22Mar2019 12305 4 12 23Mar2019 12305 0 0 03Mar2019 12913 0 0 04Mar2019 12913 0 0 05Mar2019 12913 2 12 06Mar2019 12913 0 0 07Mar2019 12913 0 0 08Mar2019 12913 1 0 09Mar2019 12913 0 0 10Mar2019 12913 0 0 11Mar2019 12913 0 0 12Mar2019 12913 4 0 13Mar2019 12913 0 0 14Mar2019 12913 0 0 15Mar2019 12913 0 0 16Mar2019 12913 0 0 17Mar2019 12913 0 0 18Mar2019 12913 0 0 19Mar2019 12913 2 0 20Mar2019 12913 0 0 21Mar2019 12913 0 0 22Mar2019 12913 5 12 23Mar2019 12913 0 0 ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-07-2019 01:12 PM
‎03-07-2019 01:12 PM
You are the best ever. It is working like a clock. Thank you so much. I really appreciate your great help. ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-07-2019 12:49 PM
‎03-07-2019 12:49 PM
Logic is the same as the previous result but the data should start from the date we required? I am sorry. The Source did not change. Please, disregard the source. Please, look at the dates between the input and the output.   Input       dest_id source ScheduledArrivalDate qty 12305 88003 08Mar2019 5 12305 88003 09Mar2019 0 12305 88003 10Mar2019 0 12305 88003 11Mar2019 0 12305 88003 12Mar2019 0 12305 88003 13Mar2019 0 12305 88003 14Mar2019 0 12305 88003 15Mar2019 6 12305 88003 16Mar2019 0 12305 88003 17Mar2019 0 12305 88003 18Mar2019 0 12305 88003 19Mar2019 0 12305 88003 20Mar2019 0 12305 88003 21Mar2019 0 12305 88003 22Mar2019 4   DESIRED OUTPUT         dest_id source ScheduledArrivalDate qty     12305 88003 03Mar2019 0 It will start from 3/3/2019 12305 88003 04Mar2019 0     12305 88003 05Mar2019 0     12305 88003 06Mar2019 0     12305 88003 07Mar2019 0     12305 88003 08Mar2019 5 5 pcs correspond to qty as it was in the input 3/8/2019 12305 88003 09Mar2019 0     12305 88003 10Mar2019 0     12305 88003 11Mar2019 0     12305 88003 12Mar2019 0     12305 88003 13Mar2019 0     12305 88003 14Mar2019 0     12305 88003 15Mar2019 6     12305 88003 16Mar2019 0     12305 88003 17Mar2019 0     12305 88003 18Mar2019 0     12305 88003 19Mar2019 0     12305 88003 20Mar2019 0     12305 88003 21Mar2019 0     12305 88003 22Mar2019 4     12305 88003 23Mar2019 0 it will end 3/23/2019             ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-07-2019 12:18 PM
‎03-07-2019 12:18 PM
Date column should change based on the date range that I give. Please, look at the Input and the output. The date will start 03/03/2019 in the output because I want the output to start from 03/03/2019 and finish on 03/23/2019. However, qty should match the date in the input with the output. Input       dest_id source ScheduledArrivalDate qty 12305 88003 08Mar2019 5 12305 88003 09Mar2019 0 12305 88003 10Mar2019 0 12305 88003 11Mar2019 0 12305 88003 12Mar2019 0 12305 88003 13Mar2019 0 12305 88003 14Mar2019 0 12305 88003 15Mar2019 6 12305 88003 16Mar2019 0 12305 88003 17Mar2019 0 12305 88003 18Mar2019 0 12305 88003 19Mar2019 0 12305 88003 20Mar2019 0 12305 88003 21Mar2019 0 12305 88003 22Mar2019 4 12913 88012 05Mar2019 2 12913 88012 06Mar2019 0 12913 88012 07Mar2019 0 12913 88012 08Mar2019 1 12913 88012 09Mar2019 0 12913 88012 10Mar2019 0 12913 88012 11Mar2019 0 12913 88012 12Mar2019 4 12913 88012 13Mar2019 0 12913 88012 14Mar2019 0 12913 88012 15Mar2019 0 12913 88012 16Mar2019 0 12913 88012 17Mar2019 0 12913 88012 18Mar2019 0 12913 88012 19Mar2019 2 12913 88012 20Mar2019 0 12913 88012 21Mar2019 0 12913 88012 22Mar2019 5   dest_id source ScheduledArrivalDate qty 12305 87998 03Mar2019 0 12305 87999 04Mar2019 0 12305 88000 05Mar2019 0 12305 88001 06Mar2019 0 12305 88002 07Mar2019 0 12305 88003 08Mar2019 5 12305 88003 09Mar2019 0 12305 88003 10Mar2019 0 12305 88003 11Mar2019 0 12305 88003 12Mar2019 0 12305 88003 13Mar2019 0 12305 88003 14Mar2019 0 12305 88003 15Mar2019 6 12305 88003 16Mar2019 0 12305 88003 17Mar2019 0 12305 88003 18Mar2019 0 12305 88003 19Mar2019 0 12305 88003 20Mar2019 0 12305 88003 21Mar2019 0 12305 88003 22Mar2019 4 12305 88003 23Mar2019 0 12913 88010 03Mar2019 0 12913 88011 04Mar2019 0 12913 88012 05Mar2019 2 12913 88012 06Mar2019 0 12913 88012 07Mar2019 0 12913 88012 08Mar2019 1 12913 88012 09Mar2019 0 12913 88012 10Mar2019 0 12913 88012 11Mar2019 0 12913 88012 12Mar2019 4 12913 88012 13Mar2019 0 12913 88012 14Mar2019 0 12913 88012 15Mar2019 0 12913 88012 16Mar2019 0 12913 88012 17Mar2019 0 12913 88012 18Mar2019 0 12913 88012 19Mar2019 2 12913 88012 20Mar2019 0 12913 88012 21Mar2019 0 12913 88012 22Mar2019 5 12913 88012 23Mar2019 0 ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-07-2019 11:58 AM
‎03-07-2019 11:58 AM
@novinosrin    Can I ask a different question? Can I add date range into the data like this below? Date range is between  03/03/2019 and 03/23/2019. Input       dest_id source ScheduledArrivalDate qty 12305 88003 08Mar2019 5 12305 88003 09Mar2019 0 12305 88003 10Mar2019 0 12305 88003 11Mar2019 0 12305 88003 12Mar2019 0 12305 88003 13Mar2019 0 12305 88003 14Mar2019 0 12305 88003 15Mar2019 6 12305 88003 16Mar2019 0 12305 88003 17Mar2019 0 12305 88003 18Mar2019 0 12305 88003 19Mar2019 0 12305 88003 20Mar2019 0 12305 88003 21Mar2019 0 12305 88003 22Mar2019 4 12913 88012 05Mar2019 2 12913 88012 06Mar2019 0 12913 88012 07Mar2019 0 12913 88012 08Mar2019 1 12913 88012 09Mar2019 0 12913 88012 10Mar2019 0 12913 88012 11Mar2019 0 12913 88012 12Mar2019 4 12913 88012 13Mar2019 0 12913 88012 14Mar2019 0 12913 88012 15Mar2019 0 12913 88012 16Mar2019 0 12913 88012 17Mar2019 0 12913 88012 18Mar2019 0 12913 88012 19Mar2019 2 12913 88012 20Mar2019 0 12913 88012 21Mar2019 0 12913 88012 22Mar2019 5   DESIRED OUTPUT     dest_id source ScheduledArrivalDate qty 12305 87996 01Mar2019 0 12305 87997 02Mar2019 0 12305 87998 03Mar2019 0 12305 87999 04Mar2019 0 12305 88000 05Mar2019 0 12305 88001 06Mar2019 0 12305 88002 07Mar2019 0 12305 88003 08Mar2019 5 12305 88003 09Mar2019 0 12305 88003 10Mar2019 0 12305 88003 11Mar2019 0 12305 88003 12Mar2019 0 12305 88003 13Mar2019 0 12305 88003 14Mar2019 0 12305 88003 15Mar2019 6 12305 88003 16Mar2019 0 12305 88003 17Mar2019 0 12305 88003 18Mar2019 0 12305 88003 19Mar2019 0 12305 88003 20Mar2019 0 12305 88003 21Mar2019 0 12305 88003 22Mar2019 4 12305 88003 23Mar2019 0 12913 88010 03Mar2019 0 12913 88011 04Mar2019 0 12913 88012 05Mar2019 2 12913 88012 06Mar2019 0 12913 88012 07Mar2019 0 12913 88012 08Mar2019 1 12913 88012 09Mar2019 0 12913 88012 10Mar2019 0 12913 88012 11Mar2019 0 12913 88012 12Mar2019 4 12913 88012 13Mar2019 0 12913 88012 14Mar2019 0 12913 88012 15Mar2019 0 12913 88012 16Mar2019 0 12913 88012 17Mar2019 0 12913 88012 18Mar2019 0 12913 88012 19Mar2019 2 12913 88012 20Mar2019 0 12913 88012 21Mar2019 0 12913 88012 22Mar2019 5 12913 88012 23Mar2019 0 ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-07-2019 11:01 AM
2 Likes
‎03-07-2019 11:01 AM
2 Likes
@novinosrin  I appreciate your help. This is the first time for me to here and immediately my problem was resolved. ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-07-2019 10:51 AM
‎03-07-2019 10:51 AM
I do not know how to thank you. It is working excellent. Thank you so much. The code is working. I did your advice.    Proc sort data=work.daily_pln_arriv out= work.daily_pln_arriv; by dest_id ScheduledArrivalDate; run; data work.xxxx; set work.daily_pln_arriv;/*have*/ by dest_id; retain t; if first.dest_id then do; t=ScheduledArrivalDate;output;end; else do; format t temp2 ScheduledArrivalDate date9.; temp=qty; temp2=ScheduledArrivalDate; do ScheduledArrivalDate=t+1 to ScheduledArrivalDate-1; qty=0; output; end; qty=temp; ScheduledArrivalDate=temp2; output; t=ScheduledArrivalDate; end; drop t:; run; ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-07-2019 10:08 AM
‎03-07-2019 10:08 AM
I am really sorry that I took your time so much but this code also does not work. 1,2 and 3 obs are not working with code   dest_id source qty ScheduledArrivalDate 12305 88003 4 22Mar2019 12305 88003 6 15Mar2019 12305 88003 5 08Mar2019 12913 88012 1 08Mar2019 12913 88012 2 05Mar2019 12913 88012 0 06Mar2019 12913 88012 0 07Mar2019 12913 88012 0 08Mar2019 12913 88012 0 09Mar2019 12913 88012 0 10Mar2019 12913 88012 0 11Mar2019 ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-07-2019 09:42 AM
‎03-07-2019 09:42 AM
first 1 , 2 and 3 observation ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-07-2019 09:39 AM
‎03-07-2019 09:39 AM
Can you please look at 1,2,3? The code does not work for them   dest_id source qty ScheduledArrivalDate 1 12305 88003 5 08Mar2019 2 12305 88003 6 15Mar2019 3 12305 88003 4 22Mar2019 4 12913 88012 2 05Mar2019 5 12913 88012 0 06Mar2019 6 12913 88012 0 07Mar2019 7 12913 88012 1 08Mar2019 8 12913 88012 0 08Mar2019 9 12913 88012 0 09Mar2019 10 12913 88012 0 10Mar2019 11 12913 88012 0 11Mar2019 12 12913 88012 4 12Mar2019 13 12913 88012 0 13Mar2019 14 12913 88012 0 14Mar2019 15 12913 88012 0 15Mar2019 16 12913 88012 0 16Mar2019 17 12913 88012 0 17Mar2019 18 12913 88012 0 18Mar2019 19 12913 88012 0 19Mar2019 20 12913 88012 2 19Mar2019 21 12913 88012 0 20Mar2019 22 12913 88012 0 21Mar2019 23 12913 88012 5 22Mar2019 24 13690 88003 12 06Mar2019 25 13690 88003 0 07Mar2019 26 13690 88003 0 08Mar2019 27 13690 88003 0 09Mar2019 28 13690 88003 0 10Mar2019 29 13690 88003 0 11Mar2019 30 13690 88003 0 12Mar2019 31 13690 88003 12 13Mar2019 32 13827 88011 12 08Mar2019 33 13827 88011 0 09Mar2019 34 13827 88011 0 10Mar2019 35 13827 88011 0 11Mar2019 36 13827 88011 0 12Mar2019 37 13827 88011 0 13Mar2019 38 13827 88011 0 14Mar2019 39 13827 88011 12 15Mar2019 40 13827 88011 12 22Mar2019 41 15007 88011 12 08Mar2019 42 15007 88011 0 09Mar2019 43 15007 88011 0 10Mar2019 44 15007 88011 0 11Mar2019 45 15007 88011 0 12Mar2019 46 15007 88011 0 13Mar2019 47 15007 88011 0 14Mar2019 48 15007 88011 0 15Mar2019 49 15007 88011 0 16Mar2019 50 15007 88011 0 17Mar2019 51 15007 88011 0 18Mar2019 52 15007 88011 0 19Mar2019 53 15007 88011 0 20Mar2019 54 15007 88011 0 21Mar2019 55 15007 88011 12 22Mar2019 56 15211 88003 12 09Mar2019 57 15469 88012 12 12Mar2019 58 15469 88012 0 13Mar2019 59 15469 88012 0 14Mar2019 60 15469 88012 0 15Mar2019 61 15469 88012 0 16Mar2019 62 15469 88012 0 17Mar2019 63 15469 88012 0 18Mar2019 64 15469 88012 12 19Mar2019 65 15916 88003 12 15Mar2019 66 16355 88003 12 07Mar2019 67 16355 88003 0 08Mar2019 68 16355 88003 0 09Mar2019 69 16355 88003 0 10Mar2019 70 16355 88003 0 11Mar2019 71 16355 88003 0 12Mar2019 72 16355 88003 0 13Mar2019 73 16355 88003 0 14Mar2019 74 16355 88003 0 15Mar2019 75 16355 88003 0 16Mar2019 76 16355 88003 0 17Mar2019 77 16355 88003 0 18Mar2019 78 16355 88003 0 19Mar2019 79 16355 88003 0 20Mar2019 80 16355 88003 12 21Mar2019 ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-07-2019 12:14 AM
‎03-07-2019 12:14 AM
Thank you so much for your reply. The code is working but there are duplicate dates ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-07-2019 12:13 AM
‎03-07-2019 12:13 AM
The code Is working but multiple values   dest_id source qty seqnum ScheduledArrivalDate 12913 88012 2 1 05Mar2019 12913 88012 0 3 06Mar2019 12913 88012 0 3 07Mar2019 12913 88012 1 2 08Mar2019 12913 88012 0 3 08Mar2019 12913 88012 0 3 09Mar2019 12913 88012 0 3 10Mar2019 12913 88012 0 3 11Mar2019 12913 88012 4 3 12Mar2019 12913 88012 0 5 13Mar2019 12913 88012 0 5 14Mar2019 12913 88012 0 5 15Mar2019 12913 88012 0 5 16Mar2019 12913 88012 0 5 17Mar2019 12913 88012 0 5 18Mar2019 12913 88012 0 5 19Mar2019 12913 88012 2 4 19Mar2019 ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-07-2019 12:10 AM
‎03-07-2019 12:10 AM
This Is working but multiple dates     dest_id source qty seqnum ScheduledArrivalDate 12913 88012 2 1 05Mar2019 12913 88012 0 3 06Mar2019 12913 88012 0 3 07Mar2019 12913 88012 1 2 08Mar2019 12913 88012 0 3 08Mar2019 12913 88012 0 3 09Mar2019 12913 88012 0 3 10Mar2019 12913 88012 0 3 11Mar2019 12913 88012 4 3 12Mar2019 12913 88012 0 5 13Mar2019 12913 88012 0 5 14Mar2019 12913 88012 0 5 15Mar2019 12913 88012 0 5 16Mar2019 12913 88012 0 5 17Mar2019 12913 88012 0 5 18Mar2019 12913 88012 0 5 19Mar2019 12913 88012 2 4 19Mar2019 ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-06-2019 11:17 PM
‎03-06-2019 11:17 PM
Why do I keep receiving this error all the time? BY variables are not properly sorted on data set ... View more

Re: Date Range between date in the same column

by Obsidian | Level 7 in New SAS User
‎03-06-2019 06:20 PM
‎03-06-2019 06:20 PM
Some IDs have desired output some does not have.   dest_id source qty ScheduledArrivalDate 12305 88003 5 08Mar2019 12305 88003 6 15Mar2019 12305 88003 4 22Mar2019 12913 88012 2 05Mar2019 12913 88012 0 06Mar2019 12913 88012 0 07Mar2019 12913 88012 1 08Mar2019 12913 88012 0 08Mar2019 12913 88012 0 09Mar2019 12913 88012 0 10Mar2019 12913 88012 0 11Mar2019 12913 88012 4 12Mar2019 12913 88012 2 19Mar2019 12913 88012 5 22Mar2019 13690 88003 12 06Mar2019 13690 88003 12 13Mar2019 13827 88011 12 08Mar2019 13827 88011 12 15Mar2019 13827 88011 12 22Mar2019 15007 88011 12 08Mar2019 15007 88011 12 22Mar2019 15211 88003 12 09Mar2019 15469 88012 12 12Mar2019 15469 88012 0 13Mar2019 15469 88012 0 14Mar2019 15469 88012 0 15Mar2019 15469 88012 0 16Mar2019 15469 88012 0 17Mar2019 15469 88012 0 18Mar2019 15469 88012 12 19Mar2019 15916 88003 12 15Mar2019 16355 88003 12 07Mar2019 16355 88003 12 21Mar2019 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-21-2019 06:20 PM
Likes given to
View All
Likes from
View All
Quick links