topic Copy sas dataset from work library to permanent library in SAS Programming

Copy sas dataset from work library to permanent library

nkm123 — Tue, 29 Mar 2016 17:46:53 GMT

Is there any easy way to copy all dataset from work library to permanent library? Ex:- Suppose I have 10 dataset to be in work library (test1, test2 .. test10) and I want to copy all of them in permanent library ( libname data "/.") with same name.

Is there any proc that could do that or only way is to get work location and loop all dataset from work location and store it to permanent dataset ?

Thanks,

Re: Copy sas dataset from work library to permanent library

Reeza — Sat, 26 Mar 2016 02:38:56 GMT

Proc copy or proc datasets.

Re: Copt sas dataset from work library to permanent library

data_null__ — Sat, 26 Mar 2016 10:28:26 GMT

You might consider the SAS system option USER. This will allow all one level names to be written to the library specified in the option.

https://support.sas.com/documentation/cdl/en/lesysoptsref/68023/HTML/default/viewer.htm#p1tl8adik7ypwun1utdwxaauf9wq.htm

Re: Copt sas dataset from work library to permanent library

FreelanceReinh — Sat, 26 Mar 2016 16:48:47 GMT

It's not quite clear from your post whether this is a one-time task or if you plan to do this regularly, occasionally or as part of a larger SAS program.

If you just want to prevent automatic deletion of the work datasets at the end of a SAS session, you can use the NOWORKTERM system option:

options noworkterm;

An easy way to copy SAS datasets and catalogs (perhaps you need work.formats, too?) manually from one library to another is to use the SAS Explorer.

As another alternative to SAS procedures, especially if you are familiar with the corresponding command of your operating system (copy, cp, ...), you can also let SAS submit this via an X command. As shown below (example for Windows), you don't need to know physical paths of libraries for this:

x "copy %sysfunc(pathname(work))\test*.sas7bdat C:\Temp";

Re: Copy sas dataset from work library to permanent library

nkm123 — Tue, 29 Mar 2016 17:51:27 GMT

Thanks Reeza, data _null_ and FreelanceReinhard . Appreciate all your help. Good learning in terms of user option. all solutions were very handy and what I was looking for. even used all of them in different project and for different need. Thanks again for your help.

Re: Copy sas dataset from work library to permanent library

nkm123 — Tue, 29 Mar 2016 17:52:34 GMT