topic Joining Filtered Datasets in SAS Visual Analytics

Joining Filtered Datasets

SteveDFW — Thu, 10 Jun 2021 14:52:30 GMT

I ran into this error while working in VA - data that contained a data filter can't be joined with another table. Is there a way to filter a table and join with another table inside a VA report?

Thanks.

Steve

Re: Joining Filtered Datasets

Sam_SAS — Mon, 14 Jun 2021 19:18:16 GMT

The doc offers this tip:
TIP: To join a data source that has a data source filter, convert it to an aggregated data source.

But in general, it is best practice to perform joins as part of your data preparation (i.e., outside of VA) if they will be used in a production report.

Re: Joining Filtered Datasets

SteveDFW — Tue, 15 Jun 2021 14:34:34 GMT

Thanks.