How to save a dataset each first day of the month without opening the SAS program (automatically)

[alepage]

Hello,

I am using a SAS Enterprise Guide 7.15 and I would like to make a backup of a dataset automatically each first day of the month.  Is there a way to achieve that operation.  Does The SAS programm need to be open?

Regards,

[Kurt_Bremser]

Where is your SAS workspace server running? If it's not local, using the server's scheduling tool is more reliable (and usually simpler) than scheduling a EG project on the desktop.

[Reeza]

---

@alepage wrote:

Hello,

I am using a SAS Enterprise Guide 7.15 and I would like to make a backup of a dataset automatically each first day of the month.  Is there a way to achieve that operation. 

---

Yes

---

@alepage wrote:

Does The SAS programm need to be open?

---

No. 

[alepage]

how can we make a backup of a dataset automaticaly lets say at each first Monday of the Month without opening the SAS program with EG 7.15

[Reeza · Accepted solution]

Create a stored procedure that runs on the first of the month. You can schedule this is in your SAS server. 

The stored procedure is basically the code to save the data set, depending on your rules you can possibly use PROC DATASETS to copy it over and rename the data set. You need to have this scheduled on a server because its likely your computer is not on every day and no guarantee that it's on the first of the month, especially on weekends.

http://www2.sas.com/proceedings/sugi30/135-30.pdf

[Kurt_Bremser]

What do you mean by "backup"? Just a copy to a new name, to a different directory, or to a tape archive?

Does your organization already run jobs automatically in batch?

[alepage]

copy a work.dataset on the commun server