topic Re: How do I duplicate all the edits from one dataset and apply them to a new dataset with same colu in SAS Visual Analytics

How do I duplicate all the edits from one dataset and apply them to a new dataset with same columns?

Caleb2 — Tue, 20 Jun 2023 18:36:21 GMT

I created a report using data from January and I have similar datasets (all of the same column headers) for every other month. Is it possible to duplicate all efforts from the January report / dataset to create similar reports for every other month without manually doing the same work for each month?

Re: How do I duplicate all the edits from one dataset and apply them to a new dataset with same colu

Reeza — Tue, 20 Jun 2023 18:58:43 GMT

~~Yes, but you probably need to provide more info on what you're doing for specific assistance. Sometimes this is done via macros (see links below) or via BY group processing depending on the code.~~

~~UCLA introductory tutorial on macro variables and macros~~

~~https://stats.idre.ucla.edu/sas/seminars/sas-macros-introduction/~~

~~Tutorial on converting a working program to a macro~~

~~This method is pretty robust and helps prevent errors and makes it much easier to debug your code. Obviously biased, because I wrote it~~ 🙂 ~~https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md~~

~~Examples of common macro usage~~

~~https://communities.sas.com/t5/SAS-Communities-Library/SAS-9-4-Macro-Language-Reference-Has-a-New-Appendix/ta-p/291716~~

@Caleb2 wrote:

I created a report using data from January and I have similar datasets (all of the same column headers) for every other month. Is it possible to duplicate all efforts from the January report / dataset to create similar reports for every other month without manually doing the same work for each month?

My mistake, missed that this was in SAS VA.

Re: How do I duplicate all the edits from one dataset and apply them to a new dataset with same colu

MarkusWeick — Tue, 20 Jun 2023 18:57:22 GMT

Hi @Caleb2,

if you use the "change data source" option you can load the table for the new month.

As my SAS server is down, I insert an image from the web, where another option is marked. But you have to use the "change data source" option:

(Image taken from: @TeriPatsilaras : Using Data Views in SAS Visual Analytics, Using Data Views in SAS Visual Analytics - SAS Users)

Best

Markus

Re: How do I duplicate all the edits from one dataset and apply them to a new dataset with same colu

Caleb2 — Tue, 20 Jun 2023 19:08:13 GMT

Hi @MarkusWeick,

I don't seem to have that option available:

I already imported the file for February:

I created a handful of calculated items from the raw data in 'JAN PROJECT COUNT' and want to duplicate these items using the raw data from 'FEB PROJECT COUNT"

Is this possible?

Thanks,

Caleb

Re: How do I duplicate all the edits from one dataset and apply them to a new dataset with same colu

Madelyn_SAS — Tue, 20 Jun 2023 19:24:47 GMT

Are these tables exactly the same except for the actual values? So, the column names, data types, everything? If so, you should be able to Replace JAN PROJECT COUNT with the Feb table.

You should first remove the Feb table from the report.

Re: How do I duplicate all the edits from one dataset and apply them to a new dataset with same colu

Caleb2 — Tue, 20 Jun 2023 19:34:15 GMT

That worked perfectly! Thank you so much 🙂

Re: How do I duplicate all the edits from one dataset and apply them to a new dataset with same colu

MarkusWeick — Tue, 20 Jun 2023 19:34:53 GMT

As Madelyn wrote: