want to give space between in two variables in txt

[RameshReddy]

Dear Team,

kindly any one helpon below issue...

Exporting sas data set to .txt format  with delimiter as '|'

character value where ever null must replace with 8 space between two delimiter

ie., example

Name No Sal

Rajesh|2563|5600

Kumar|5698|6580

           |4568|7560

Abcde|4812|2461

Can it is possible

Thanks in advance,

Ramesh Reddy

[art297]

You could always just force it.  E.g.:

data have;

  input Name $ No Sal;

  cards;

Rajesh 2563 5600

Kumar 5698 6580

. 4568 7560

Abcde 4812 2461

;

data _null_;

  file "c:\outpipe.txt";

  set have;

  if missing(Name) then do;

    want=catt('|',No,'|',Sal);

    put @9 want;

  end;

  else do;

    want=catx('|',Name,No,Sal);

    put want;

  end;

run;

[Howles]

Maybe

   file  ...  dlm= '|' ;

   put name $8.  '|' no sal ;

The results should look like this:

Rajesh  |2563|5600

Kumar   |5698|6580

        |4568|7560

Abcde   |4812|2461

[Ksharp]

You can always change it after importing it.

data have;
  input Name $ No Sal;
  cards;
Rajesh 2563 5600
Kumar 5698 6580
. 4568 7560
Ab 4812 2461
;
run;


data _null_;
 set have ;
 file 'c:\x.txt' dlm='|';
 put (_all_) (~);
run;
data _null_;
 infile 'c:\x.txt';
 file 'c:\want.txt';
 input;
 _infile_=prxchange('s/ (?=\|)/        /o',-1,_infile_);
 put _infile_;
run;

Ksharp