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: 
Z_Lim
‎09-01-2015
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Help with coding

by Calcite | Level 5 in Mathematical Optimization, Discrete-Event Simulation, and OR
‎10-29-2013 09:52 PM
‎10-29-2013 09:52 PM
Hi Rob, Thanks for your help. I will give it a try. ... View more

Help with coding

by Calcite | Level 5 in Mathematical Optimization, Discrete-Event Simulation, and OR
‎10-29-2013 05:03 AM
‎10-29-2013 05:03 AM
Hi, I am trying to formulate this in SAS:     How should i code this?                       ... View more

Re: Help in SAS Program automation

by Calcite | Level 5 in SAS Programming
‎06-26-2012 12:28 AM
‎06-26-2012 12:28 AM
Hi Ksharp Thank you for the response. The Start time and end time is listed on the original data (column 7 and 8 respectively). Room number is on the last column. You might have to scroll to the right to see the figures. I would like to flag out the combination where the sum of their "Est amount" (column 2) is within the range of + or - $5000. Step 1 and 2 show the output that i would like to achieve. ... View more

Help in SAS Program automation

by Calcite | Level 5 in SAS Programming
‎06-25-2012 05:12 AM
‎06-25-2012 05:12 AM
Hi all I would need some help in writing a program to automate these steps: 1) Group client according to start & end time (if they overlapped, they will be group together) and the room number 2) Flag out the clients if their total sum of 'Est amount' is +/-$5000 - these could be of any combination within the group Below is a set of sample data and the outcome i would like to achieve. Thanks. Original Data client_id Est amount Max Play Avg. Play in_date out_date Start Time End Time timeplayed Room Number P1 33000 20000 5000 3/7/2012 3/7/2012 4:17:00 PM 6:34:00 PM 137 4444 P2 -30000 7000 2000 3/7/2012 3/7/2012 4:31:00 PM 6:16:00 PM 105 4444 P1 -233000 30000 15000 3/7/2012 3/7/2012 6:34:00 PM 7:55:00 PM 81 4444 P3 -50000 50000 50000 3/7/2012 3/7/2012 6:59:00 PM 7:00:00 PM 1 4444 P1 -47000 20000 10000 3/7/2012 3/7/2012 9:05:00 PM 9:48:00 PM 43 6789 P2 42000 25000 10000 3/7/2012 3/7/2012 9:24:00 PM 10:49:00 PM 85 6789 P4 8000 21000 8000 3/7/2012 3/7/2012 9:38:00 PM 10:55:00 PM 77 6789 Step 1 client_id Est amount Max Play Avg. Play in_date out_date Start Time End Time timeplayed Room Number Group 1 P1 33000 20000 5000 3/7/2012 3/7/2012 4:17:00 PM 6:34:00 PM 137 4444 P2 -30000 7000 2000 3/7/2012 3/7/2012 4:31:00 PM 6:16:00 PM 105 4444 Group 2 P1 -233000 30000 15000 3/7/2012 3/7/2012 6:34:00 PM 7:55:00 PM 81 4444 P3 -50000 50000 50000 3/7/2012 3/7/2012 6:59:00 PM 7:00:00 PM 1 4444 Group 3 P1 -47000 20000 10000 3/7/2012 3/7/2012 9:05:00 PM 9:48:00 PM 43 6789 P2 42000 25000 10000 3/7/2012 3/7/2012 9:24:00 PM 10:49:00 PM 85 6789 P4 8000 21000 8000 3/7/2012 3/7/2012 9:38:00 PM 10:55:00 PM 77 6789 Step 2 Combinations Flagged Group 1 P1 & P2 P1, P2 Group 2 P1 & P3 Group 3 P1 & P2 P1 & P2 P1 & P4 P1 & P2 & P4 P1 &P2 & P4 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links