topic Re: How to write a SAS Dataset To a Text File without any delimiter using file statements in SAS Procedures

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

ldeepikach — Tue, 11 Nov 2014 19:32:19 GMT

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

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

Reeza — Tue, 11 Nov 2014 19:59:22 GMT

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?

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

Ksharp — Wed, 12 Nov 2014 13:07:06 GMT

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

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

RamKumar — Wed, 12 Nov 2014 13:27:04 GMT

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?

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

Ksharp — Wed, 12 Nov 2014 13:57:12 GMT

"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?