topic Re: how to export dataset to a sas7bdat file in SAS Programming

how to export dataset to a sas7bdat file

abdulla — Tue, 29 Sep 2020 23:58:20 GMT

Can anyone help me with the following?

proc export data=have

outfile="&output.want.dat"

dbms=DLM

replace;

run;

I have my libname created. But this one is not working

Re: how to export dataset to a sas7bdat file

CurtisMackWSIPP — Wed, 30 Sep 2020 00:09:20 GMT

In your example, have is already a sas7bdat file since it is in the work library.

If you want to copy it to a permanent library you can use proc copy, or just another data step.

libname dest "&output";
data dest.want;
  set have;
run;

The export procedure for creating non-SAS files.

Re: how to export dataset to a sas7bdat file

abdulla — Wed, 30 Sep 2020 00:15:21 GMT

This doesn't create sas7bdat file. It creates a file for as code, not for data.

Re: how to export dataset to a sas7bdat file

CurtisMackWSIPP — Wed, 30 Sep 2020 00:20:35 GMT

You asked to:

export dataset to a sas7bdat

SAS7BDAT is the extension for a SAS dataset.

What format do you want output, and where?

Re: how to export dataset to a sas7bdat file

CurtisMackWSIPP — Wed, 30 Sep 2020 00:23:34 GMT

%let output = C:\temp\;
data have;
  x = 1;
run;
proc export data=have
   outfile="&output.want.dat"
   dbms=DLM
   replace;
run;

Is this what you are trying to do?

Re: how to export dataset to a sas7bdat file

abdulla — Wed, 30 Sep 2020 00:26:23 GMT

ERROR: Export unsuccessful. See SAS Log for details

Re: how to export dataset to a sas7bdat file

CurtisMackWSIPP — Wed, 30 Sep 2020 00:29:27 GMT

Does my last example work?

Re: how to export dataset to a sas7bdat file

abdulla — Wed, 30 Sep 2020 00:32:11 GMT

No, it doesn't. It gives the following:

ERROR: Export unsuccessful. See SAS Log for details

Re: how to export dataset to a sas7bdat file

CurtisMackWSIPP — Wed, 30 Sep 2020 00:36:32 GMT

Is there anything further up the log that gives more information?

Did you change the line:

%let output = C:\Temp\

To a location that exists and that you have write permission too?

Re: how to export dataset to a sas7bdat file

abdulla — Wed, 30 Sep 2020 00:38:45 GMT

I copied your data and just changed the path to see whether it works or not. It doesn't export file. Is it working for you?

Re: how to export dataset to a sas7bdat file

CurtisMackWSIPP — Wed, 30 Sep 2020 00:41:06 GMT

Yes, that code runs exactly like it is posted.

Are you making sure your path ends in a \ ?

Re: how to export dataset to a sas7bdat file

abdulla — Wed, 30 Sep 2020 00:45:37 GMT

Yes. I made sure that. I will close my all files and run the data again. I will let you know it it works or not

Re: how to export dataset to a sas7bdat file

Reeza — Wed, 30 Sep 2020 01:02:07 GMT

Your PROC EXPORT creates a text file with a .dat extension not a SAS7BDAT file.

If you want a SAS7BDAT file you place it into that library and the file is created. If you want a text file you use a PROC EXPORT and ensure you have the path correct.

"Export"/Save to a SAS7BDAT file to the myfolders folder.

libname myFiles "/folders/myfolders/";

proc copy in=work  /*library of input files*/
                out=myFiles; /*library of output files*/
select WANT; *dataset to copy is called want;
run;

Export to a text file - Tab (09x) delimited, if you want a different delimiter change the delimiter statement.

proc export data=sashelp.class
outfile = "/folders/myfolders/class.dat" dbms=dlm replace;
delimiter = '09'x;
run;

Make sure you code works before you add macro variables and then add the macro variables once it's working.

@abdulla wrote:

Can anyone help me with the following?

proc export data=have

outfile="&output.want.dat"

dbms=DLM

replace;

run;

I have my libname created. But this one is not working

Re: how to export dataset to a sas7bdat file

Reeza — Wed, 30 Sep 2020 01:02:44 GMT

If your code isn't working after this, post the exact code and log.

@abdulla wrote:
Yes. I made sure that. I will close my all files and run the data again. I will let you know it it works or not

Re: how to export dataset to a sas7bdat file

abdulla — Sun, 04 Oct 2020 19:28:17 GMT

It didn't work. By the way, I got the solution. Thank you for your effort.