BookmarkSubscribeRSS Feed
aroras4
Calcite | Level 5

I want to create a text delimited file with '|' delimiter from a sas dataset. I also want a header at the start about the company name with Header

and then next lines just the dataset values from sas dataset with no column headings

and finally after the end a trailer record with summary of fields.Please correct the code from below:

thanks

data xyz;

set...;

length ....; file /// dlm = '|" recfm = f lrecl = 101;

put

@001   Header &1.

@002 .....;

if not header than do;

@001 detail rec $1.

@002 var1

@003 var 2;

@100 '0D0A'x

if end then do ;

put @001 footer

@002 summary

end;run;

please help for correction.

1 REPLY 1
Patrick
Opal | Level 21

...

set ... end=last;

if _n_=1 then

do;

     <header code>

end;

<data area>

if last then

do;

  <trailer code>

end;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 2030 views
  • 0 likes
  • 2 in conversation