topic Re: put text file without header in SAS Enterprise Guide

put text file without header

jimksas — Fri, 11 Jul 2014 17:46:23 GMT

i am trying to put text file out without header - how can i do that - please help

filename text1 "d:\text_file_name";

data _null_;

file text1 dlm="|";'

set sashelp.class;

put var1 var2 var3 var4;

run;

OS2Rules — Fri, 11 Jul 2014 17:53:18 GMT

From the manual:

FILE PRINT <NOTITLES> <FOOTNOTES>;: directs output to the SAS procedure output file. Place the FILE statement before the PUT statements that write to that file. The NOTITLES option suppresses titles that are currently in effect, and makes the lines unavailable for writing other text. The FOOTNOTES option, along with the FOOTNOTE statement, writes a footnote to the file.

jimksas — Fri, 11 Jul 2014 20:53:53 GMT

how can we perform it from code perspective - because this piece of code should goes with automation...

Thank you...

Peter_C — Fri, 11 Jul 2014 21:02:30 GMT

filename text1 "d:\text_file_name";


data _null_;
file text1 dlm="|" DSD;
set sashelp.class;
put (var1 var2 var3 var4)(:);
run;

jimksas — Sat, 12 Jul 2014 00:36:34 GMT

Thanks a lot Peter - it worked fine...

Ksharp — Sat, 12 Jul 2014 12:31:59 GMT

ods _all_ close;
ods csv file='c:\temp\x.txt' options(delimiter='|');
proc print data=sashelp.class noobs label;run;
ods csv ;

Xia Keshan

Peter_C — Mon, 14 Jul 2014 21:34:35 GMT

Xia

have you tried ods csv on a large table?

Last time I tried it took much longer than the datastep solution.

peter

sas_lak — Tue, 15 Jul 2014 04:31:23 GMT

/* Using the PutName=No output file doesnot have any kind of headers */

proc export data=Out outfile="C:\Users\lakshman\Desktop\New Folder\Out.txt"

dbms=dlm replace;

delimiter="|" ;

putname=no;

run;

Ksharp — Tue, 15 Jul 2014 14:01:51 GMT

I know. it is more efficient for data step.