Increase your line size.
Option linesize=xxxxx;
Note that this only applies to the listing destination. If you're using Word, PDF or HTML you're probably seeing the error because you didn't turnoff the listing destination.
columns visit dt col1 col2 col3 ; define visit / id display ; define dt / id display; define col1 / display; define col2 / PAGE; define col3 / display;
dint work .
Also when i increase the size to more than 256 i get the error
ERROR 18-12: Option value for SAS option LINESIZE must be between 64 and 256.
These options might give you some help.
options orientation=landscape topmargin=0 bottommargin=0 leftmargin=0 rightmargin=0;
@Almoha wrote:
it works on pdf destination.
but i really want the output in rtf using listing destination
##- Please type your reply above this line. Simple formatting, no
attachments. -##
That doesn't make sense. Either you want RTF or Listing, how do you get rtf via lisintg?
i think you need to post your full code and log - including ODS RTF statement.
Hi @Almoha,
I would specify reasonable column widths in the relevant DEFINE statements and add the FLOW option to avoid truncation.
Example:
define col1 / display width=30 flow;
Edit: I should have mentioned that the above recommendation is aimed at the listing destination. As Reeza and Cynthia pointed out, the modification may be unnecessary for other destinations (using proportional fonts).
I tried by reducing the length of variables. It fixed that log note. here is the code. If the length of variables col1 col2 col3 is 200 then it throws that error. I tried by reducing, 175 was the best length which fixed that error note.
data test;
length col1 col2 col3 $175;
call missing(col1,col2,col3);
visit=1;
dt=1;
output;
visit=2;
dt=2;
output;
run;
proc report data=test missing nowd split='`';
columns visit dt col1 col2 col3 ;
define visit / id display ;
define dt / id display;
define col1 / display;
define col2 / display;
define col3 / display;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.