topic Re: Use a variable from a different data sources in SAS VA in SAS Visual Analytics

Use a variable from a different data sources in SAS VA

jpapaiac — Fri, 03 Jul 2015 20:25:26 GMT

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.

Re: Use a variable from a different data sources in SAS VA

avvy — Mon, 06 Jul 2015 05:15:15 GMT

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

Re: Use a variable from a different data sources in SAS VA

Lorrie_SAS — Mon, 06 Jul 2015 18:49:01 GMT

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

Re: Use a variable from a different data sources in SAS VA

Explore_SAS — Tue, 07 Jul 2015 15:02:17 GMT

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.