Desktop productivity for business analysts and programmers

Export help

Reply
N/A
Posts: 0

Export help

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.
SAS Employee
Posts: 149

Re: Export help

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;
Super Contributor
Super Contributor
Posts: 3,174

Re: Export help

A lean PROC PRINT may work, such as:

OPTIONS NODATE NONUMBER NOCENTER LS=MAX PS=MAX;
TITLE1; TITLE2;
PROC PRINT U NOOBS...;
VAR ;
RUN;
Ask a Question
Discussion stats
  • 2 replies
  • 901 views
  • 0 likes
  • 3 in conversation