Hi. I am using SAS VA in Viya 8.3. I have created a calculated item for a field. Here's the end result:
Before: 00SY1200
After applying text operators to extract middle values: SY12
So, with this new calculated item of 4 digit alpha-numeric values (eg. SY12, SY13), I want to use this as a left-join to another database (which has the 4 digit values and other relevant data). But when I want to do a data source join, I cannot find my calculated items; only original data fields are available.
Is there any way to use the newly generated calculated items as criteria to do joins with databases?
