Export help

[deleted_user]

Hello,

I'm running Enterprise Guide 4.1 and need help with an export function...
I have a table with 14 columns that I need to export to a fixed width text file padded with spaces (not comma delimited).

How do you I specify my column width? This does obviously not work with the export wizard.

[RichardH_sas]

I think you'd have to write code to do this -- I can't think of a feature to export a fixed-width file. You could use the DATA step as follows (simple example):

data _null_;
set sashelp.class;
file "C:\test.txt";
put @1 height @10 name;
run;

[sbb]

A lean PROC PRINT may work, such as:

OPTIONS NODATE NONUMBER NOCENTER LS=MAX PS=MAX;
TITLE1; TITLE2;
PROC PRINT U NOOBS...;
VAR ;
RUN;