BookmarkSubscribeRSS Feed
jpapaiac
Fluorite | Level 6

How can I use a variable from a different data source into my report.  Both sources have a common key. For example in one report I am using contract number and a product Id.  Now I want to bring the customer name from a different data source using the contract number as a primary key for both sources.

3 REPLIES 3
avvy
Quartz | Level 8

Hi,

To get the functionality as you require, you have to use "Prepare Data" using the common field or primary key. According to my knowledge it can't be achieved directly in the report designer if you are having two different data sources with common field.

Regards,

Abhishek

Lorrie_SAS
SAS Employee

Adding to Abhishek's comment, here is where you can find some information about using the data builder (data preparation) to create a data query:

SAS(R) Visual Analytics 7.1: User's Guide

Best regards,

Lorrie

Explore_SAS
Obsidian | Level 7

I am also facing the same issue. looks like there is no option than creating a new dataset with all the required columns in new report.

SAS Innovate 2025: Call for Content

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!

Submit your idea!

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
  • 3 replies
  • 1619 views
  • 0 likes
  • 4 in conversation