Export .sas7bdat from SAS Studio to local machine

Question

I am using SAS Studio(completely browser based). I need to export a dataset to my local machine in the .sas7bdat file format. I think it should be something like PROC EXPORT data = sqrtReg2 outfile = "C:\Documents\SAS\Target_Wins.sas7bdat";. But that returns the error ERROR: Unable to determine datasource type. Please use the DBMS= option.. But the DBMS option only allows for CSV, tab and DLM. How do I export this data set to my local machine in the .sas7bdat file format?

Answer 1

With the SAS University Edition you can setup shared folders in the virtual machine where SAS runs that are mapped to actual folders on your real machine.

For example you might have mapped C:\Documents\SAS\ to /folders/myfolders. You cannot write to other locations on your real machine that are not mapped so that the virtual machine can see them. Check the documentation for exact details of getting the folders mapped.

The normal way to have SAS place a dataset then is to create a libref that points to the folder and then use a two level name when referencing the data set. You could create a libref named OUT for example:

 libname out '/folders/myfolders/';
 data out.target_wins; 
   set sqrtReg2;
 run;

But you can also just refer to the file directly without first creating a libref.

 data '/folders/myfolders/target_wins'; 
   set sqrtReg2;
 run;

Note that since SAS is actually running in Unix you cannot use CamelCaseFileNames for your SAS datasets. The files will always be in all lowercase letters.

Answer 2

None of the answers worked for me. Maybe because after April 2021, they have made changes to the platform(University). So, after a lot a time searching, I found what I needed.

You can easily export the sas dataset to csv, xslx, by just right clicking on the dataset and selecting export as csv, xlsx, etc. For exporting to sas7bdat file, do:

1. Create your dataset, I am creating from csv, so create a program1(.sas) to first convert csv to sas dataset.

proc import file="/home/u123/mydata.csv"
    out=work.mydata
    dbms=csv
    replace;
run;

This will create your sas dataset.

2. IMP Go to "Libraries" at the right bottom, and hit "My Libraries" -> New Library -> Name it(eg - test), give path(eg - /home/u123/sasuser.v94) Check library creation, and HIT "Refresh Library Session" on right pane, don't refresh the page.

3. Now create a separate program2(.sas), to export the dataset to .sas7dbat file.

PROC COPY IN=WORK OUT=test;
SELECT mydata;
run;
quit

This will create a .sas7bdat file in your directory, with same name as your dataset.

These exact steps worked out for me.

Answer 3

It won't work for 2 reasons.

1. You can't export a SAS dataset to a SAS dataset (.sas7bdat) - Proc Export will export to excel, csv, etc but not to a .sas7bdat.
2. you're running SAS Studio from within a Virtual Machine that uses Linux as OS so path to create an external file is incorrect. You haven't hit this error but you will once you use the right filetype.

When you installed SAS Studio you should have created a shared folder. This folder is accessed from within SAS Studio as /folders/myfolders/filename.

So your code should looks like this:

PROC EXPORT data = sqrtReg2 
            outfile = "/folders/myfolders/Target_Wins.csv";
run;

From Windows the path to this shared folder will depend upon where you installed your VM.

Option 2

If what you need is the dataset then try the following code:

libname out "/folders/myfolders/";

proc copy in=work out=out;
 select sqrtReg2 ;
run;

Again, table will be in your shared folder which is accesible from Windows.

Answer 4

I used just like option 2 in the above answer. I need to export my polygon data from SAS Studio in my virtual machine so that i can import it to my Visual Analytics. and it worked just fine.

libname out "/folders/myfolders/";

proc copy in=work out=out;
 select my_map;
run;