Hi , Hi , I am working on a dataset to create an out put txt file with header and trailer records .I had created the Header and trailer ( count of total records). I want the header and trailer starts with first column and ends with the last column of the record . 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; data test; set test.test_data END=EOF; file "&filePath/data_2016"; *Header record; If _n_=1 then do; put 'AL,,,0000'; end; put name city country id ; /*Trailer record*/ if eof then do; put _N_ : z4.; end; run; ex: Output : AL16 0000 Thomas New Jersy USA 1000 David New Jersy USA 1000 Rahul Virginia USA 2002 DL99 0003 Thanks Madhu
... View more