Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

proc export to dat?

proc export to dat?

proc export to dat?

I notice that proc export allows for just about every file extension except .dat or sas file. Is there a way to do this.  I ak because I am using a server version of sas that kicks me out whenever I click and drag a file from sas to my local drive to make a copy of it.  I thought there might be a way to save it as a dat or sas file through proc export

RE: proc export to dat?

If you want a SAS dataset onto a local drive there's a couple of ways to do it.

i) Create a libname where you want the dataset to go and then use a data step referencing that outputted libname.

ii) Use a Proc Append

RE: proc export to dat?

From my understanding, you are trying to export a SAS dataset from SAS server to your local PC. You can easily do it if you have PC SAS installed on your machine and have SAS/CONNECT license. You can verify this by running

proc product_status;

If you have SAS/CONNECT installed then use the following commands to connect to your server

%let mynode=<servername>
filename rlink "C:\Program Files\SAS\SASFoundation\9.2\connect\saslink\tcpunix.scr";
options comamid=tcp remote=mynode;

Then assign libname statements to your server and local drive as follows:

libname rmtsvr '<path>' server=mynode';
libname local '<path';

Then you can use PROC COPY or any other copy method to copy the datasets from remote to local and vice versa.

You can otherwise use the FTP tool like WinScp just to drag and drop files from remote to local and vice versa.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close