topic Re: Export help in SAS Enterprise Guide

Export help

deleted_user — Mon, 23 Nov 2009 13:58:37 GMT

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.

Re: Export help

RichardH_sas — Mon, 23 Nov 2009 16:27:22 GMT

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;

Re: Export help

sbb — Mon, 23 Nov 2009 17:39:09 GMT

A lean PROC PRINT may work, such as:

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