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

[Caleb2]

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?

[Reeza]

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

---

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

[MarkusWeick]

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

[Caleb2]

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

[Madelyn_SAS]

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.

[Caleb2]

That worked perfectly! Thank you so much 🙂

[MarkusWeick]

As Madelyn wrote: