|
Hello,
The width of the column NAME is 50 positions. How do I specify that I
just want the column to be for example 20 positions wide on the output
?
proc sql;
select name, age, salary
from Mytable;
I have tried
select substr(name,1,20), age, salary
from Mytable;
but that does'n work.
I have also tried options linesize=200;
but that seems to make the column NAME even wider.
Does anyone have any suggestions how to code it ?
Regards
Rune Runnestoe
|