topic To save a table. in SAS Programming

To save a table.

deleted_user — Thu, 12 Nov 2009 18:55:09 GMT

I have created the table Mytable in a data step and want to save it to the directory C:\Mydir. I want to do the saving with code.

How can that be done?
Special procedure(s) or even possible in the data step itself?

Re: To save a table.

abdullala — Thu, 12 Nov 2009 19:35:39 GMT

dont quite understand what you want. can you just create a library for this folder c:\mydir and create a dataset in that library?

libname save 'c:\mydir';
data save.mytable;
set mytable;
run;

is this what you wanted?

Re: To save a table.

DanielSantos — Fri, 13 Nov 2009 08:30:59 GMT

Tables are physically stored into a single file in the system (usually with a .sas7bdat extension).

So, if you're creating MyTable to dataset code, redirecting the output table to the desired libname (directory) should be enough and the simplest way.

You could still use the COPY procedure to copy the dataset from one libname to another.

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a000085782.htm

Cheers from Portugal.

Daniel Santos @ www.cgd.pt