BookmarkSubscribeRSS Feed
mattneo
Obsidian | Level 7

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?

 

 

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 0 replies
  • 497 views
  • 0 likes
  • 1 in conversation