Hello,
I load SAS tables into VA and update them on a regular basis. In case a variable name in these tables would change VA would try to repair the reports which wold result in the variable being dropped from the reports. Is there a way to change the variable name in all reports at once? Needless to say we are talking about a lot of reports here, i. e. a manual adjustment is not feasible.
Wouldn't it be easier to fix the data? Personally I would consider it a data transfer, so main focus here is on getting an agreement with the data vendor as to the structure of the data. Then if it doesn't match reject. Otherwise there is nothing stopping the vendor from dropping data, changing it, re-structuring etc. and you could then be making updates each time.
Thanks for the reply.
Unfortunately it's not that easy. The change is a actually a necessary fix. Anyway it's beyond my control.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.