topic Re: Combining report data sources in SAS Visual Analytics

Combining report data sources

dmbill — Wed, 20 May 2015 17:55:51 GMT

Hi,

I have successfully added a 2nd source of data into a report and am wondering (if possible) how to combine the two data sources that have a key column.

Thank you

Re: Combining report data sources

Lorrie_SAS — Wed, 20 May 2015 18:49:55 GMT

Hi Bill,

It sounds like you need to create a data query (using the data builder). Here is some information from the SAS Visual Analytics User’s Guide that could be helpful:

Creating data queries -

http://support.sas.com/documentation/cdl/en/vaug/67500/HTML/default/viewer.htm#n14yl8nwnuk797n1oqvbgfjtatl0.htm

Working with joins –

http://support.sas.com/documentation/cdl/en/vaug/67500/HTML/default/viewer.htm#p0ynejicr0vyecn16q7orrqg7mwa.htm

Thanks,

Lorrie

Re: Combining report data sources

dmbill — Wed, 20 May 2015 20:51:58 GMT

Thank you. I had created two separate queries, added them to the report and was trying to combine them in the report.

Combining the two sources in the data prep appears to have worked.

Thank you