topic Re: How to export sas dataset as txt file with pipe delimiter? in SAS Enterprise Guide

How to export sas dataset as txt file with pipe delimiter?

avatar — Tue, 16 Jul 2019 18:47:07 GMT

I would like to export sas output as .txt file with pipe delimiter.

Please help

Thanks

Re: How to export sas dataset as txt file with pipe delimiter?

PaigeMiller — Tue, 16 Jul 2019 18:52:30 GMT

An example:

https://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=proc&docsetTarget=p0jp1ob4onbqign1st9ui61xybvr.htm&locale=en#p0jp1ob4onbqign1st9ui61xybvr

Re: How to export sas dataset as txt file with pipe delimiter?

avatar — Tue, 16 Jul 2019 18:57:50 GMT

I can not use proc Export in remote setup. I need to use a in data step/

please advise

thanks

Re: How to export sas dataset as txt file with pipe delimiter?

PaigeMiller — Tue, 16 Jul 2019 19:00:53 GMT

PROC EXPORT works in SAS running on remote computers.

Re: How to export sas dataset as txt file with pipe delimiter?

avatar — Tue, 16 Jul 2019 19:10:19 GMT

I got this below code – how do I use it with filename statement. Please explain

FILENAME dlmtest &filename lrecl=5000;
DATA _NULL_;
set New_Daily_claims;
file dlmtest dsd LRECL=5000 dlm = '|'; /*  CHANGE THAT TO PIPE SYMBOL, Note: DSD AND LRECL Are required. */
PUT(_ALL_)(+0);
RUN;

Re: How to export sas dataset as txt file with pipe delimiter?

Reeza — Tue, 16 Jul 2019 19:13:28 GMT

If proc export will not work, because of an issue on the remote server, neither will a data step. PROC EXPORT simply generates the data step code for you.

The exception is using the GUI, which uses a different approach and allows you to move files across environments more easily. But that usually cannot be automated.

I'm guessing you think you need a data step to export it to a location the server doesn't have access to? You would still create the file on the server and then use a different method to move the file.

Re: How to export sas dataset as txt file with pipe delimiter?

Tom — Tue, 16 Jul 2019 19:14:08 GMT

Looks like you already know how to make a delimited file where pipe is the delimiter.

What is the question now?

Re: How to export sas dataset as txt file with pipe delimiter?

avatar — Tue, 16 Jul 2019 19:16:19 GMT

I am getting error --- when I run that code with my sas dataset

Re: How to export sas dataset as txt file with pipe delimiter?

PaigeMiller — Tue, 16 Jul 2019 19:20:40 GMT

A working example of data step code is provided at the link I gave earlier.

Re: How to export sas dataset as txt file with pipe delimiter?

Tom — Tue, 16 Jul 2019 19:21:28 GMT

Why can neither see your screen nor read your mind.

Please post the lines of text from the SAS log that shows what you ran and what error was generated. Make sure to the use Insert Code icon (looks like {i}) to get a pop-up window to paste in the lines from the log so that the formatting is preserved.