topic Re: How to save a dataset each first day of the month without opening the SAS program (automatically in SAS Enterprise Guide

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

alepage — Mon, 28 May 2018 13:40:56 GMT

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,

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

Kurt_Bremser — Mon, 28 May 2018 13:42:39 GMT

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.

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

Reeza — Mon, 28 May 2018 18:56:52 GMT

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

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

alepage — Tue, 05 Jun 2018 14:50:45 GMT

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

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

Reeza — Tue, 05 Jun 2018 14:57:07 GMT

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

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

Kurt_Bremser — Tue, 05 Jun 2018 14:58:12 GMT

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?

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

alepage — Tue, 05 Jun 2018 18:04:03 GMT

copy a work.dataset on the commun server