Hi SAS Expert,
Previously, I have created a WRS report.
Now I would like to change the data source of the report, without changing any field settings/ layout in the report.
The field names between the old data source and new data source are the same.
Can this be done? Could you please suggest a solution?
Regards,
Mike
Hi!
The best way to do this is by using a infomap as a middlestep to a report, there you can change the source (ex a olap cube) without any changes to the report. If you don't have a infomap, I think it's not possible sorry.
BR
Daniel
You could try using the export wizard from SAS Management Console to export the report. Then, re-import the report, specifying your new data source. Make sure you have a back-up of the report before trying this.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.