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,
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.
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.
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
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.
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?
copy a work.dataset on the commun server
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.