Hi All   Require help in building the SAS logic.    Below is an example data and using the first 5 columns as inputs, needs to produce last 3 columns.   For both 15th Dec and 16th Dec, only two transactions should be considered for the logic. so the amount would be 200+50 = 250   for 15th Dec transaction: last 7 to 15 days means only first 4 rows fall into that category. Out of those 4 two are eliminated because their return dates (14th Dec and 12th Dec) fall into the category of return date <= transactiondate-2. Thanks for the help in advance.   AccountNo TransactionDate Amount ReturnFlag ReturnDate Last7days_to_15Days_Counts Last7days_to_15Days_Amount Last7days_to_15Days_Average 2 5-Dec-17 50 .         2 6-Dec-17 100 1 14-Dec-17       2 7-Dec-17 150 1 12-Dec-17       2 8-Dec-17 200 1 16-Dec-17       2 15-Dec-17 250 1 16-Dec-17 2 250 125 2 16-Dec-17 300 1 17-Dec-17 2 250 125 ... View more

Hi, I need help building this logic.   The input columns in a dataset are below:   DIM1 DIM2 DATETIME AMOUNT 71 1234 01JUN2017:00:15:10:000000 70 73 1234 01JUN2017:00:15:30:000000 20 74 1234 01JUN2017:00:17:18:000000 83 76 1234 01JUN2017:00:30:13:000000 80 77 1234 01JUN2017:00:30:13:000000 21 78 1234 01JUN2017:00:30:14:000000 25 80 1234 01JUN2017:00:31:09:000000 100 91 4567 01JUN2017:09:20:11:000000 687.5 91 4567 01JUN2017:09:20:11:000000 3750 22 5678 01JUN2017:09:18:59:000000 200 22 5678 01JUN2017:09:18:59:000000 200 22 5678 01JUN2017:09:18:59:000000 225 22 5678 01JUN2017:09:18:59:000000 175 22 5678 01JUN2017:09:18:59:000000 175 22 5678 01JUN2017:09:18:59:000000 175 65 6789 01JUN2017:05:45:22:000000 1014.02 66 6789 01JUN2017:05:45:22:000000 100 101 2346 01JUN2017:11:05:51:000000 1500 101 2346 01JUN2017:11:05:51:000000 1500 101 2346 01JUN2017:11:05:51:000000 1500 101 2346 01JUN2017:11:05:51:000000 1500 101 2346 01JUN2017:11:05:51:000000 1500 101 2346 01JUN2017:11:05:51:000000 1300 102 2346 01JUN2017:11:06:49:000000 1200 102 2346 01JUN2017:11:06:49:000000 1280 105 2346 01JUN2017:11:07:16:000000 1400   and I am expecting the output dataset as like below (with additional three variables with cumulative counts and amount created)   DIM1 DIM2 DATETIME AMOUNT AMOUNT CUMULATIVE COUNTS CUMULATIVE TXN COUNTS 71 1234 01JUN2017:00:15:10:000000 70 0 0 0 73 1234 01JUN2017:00:15:30:000000 20 70 1 1 74 1234 01JUN2017:00:17:18:000000 83 90 2 2 76 1234 01JUN2017:00:30:13:000000 80 173 3 3 77 1234 01JUN2017:00:30:13:000000 21 253 4 4 78 1234 01JUN2017:00:30:14:000000 25 274 5 5 80 1234 01JUN2017:00:31:09:000000 100 299 6 6 91 4567 01JUN2017:09:20:11:000000 687.5 0 0 0 91 4567 01JUN2017:09:20:11:000000 3750 0 0 0 22 5678 01JUN2017:09:18:59:000000 200 0 0 0 22 5678 01JUN2017:09:18:59:000000 200 0 0 0 22 5678 01JUN2017:09:18:59:000000 225 0 0 0 22 5678 01JUN2017:09:18:59:000000 175 0 0 0 22 5678 01JUN2017:09:18:59:000000 175 0 0 0 22 5678 01JUN2017:09:18:59:000000 175 0 0 0 65 6789 01JUN2017:05:45:22:000000 1014.02 0 0 0 66 6789 01JUN2017:05:45:22:000000 100 1014.02 1 1 101 2346 01JUN2017:11:05:51:000000 1500 0 0 0 101 2346 01JUN2017:11:05:51:000000 1500 0 0 0 101 2346 01JUN2017:11:05:51:000000 1500 0 0 0 101 2346 01JUN2017:11:05:51:000000 1500 0 0 0 101 2346 01JUN2017:11:05:51:000000 1500 0 0 0 101 2346 01JUN2017:11:05:51:000000 1300 0 0 0 102 2346 01JUN2017:11:06:49:000000 1200 8800 6 1 102 2346 01JUN2017:11:06:49:000000 1280 8800 6 1 105 2346 01JUN2017:11:07:16:000000 1400 11280 8 2   Thanks for the help. ... View more

