topic How to repeat same analysis on different dataset (SAS VA)? in SAS Visual Analytics

How to repeat same analysis on different dataset (SAS VA)?

data_ipr — Tue, 12 May 2015 13:35:44 GMT

Hi everyone!

I tried for the first time to design a report in SAS VA, and now I am wondering how can I repeat the same analysis on an updated dataset (with the same starting variables).

Is there a way to access the source code SAS VA is running to accomplish the analysis?

Thank you in advance!

Giorgio

Re: How to repeat same analysis on different dataset (SAS VA)?

Sam_SAS — Tue, 12 May 2015 14:21:56 GMT

Hello Giorgio,

You can save a copy of your report, and then change the data source for that report. See this topic in the user's guide:

https://support.sas.com/documentation/cdl/en/vaug/67500/HTML/default/p1wu8wfn7fpirfn1gsmmivteaku8.htm#n0drq58zkbjcjtn19vrfuk56d2d0

This works best if the variable names in the two data sets are identical, or if the new data set is a superset of the first one. However, you will be prompted to correct any mis-matches in the variable names.

I hope this helps,

Sam

Re: How to repeat same analysis on different dataset (SAS VA)?

data_ipr — Tue, 12 May 2015 14:32:55 GMT

Thank you!

And what if some variables change? For example, I might have created new calculated variables in the first report. Do I have to redefine each new variable for the new dataset?

Re: How to repeat same analysis on different dataset (SAS VA)?

Sam_SAS — Tue, 12 May 2015 14:43:56 GMT

If the variables in the expressions for your calculated variables have the same name in the new dataset, then the calculated variables should be OK.

For example, if you have a calculated variable "Profit" with the expression "Revenue - Expenses", then the calculated variable should be OK if the new data set has variables named "Revenue" and "Expenses."

I believe this to be the case. I would verify it but my test server is down for maintenance at the moment.

If the calculated variables are lost when you change data sets, you can re-create them easily by using the text mode of the expression editor. You can simply copy the expression code from one report and then paste it in the new one.