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

[data_ipr]

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

[Sam_SAS · Accepted solution]

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.ht...

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

[data_ipr]

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?

[Sam_SAS]

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.