The SAS Output Delivery System and reporting techniques

Creating a Text file

Reply
N/A
Posts: 1

Creating a Text file

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.

Respected Advisor
Posts: 3,895

Creating a Text file

...

set ... end=last;

if _n_=1 then

do;

     <header code>

end;

<data area>

if last then

do;

  <trailer code>

end;

Ask a Question
Discussion stats
  • 1 reply
  • 843 views
  • 0 likes
  • 2 in conversation