topic Can I add a blank line to n-th row? in New SAS User

Can I add a blank line to n-th row?

braam — Sat, 05 Oct 2019 07:04:48 GMT

I have a dataset with (let's say) 100 lines. Can I add a blank line to 50th (a random number) row? Then the set would be with 101 lines. Would it be possible simply? Just so you know, this dataset is my final output (e.g., regression result output). So I want it to be more readable by adding a blank line properly.

Re: Can I add a blank line to n-th row?

Kurt_Bremser — Sat, 05 Oct 2019 07:43:14 GMT

Yes, you can.

data want;
set have;
output;
if _n_ = 50
then do;
  call missing(of _all_);
  output;
end;
run;

Re: Can I add a blank line to n-th row?

Cynthia_sas — Sat, 05 Oct 2019 15:31:14 GMT

HI:

And, in the interest of completeness, if you just want a report and to add blank lines for readability purposes, you can do that with PROC PRINT without creating a copy of the original data, as shown below:

Cynthia