topic save work file in a permanent folder in SAS Procedures

save work file in a permanent folder

mei — Wed, 28 Mar 2012 07:15:02 GMT

I have a very big workfile in the work folder. as files saved in work folder is temporary, is there any best and fastest method to save the work file to another folder for permanent storage.

(other than the following data step:

data output.permanet;

set work.want;

run; )

thanks

save work file in a permanent folder

Ksharp — Wed, 28 Mar 2012 07:33:05 GMT

Usa another library to instead of WORK library.

libname x v9 'c:\temp\';
options user=x;
data class;
 set sashelp.class;
run;

Ksharp

save work file in a permanent folder

mei — Wed, 28 Mar 2012 07:44:46 GMT

this is the error log:

libname output v9 'D:\MeiYee Folder\My Documents\PhD\Data Analysis\output';

NOTE: Libname OUTPUT refers to the same physical library as USER.

NOTE: Libref OUTPUT was successfully assigned as follows:

Engine: V9

Physical Name: D:\MeiYee Folder\My Documents\PhD\Data Analysis\output

300 options user=output;

301 data want3;

302 set sashelp.want3;

ERROR: File SASHELP.WANT3.DATA does not exist.

303 run;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set OUTPUT.WANT3 may be incomplete. When this step was stopped there were 0

observations and 0 variables.

WARNING: Data set OUTPUT.WANT3 was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.02 seconds

cpu time 0.00 seconds

can you help?

save work file in a permanent folder

manojinpec — Wed, 28 Mar 2012 07:48:00 GMT

sashelp is automatic library which is assigned in sas session.you have to use your own library

save work file in a permanent folder

Ksharp — Wed, 28 Mar 2012 08:38:07 GMT

As manojinpec said. SASHELP is a default library. You need define yourself library.

save work file in a permanent folder

mei — Wed, 28 Mar 2012 08:40:54 GMT

i open the work file and click save as 'new file name' in the new library name/directory...this also work right?

save work file in a permanent folder

manojinpec — Wed, 28 Mar 2012 09:35:28 GMT

Yes it would work.But if you want to do in programme you need to do as suggested.

save work file in a permanent folder

mei — Wed, 28 Mar 2012 12:18:56 GMT

thanks, will try this out definitely. mei

save work file in a permanent folder

Tom — Wed, 28 Mar 2012 12:33:21 GMT

You could use PROC COPY.

proc copy inlib=work outlib=output ;

select want;

run;

This will copy WORK.WANT to OUTPUT.WANT.