topic Re: How to export a SAS Dataset from SAS EG work folder to a folder on my hard drive in SAS Enterprise Guide

How to export a SAS Dataset from SAS EG work folder to a folder on my hard drive

Jack1 — Mon, 06 Jun 2016 15:49:39 GMT

I have a program file that exports individual Excel sheets as .csv files which represent a month of the year (12 total).

In turn each of these .csv files are turned into a SAS dataset (again 12 total). I then consolidate these monthly files into a single SAS dataset.

Question: Is there a line (or lines) of code I can add to my program file to automatically export my consolidated SAS dataset into a folder on my computer? I tried PROC EXPORT but it wouldn't work since the DBMS option apparently doesn't apply to SAS datasets?

I am new to SAS. Any advice appreciated.

Thanks.

Re: How to export a SAS Dataset from SAS EG work folder to a folder on my hard drive

ballardw — Mon, 06 Jun 2016 16:00:50 GMT

What format do you want the dataset exported to?

Some of the options for DBMS to specific databases such as Access, DB2, Teradata, Oracle and such require specific SAS/ACCESS modules loaded.

If you want a generic CSV or similar file it should work.

Please post the attempted Proc Export code for more targetted responses.

Re: How to export a SAS Dataset from SAS EG work folder to a folder on my hard drive

Jack1 — Mon, 06 Jun 2016 16:02:33 GMT

I want to export the SAS dataset as a SAS dataset...

Re: How to export a SAS Dataset from SAS EG work folder to a folder on my hard drive

Jack1 — Mon, 06 Jun 2016 16:06:03 GMT

This is what I tried:

proc export data=naics_bankrupt_2013 outfile='c:\user\homareau\PredictiveModels\Attrition\naics_bankrupt_2013.sas7bdat'
dbms=?? (no option for a SAS dataset here?)
label replace;
run;

Re: How to export a SAS Dataset from SAS EG work folder to a folder on my hard drive

Reeza — Mon, 06 Jun 2016 17:00:21 GMT

It isn't usually referred to export, but saving a dataset. You need to assign a library to save the data set.

You can use PROC COPY, or a DATA/PROC SQL step to move the data to the library.

libname out 'c:\user\homareau\PredictiveModels\Attrition\';

proc datasets library=work nodetails nolist;
copy in=work out=out;
select naics_bankrupt_2013;
run;quit;

If you're running SAS on a server with EG on teh server this may not work, since EG will not be able to see your desktop.

In that case look for a TASK called Copy Files from Chris Hemindinger.

Re: How to export a SAS Dataset from SAS EG work folder to a folder on my hard drive

Jack1 — Mon, 06 Jun 2016 17:42:36 GMT

Excellent Reeza! Works like a charm. Thanks again...Jack