topic Re: How to create .txt file with a header and Trailer in SAS Enterprise Guide

How to create .txt file with a header and Trailer

tvbMadhu — Fri, 25 Nov 2016 17:58:50 GMT

Hi ,

I am working on a dataset to create an out put txt file with header and trailer records .The header record which is the first line in the file and trailer record as the last line in the file .

EX: If there were,3 records then the header field as 00000 . and trailer as 0003 ( count of records).

Could anyone send me the code.

Thanks

Madhu

Script:

%let filePath = /user/home/test;
libname test '/user/home/test/';
%include 'user/home/test/TDpwd.txt';

proc sql;
CONNECT TO TERADATA (user=&user password=&password server=oneview mode=teradata);
create table test.test_data as
select * from connection to teradata(
SELECT * from 5pt.test24
);
disconnect from teradata;
quit;

Data test.test_result;
set test.test_data;
file "&filePath/test.data_2016";
put
Name $ 1 - 17
City $ 18 - 25
Country $ 26 - 30
Id $ 31 - 46
;
run;

Output:

00000 ( header)

Thomas Newjersy USA 1000

David Newjersy USA 1212

Rahul Virginia USA 2002

00003 (trailer)

Re: How to create .txt file with a header and Trailer

Reeza — Fri, 25 Nov 2016 18:30:45 GMT

Identifies first record in a data step

If _n_=1 then do;

end;

2. Identify last record

Set have end=eof;

if eof then do;

end;

Re: How to create .txt file with a header and Trailer

tvbMadhu — Fri, 25 Nov 2016 19:31:07 GMT

Not worked

Re: How to create .txt file with a header and Trailer

Reeza — Fri, 25 Nov 2016 20:41:59 GMT

Here's a fully worked example. You'll need to modify it to fit your data.

data test;
	set sashelp.class END=EOF; /*END creates a variable EOF that lets you know when you are on the last record*/
	file 'C:\_localdata\temp\test.txt' dlm=",";

	*Header record;
	If _n_=1 then
		do;
			put '0000';

			/*Output header record with column names - manual type in names*/
			put 'Name, Sex, Age, Height, Weight';
		end;

	put name sex age height weight;

	*Rest of your SAS code;
	/*Trailer record*/
	if eof then
		do;
			put _N_ : z4.; /*Put number of records into the file, with a format of 0000, leading zeroes*/
		end;
run;

Re: How to create .txt file with a header and Trailer

Ksharp — Sat, 26 Nov 2016 04:20:17 GMT

CODE NOT TESTED.

ods csvall file='c:\temp\x.csv';
title 'xxxxxxxxxx';
footnote 'yyyyyyyyyy';
proc print data=sashelp.class;run;
ods csvall colse;

Re: How to create .txt file with a header and Trailer

tvbMadhu — Sat, 26 Nov 2016 23:47:39 GMT

Thanks and Apreciate Reeza, It is working

little more details to be added , header and trailer starts with first column and ends with the last column of the record

ex: Output :

AL16 0000
Thomas New Jersy USA 1000
David New Jersy USA 1000
Rahul Virginia USA 2002
DL99 0003

script:

If _n_=1 then
do;
put '0000';

end;

put name,city,country,id ;

if eof then
do;
put _N_ : z4.;
end;

Thanks

Madhu

Re: How to create .txt file with a header and Trailer

sin_golbarg — Tue, 06 Mar 2018 00:26:19 GMT

Excelent

Re: How to create .txt file with a header and Trailer

sin_golbarg — Tue, 06 Mar 2018 00:27:00 GMT

excellent