topic Re: SAS ODS in ODS and Base Reporting

SAS ODS

singhsahab — Mon, 16 Oct 2017 04:52:47 GMT

Hi All,

Does it possible to export the sas dataset in .txt (text format) by using SAS ODS ?

Thank you in advance !!!

Re: SAS ODS

Reeza — Mon, 16 Oct 2017 05:37:16 GMT

ODS CSV will create a CSV file.

ODS LISTING, the original SAS output can also be directed to a text file.

A data _null_ step can create text files.

Proc Export can create txt files as well.

Note that you’ll lose graphs in a text file.

Re: SAS ODS

RW9 — Mon, 16 Oct 2017 09:32:49 GMT

Nope. ODS is the destinations for output, it is not an output procedure in itself. For that you would need to generate output, generally using output procedures such as proc report, print, tabulate, data step. You can also select various objects from certain procedures, and proc sql without a create table automatically creates some output, but generally ods target set and then proc your data out to that destination.

Re: SAS ODS

ballardw — Mon, 16 Oct 2017 14:34:23 GMT

I don't really believe there is any actual "standard" TXT file format. Some "text" files use tab characters for delimiters, others don't. Some are fixed column.

So ODS would tend to have a bit of a moving target.

You may want to provide a short example of some example data and what you want your "text" file to look like so we can make specific suggestions.

Re: SAS ODS

singhsahab — Tue, 17 Oct 2017 10:31:45 GMT

Hi Ballaardw

thank you for your post .However this can be achieve by ODS LISTING . Below mentation code works for me.

ODS NORESULTS;

ODS LISTING FILE "FILE.TXT";

PROC PRINT DATA=TEST;

RUN;

ODS LISTING CLOSE;

Thanks,

Re: SAS ODS

Rascon — Mon, 27 Aug 2018 07:18:41 GMT

ODS stands for output delivery system. It is mostly used to format the output data of a SAS program to nice reports which are good to look at and understand. That also helps sharing the output with other platforms and soft wares.