I'm still fairly new with SAS Visual Analytics and still learning all the functionality.  I have been creating some fairly detailed nested if statements as calculated items.  I find the need to do this on multiple different explorations.   Is there a way I can copy a calculated item or an aggregated measure from one exploration, save it e and use it for a different exploration with the knowledge that the data source being used has the same data fields?   Thanks. ... View more

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? ... View more

I am working with a group of customers that have responded to various source codes.  Some source codes start with a number and some start with a letter which differentiates different sales avenues.  What I am looking to do is to group these into two groups by assigning a logic statement as a calculated item.  Something like.   If (source code) begins with a letter assign a 1 if not a 0.   I was playing with the following: (actual screenshot attached below)   If substring (data field) 1, 1 = ( blank ) returns 1 else 0   but i didn't know if that would work as i don't know how to tell it to identify a letter in the blank field.  Does this make sense?  Can someone help me?   Thanks in advance. ... View more