topic Re: SAS to csv remove starting pipe in SAS Data Management

SAS to csv remove starting pipe

jim_toby — Wed, 07 Nov 2018 16:36:52 GMT

Hello,

I'm writing code that will convert SAS to CSV and it seems like everything is working however, I want my csv which is delimited by a pipe to not start a new row with a pipe.

Example here is how my file currently looks:

|value1|value2|value3

And here is how I want it to look:

value1|value2|value3

This is my SAS Code:\

DATA _null_;
	SET MySAS.SasTable; /*MySAS is the path to my SAS Table*/
	FILE &outfile; /*outfile is where my csv file will be created*/
	put (_all_) ('|');
RUN;

Can anyone help me resolve this issue? Thanks in advance!

Re: SAS to csv remove starting pipe

data_null__ — Wed, 07 Nov 2018 16:40:48 GMT

You should add the DLM and DSD options to the FILE statement and not print the delimiter in the PUT statement.

6    data _null_;
7       file log dsd dlm='|';
8       set sashelp.class;
9       put (_all_)(:);
10      run;

Alfred|M|14|69|112.5
Alice|F|13|56.5|84
Barbara|F|13|65.3|98
Carol|F|14|62.8|102.5
Henry|M|14|63.5|102.5
James|M|12|57.3|83
Jane|F|12|59.8|84.5
Janet|F|15|62.5|112.5
Jeffrey|M|13|62.5|84

Re: SAS to csv remove starting pipe

jim_toby — Wed, 07 Nov 2018 17:43:39 GMT

@data_null__ so here is what I have based on your code:

DATA _null_;
        file log dsd dlm= '|';
	SET MySAS.SasTable; /*MySAS is the path to my SAS Table*/
	FILE &outfile; /*outfile is where my csv file will be created*/
	put (_all_) (:);
RUN;

And all it seems to be doing is putting black spaces between each record. So the delimiter never even shows up

Re: SAS to csv remove starting pipe

data_null__ — Wed, 07 Nov 2018 17:49:25 GMT

You need to put the DLM and DSD options on your FILE &OUTFILE file statement. My program is an example not a template.

@jim_toby wrote:

@data_null__ so here is what I have based on your code:
DATA _null_;
        file log dsd dlm= '|';
	SET MySAS.SasTable; /*MySAS is the path to my SAS Table*/
	FILE &outfile; /*outfile is where my csv file will be created*/
	put (_all_) (:);
RUN;
And all it seems to be doing is putting black spaces between each record. So the delimiter never even shows up

Re: SAS to csv remove starting pipe

Reeza — Wed, 07 Nov 2018 17:51:57 GMT

@jim_toby You have two file statements and that usually results in the last one being used, so the options from the first FILE statement are ignored. Make sure you only have one.

Re: SAS to csv remove starting pipe

jim_toby — Wed, 07 Nov 2018 18:18:38 GMT

@Reeza Thanks for the heads up, I completely missed the first file statement!

Re: SAS to csv remove starting pipe

jim_toby — Wed, 07 Nov 2018 18:19:06 GMT

@data_null__ thanks it worked!