topic want to give space between in two variables in txt in SAS Enterprise Guide

want to give space between in two variables in txt

RameshReddy — Mon, 26 Dec 2011 11:52:44 GMT

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

want to give space between in two variables in txt

art297 — Mon, 26 Dec 2011 16:29:10 GMT

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;

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

Howles — Mon, 26 Dec 2011 18:15:20 GMT

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

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

Ksharp — Thu, 29 Dec 2011 03:17:12 GMT

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