Good Afternoon,    I am trying to draft a reward redemption project on sas eg and I am facing some difficulties.   Currently I have 2 Tables: - The first one contains the following information:    MembershipID    Credit (in rewards points)    Rewards Issued Date    Source Of Business (Restaurant A, Restaurant B ...)   - The second one contains the following inofrmation:    MembershipID    Debit (in rewards point)    Redemption Date   My goal is to apply a FIFO approach to measure the points redemption by Source of Business based on the dates the points are redeemed. For example, if I start with a zero point balance and I am issued 1,000 points at Restaurant A on 12/10/2016 and 1,500 points at Restaurant B on 12/15/2016; my running balance as of 12/15/2016 becomes 2,500 - let's say now that I redeem 1,500 points on 12/20/2016, I want my query to show a 1,000 deduction from my first credit transaction (Restaurant A) then 500 from second credit transaction (Restaurant B) so that my SOB Redemption Report shows 100% from Restaurant A and 33% from Restaurant B    INPUT                                                         SOB              Credit          Debit         Balance 12/10/2016    Restaurant A       1,000              0                1,000  12/15/2016    Restaurant B       1,500              0                2,500 12/20/2016        ------------              0             1,500            1,000      OUTPUT                              SOB              Redemption% 12/20/2016     Restaurant A              100%  12/20/2016     Restaurant B                33%   ... View more

Hello All,    I am trying to calculate and incorporate a week over week sales variance on SAS VA and I am having some difficulties.    Currently I have the following data: Transaction Date (MMDDYYY) Transaction End of Week Dt (MMDDYYY) Transaction Week (Numeric) Amount (Dollar) Day of Week (Character)   I tried multiple formulas and nothing seems to work.   Thanks,    CJ ... View more

Hello All,   I am trying to incorporate a YOY Profit Variance formula in cross table using the following data:   Age Group: 18-25, 26-35, 36-55, 55+ Profit: $DOLLAR Activity Date Current/Previous Year Flag: CY, PY   My ideal output would be:                        CY - Current Yr    PY - Current Yr     Var. Age 18-25     $  146,888      $  104,138    41% Age 26-35     $    91,169      $  111,672   -18% Age 36-55     $  120,281      $    86,284    39% Age 55+        $  144,021      $    92,877    55% Total             $  502,359      $  394,971    27%    I tried the following formula however; it did not work    [(IF Current/Previous Year Flag = CY  RETURN PROFIT) / (IF Current/Previous Year Flag = PY RETURN PROFIT)] -1    format: PERCENT   Can someone help please?   Thank you,   CJ     ... View more

I am trying to create a filter to show current month and current year on a dynamic SAS VA report; however, I am not getting the result I need. Can someone help please ? ... View more