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

[avatar]

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

Please help

Thanks

[PaigeMiller]

An example:

https://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=proc&docsetTarget=p0jp1ob4onb...

[avatar]

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

 please advise

thanks

[PaigeMiller]

PROC EXPORT works in SAS running on remote computers.

[avatar]

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;

[Tom]

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

What is the question now? 

[avatar]

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

[PaigeMiller]

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

[Tom]

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.

[Reeza · Accepted solution]

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.