Combining report data sources

[dmbill]

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

[Lorrie_SAS]

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#n14yl8nwnuk797n1oqvbg...

Working with joins –

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

Thanks,

Lorrie

[dmbill]

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