SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
radha009
Quartz | Level 8

Here is the code i have this issue on lot of my programs. How do i resolve this i added ls =256.

 

ods excel options(sheet_name='test' absolute_column_width="20,8");
options nodate pageno=1 ps=60 ls=256;
proc report data=cloud.fruits;
run;
ods excel close;
ods listing close;

 

ERROR: The width of cloumn name is not between 1 and 256. Adjust the column width or line size.
NOTE: This affects LISTING output.

2 REPLIES 2
ballardw
Super User

Which output do you actually want, Listing or ODS Excel?

That message is most likely related to the Listing destination. If you want ODS Excel then close the listing before opening the ODS Excel destination.

DrAbhijeetSafai
Lapis Lazuli | Level 10

Many thanks @ballardw ! This was very useful.

 

Thanking you,

Yours sincerely,

 

- Dr. Abhijeet Safai

Dr. Abhijeet Safai
Certified Base and Clinical SAS Programmer
Associate Data Analyst
Actu-Real

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 2954 views
  • 1 like
  • 3 in conversation