How to write a SAS Dataset To a Text File without any delimiter using file statements

[ldeepikach]

How to write a SAS Dataset To a Text File without any delimiter using file statements

[Reeza]

Is this a fixed width file, where you expect every variable to have the same length in every observation?

Or will you need to pad the variable in certain cases?

SAS FAQ: How do I write out a fixed-format file in SAS?

[Ksharp]

Not sure if it was what you are looking for.

data _null_;
 set sashelp.class;
 file 'c:\temp\x.txt' ;
 put (_all_) ( +(-1) :);
run;

Xia Keshan

[RamKumar]

Excellent!

what does ( +(-1) :); indicates? In similar way can we apply delimiters  instead of normal put statement like put "|" id "|" female "|" race "?  Also how to display the observation in line by line (rows) rather than outputting all the observations in single line?

[Ksharp]

"what does ( +(-1) :); indicates?"

It means we will backward a position to output. i.e. delimiter will not be appeared.

"In similar way can we apply delimiters  instead of normal put statement like put "|" id "|" female "|" race "?  "

Yes. you can.

data _null_;

set sashelp.class;

file 'c:\temp\x.txt' dlm='|';

put (_all_) (:);

run;

"Also how to display the observation in line by line (rows) rather than outputting all the observations in single line?"

Curious. Mine is in line by line , not  in a single line . Are you creating this file in UNIX and browse it in WINDOWS?