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: 
paulsud1
‎10-23-2019
  • 4 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: To count transactions happening every month with same amount.

by Calcite | Level 5 in SAS Programming
‎10-21-2019 03:04 AM
‎10-21-2019 03:04 AM
ID            Date              amt              Month    Month1(Desired Month) 2              30MAY2019  700               MAY      MAY 2              01JUL2019   700               JUL       JUN 2              30JUL2019   700               JUL       JUL 2              30AUG2019  700               AUG      AUG hypothesis I want to prove: for every ID there are 4 transactions with similar amount in 4 consecutive months (MAY,JUN,JUL,AUG).   now there are cases above, where for second observation where date is 01JUL2019 the month is JUL right? but I want to make it JUN. because the first observation is of 30MAY2019, so if date of next observation lies between -5DAYS <30JUN2019< +5DAYS, in this case 01JUL2019 falls in between this condition so the Month1 should be changed to JUN instead of  JULY.   Got my question? let me know. thanks. ... View more

To count transactions happening every month with same amount.

by Calcite | Level 5 in SAS Programming
‎10-21-2019 02:51 AM
‎10-21-2019 02:51 AM
Hi everyone, I am new in SAS and need help in below problem.   I have a dataset like this, EXCEPT the Expec_Month Column which is desired.   ID            Date              amt              Month    Month1 1              03MAY2019  1500             MAY      MAY 1              03JUN2019  1500            JUN        JUN 1              05JUL2019   1500             JUL       JUL 1              03AUG2019  1500             AUG      AUG 2              30MAY2019   700               MAY     MAY 2              01JUL2019    700               JUL      JUN 2              30JUL2019    700               JUL      JUL 2              30AUG2019   700               AUG     AUG 2              04MAY2019   1000             MAY     MAY 2              08JUN2019    1000            JUN      JUN 2              08JUL2019    1000             JUL      JUL 2              05AUG2019   1000             AUG     AUG 3              02MAY2019    500               MAY    MAY 3              02JUN2019     500              JUN     JUN 3              01JUL2019     500               JUL     JUL 3              31JUL2019     500               JUL     AUG   I want to find transactions happening every month with same trans amount.    ID            Date                amt             Month    Month1 2              30MAY2019   700               MAY     MAY 2              01JUL2019    700               JUL      JUN   for cases like this above, if Date is 30MAY2019 then the Month = MAY now if the next Date of the same customer with similar amt lies in between +-5 days then the transaction month needs to be updated like here next Date is 01JUL2019 falling in between +-5 days of 30MAY2019, so Month1 = JUN not JULY   AND my desired final output would be like this   ID     Amt   MAY_Tr   Jun_Tr JUL_Tr   Aug_Tr  1       1500       1            1          1          1 2        700        1            1          1          1 2       1000       1            1          1          1 3         500       1            1          1          1   Thank you in advance. Let me know if you have any doubts with the question.        ... View more

to count transactions happening every month with same trans amount.

by Calcite | Level 5 in SAS Programming
‎10-21-2019 02:00 AM
‎10-21-2019 02:00 AM
Hi everyone, I am new in SAS and need help in below problem.   I have a dataset like this, EXCEPT the Expec_Month Column which is desired.   ID            Trans_date   Trans_amt Month    Expec_Month 1              03MAY2019 1500             MAY     MAY 1              03JUN2019 1500            JUN       JUN 1              05JUL2019 1500             JUL       JUL 1              03AUG2019 1500           AUG    AUG 2              30MAY2019 700             MAY    MAY 2              01JUL2019 700              JUL      JUN 2              30JUL2019 700              JUL      JUL 2              30AUG2019 700             AUG    AUG 2              04MAY2019 1000          MAY     MAY 2              08JUN2019 1000          JUN      JUN 2              08JUL2019 1000           JUL      JUL 2              05AUG2019 1000          AUG    AUG 3              02MAY2019 500            MAY     MAY 3              02JUN2019 500            JUN     JUN 3              01JUL2019 500             JUL     JUL 3              31JUL2019 500             JUL     AUG   I want to find transactions happening every month with same trans amount.    ID            Trans_date     Trans_amt   Month    Expec_Month 2              30MAY2019   700               MAY     MAY 2              01JUL2019    700               JUL       JUN   for cases like this above, if trans_date is 30MAY2019 then the tran_month = MAY now if the next tran_date of the same customer with simlar tran_amount lies in between +-5 days then the transaction month needs to be updated like here next tran_date is 01JUL2019 falling in between +-5 days of 30MAY2019, so expect_month = JUN not JULY   AND my desired final output would be like this   ID     Trans_amt  MAY_Tr Jun_Tr   JUL_Tr Aug_Tr  1       1500           1            1            1        1 2        700            1            1            1        1 2       1000           1            1            1        1 3         500           1            1            1        1   Thank you in advance. Let me know if you have any doubts with the question.  ... View more

To count the number of IDs for which the trans_amt remains same in al...

by Calcite | Level 5 in SAS Programming
‎10-16-2019 10:17 AM
‎10-16-2019 10:17 AM
Hi everyone, I am a newbie in SAS.    I have a large data set with numerous variables two of which are "ID" and "Trans_amt"   What I want to find is to count the number of IDs for which the trans_amt remains same in all observations of that ID.    ID       Trans_amt   1          1000 1          1000 1          1000 1          1000 2            500 2            500 2            500 3            750 3            750 3            800 4           1200 4           1500 4           1200   Example for ID 1 the Trans_amt is 1000 for all 4 cases right? I want to create a new variable ID_1 where it stored the ID of those only.    Thanks a lot in advance.     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-23-2019 04:56 AM
Likes given to
View All
Quick links