Hi All,   Could you please help if there a SAS code to exactly replicate the GEODIST function? I want to calculate the distance using latitudes and longitudes but it should exactly replicate the outcome of GEODIST function for the same input of latitudes and longitudes. For ex: If Distance = geodist(32.5153, -92.1567, 32.53238, -92.07976, 'DM'); is giving 4.6443116482 I want to calculate it manually to get the same value 4.6443116482. Thanks a lot. ... View more

Hi,   I have two datasets and want to produce third dataset like mentioned below.   1st Dataset: key1 key2 101 901 101 902 101 903 101 904 101 905 102 801 102 802 102 803 102 804   2nd Dataset: key1 key3 key4 var1 var2 var3 var4 var5 varn 101 a1 b1 . . . . . . 101 a2 b2 . . . . . . 101 a3 b3 . . . . . . 102 a4 b4 . . . . . . 102 a5 b5 . . . . . . 102 a6 b6 . . . . . .   Desired output dataset:   key2 key1 key3 key4 var1 var2 var3 var4 var5 varn 901 101 a1 b1 . . . . . . 901 101 a2 b2 . . . . . . 901 101 a3 b3 . . . . . . 902 101 a1 b1 . . . . . . 902 101 a2 b2 . . . . . . 902 101 a3 b3 . . . . . . 903 101 a1 b1 . . . . . . 903 101 a2 b2 . . . . . . 903 101 a3 b3 . . . . . . 801 102 a4 b4 . . . . . . 801 102 a5 b5 . . . . . . 801 102 a6 b6 . . . . . . 802 102 a4 b4 . . . . . . 802 102 a5 b5 . . . . . . 802 102 a6 b6 . . . . . . 803 102 a4 b4 . . . . . . 803 102 a5 b5 . . . . . . 803 102 a6 b6 . . . . . . 804 102 a4 b4 . . . . . . 804 102 a5 b5 . . . . . . 804 102 a6 b6 . . . . . .   Thanks for your time and help. John ... View more

Hi, I have two input datasets and I want to create an output dataset like mentioned below. Thanks so much for your help and time.   1st input dataset: key1 key2 101 901 101 902 101 903 101 904 101 905 102 801 102 802 102 803 102 804   2nd Input Dataset: key1 key3 key4 var1 var2 var3 var4 var5 varn 101 a1 b1 . . . . . . 101 a2 b2 . . . . . . 101 a3 b3 . . . . . . 102 a4 b4 . . . . . . 102 a5 b5 . . . . . . 102 a6 b6 . . . . . .   Output dataset: key2 key1 key3 key4 var1 var2 var3 var4 var5 varn 901 101 a1 b1 . . . . . . 901 101 a2 b2 . . . . . . 901 101 a3 b3 . . . . . . 902 101 a1 b1 . . . . . . 902 101 a2 b2 . . . . . . 902 101 a3 b3 . . . . . . 903 101 a1 b1 . . . . . . 903 101 a2 b2 . . . . . . 903 101 a3 b3 . . . . . . 801 102 a4 b4 . . . . . . 801 102 a5 b5 . . . . . . 801 102 a6 b6 . . . . . . 802 102 a4 b4 . . . . . . 802 102 a5 b5 . . . . . . 802 102 a6 b6 . . . . . . 803 102 a4 b4 . . . . . . 803 102 a5 b5 . . . . . . 803 102 a6 b6 . . . . . . 804 102 a4 b4 . . . . . . 804 102 a5 b5 . . . . . . 804 102 a6 b6 . . . . . .   Thanks Again! John ... View more