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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.