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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.