topic Re: Problem with data after exporting to txt using data step in SAS Procedures

Problem with data after exporting to txt using data step

Ypss — Mon, 15 Jun 2015 06:36:29 GMT

Hello

I have a problem - when I try to export a dataset to delimited txt file using data step export, I experience a small but annoying issue that is probably limited to this way of exporting a file because proc export does the job just fine. Unfortunately I need to provide changes to this txt file that proc export can't do so using it is not the solution. So... the thing is - I have in my dataset columns that are always filled with some data and some that are not and in the txt file these empty cells look like this:

, ,

What I want is ,,. How can I remove this blank space betweem delimiter?

Re: Problem with data after exporting to txt using data step

Patrick — Mon, 15 Jun 2015 07:54:56 GMT

It would really help if you would post your code - especially the bit where you're actually writing to the text file.

So just purely guessing here:

You might be looking for something like PUT VAR1 +(-1) ',' VAR2 .....;

Re: Problem with data after exporting to txt using data step

Ypss — Mon, 15 Jun 2015 08:32:04 GMT

My code:

data _null_ ;

set WORK.Files;

file outfile delimiter=',';

if _n_ = 1 then do;

PUT 'A,B,C,D';

end;

PUT A B C D;

run ;

The output is:

A~B~C~D

F1,235, ,

What I want is:

A~B~C~D

F1,235,,,

Re: Problem with data after exporting to txt using data step

Patrick — Mon, 15 Jun 2015 10:05:04 GMT

I believe you're looking for "DSD".

ods _all_ close;

ods listing;

options missing='';

data _null_;

set sashelp.class;

file print delimiter=',' DSD;

if _n_=2 then call missing(Sex,Age,Name);

put Height Sex Age Name Weight;

run;

Re: Problem with data after exporting to txt using data step

Ypss — Mon, 15 Jun 2015 10:09:53 GMT

That's it! Thank you!