topic Align columns in .DAT output in SAS Programming

Align columns in .DAT output

danacosman — Tue, 05 Dec 2017 11:49:09 GMT

Hi,

My output data (.DAT) is tab-delimited (used proc export) but because some observations have different lengths columns are not properly align. Every variable/column has same length $30.

Example of my output:

How I need them to be:

I tried to use PUT statement but the output didn't change.

put second_column @20 number_column @40;

-> this means that sas will start writing second_column starting with 20th character in the line and number_column will always start at 40th character. Did I get it wrong?

I'm new to sas and I try to understand it's ways. Any tip would help, thanks!

Re: Align columns in .DAT output

RW9 — Tue, 05 Dec 2017 11:55:46 GMT

You need to decide what you actually want. If you want all the columns to lign up then you want fixed width file format, for example:
https://communities.sas.com/t5/Base-SAS-Programming/exporting-3-datasets-into-one-fixed-width-text-file/td-p/178265

If you want to have tab delimited, then that will show the tab in the reader you open it with (each reader is different, for instance if you use notepad to open the file the tab might be 3 characters, open in ord it might tab differently). This is why I avoid using tab in anything - including in SAS code, as tabs render differently on different systems/applications. The underlying character is the same, but as that is a special character (like line feed and page break) it is down to the reader to render it.

Re: Align columns in .DAT output

Kurt_Bremser — Tue, 05 Dec 2017 12:32:22 GMT

By definition, a delimited file cannot be aligned. You either have fixed or variable widths, and one uses delimiters to avoid fixed spacings (because of the wasted space in the file, caused by the blanks used for padding).

In a tab-delimited file, the tabs are not there to align, only to separate. What you see is not the real structure of the file, only the way the file is displayed in your current viewer. Other viewers will give you another look. So don't be worried, it's all okay.

Re: Align columns in .DAT output

danacosman — Tue, 05 Dec 2017 12:38:22 GMT

Yes, I wanted fixed width file format.

The linked helped and the solution for me is to use put statement.

Thanks!