BookmarkSubscribeRSS Feed
SASuserlot
Barite | Level 11

I am exporting dataset to excel file however, length of my variable string is 150$ so I assigned that, but when am proc reprting getting an erro

"ERROR: The width of "<variable>" is not between 1 and 102. Adjust the column width or line size. 

but I never assigned the line size  how to fix this error.

2 REPLIES 2
jimbarbour
Meteorite | Level 14

Can you post the code and the log please?  Please use the SAS code and the other code (for the log) button. 🙂

 

Jim

jimbarbour_0-1602031087433.png

 

SASuserlot
Barite | Level 11
Hi Jim, thanks for suggestion, I am new to this community, I will do as next time onwards. Also found the solution for my question. I need to close the destination or any similar files, in my case, I need to close all excel files before I run the program. because it predetermining the length based on the open file.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1007 views
  • 1 like
  • 2 in conversation