I am having a hard time finding a solution to this question, therefore I need your help.
I have a table that has a record for each invoice #. Each record will also have other fields such as cust# sales posted date, sales, etc. etc. I have joined this table to my customer table that has a date that denotes when this customer became a loyalty customer. So now my output table, for each record, has a posted date and the loyalty date. I'm trying to determine the sales for each customer prior to and after the loyalty date.
I have tried derived items (maybe i'm not using the correct one) and i've also tried various formats for formulas, such as
If (loyalty date >= posted date), 1 0
This lumped every customer as a 1 or a 0, but did not separate them out at the invoice level. Maybe i need to do something to the dates in the calculated item, i'm not sure.
Any advice?
Maybe you can create two new calculated variables for sales (i call it salesVar here) like:
Sales_after:
if loyalty date >= posted date then salesVar else 0
Sales before:
if missing(loyalty date) then salesVar else 0
//Fredrik
Maybe you can create two new calculated variables for sales (i call it salesVar here) like:
Sales_after:
if loyalty date >= posted date then salesVar else 0
Sales before:
if missing(loyalty date) then salesVar else 0
//Fredrik
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.