Desktop productivity for business analysts and programmers

want to give space between in two variables in txt

Reply
Contributor
Posts: 31

want to give space between in two variables in txt

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

PROC Star
Posts: 7,437

want to give space between in two variables in txt

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;

Regular Contributor
Posts: 184

Re: want to give space between in two variables in txt

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

Super User
Posts: 9,875

Re: want to give space between in two variables in txt

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

Ask a Question
Discussion stats
  • 3 replies
  • 126 views
  • 1 like
  • 4 in conversation