topic Re: proc print cell width in ODS and Base Reporting

proc print cell width

deleted_user — Tue, 06 Feb 2007 21:44:42 GMT

Hi, I am useing ods pdf output from proc print. (sas 9.1)

I have text fields that are very long ($ 5000 length). I am losing data when I output these fields into pdf.

Please help.

Sk.

Re: proc print cell width

Cynthia_sas — Wed, 07 Feb 2007 03:16:24 GMT

I'm stumped. I made a dataset with a character variable that is 5304 bytes long and the dataset had other variables. I do not see any truncation in the PDF output file.

My character variable is composed of the poem, "Jabberwocky" plus some other text -- repeated to a length of 5304. So, my character string has spaces where PDF can wrap the line. Does your variable value have spaces, where PDF can try to wrap the line??

Your best bet might be to contact Tech Support. To find out how to contact them refer to this site:
http://support.sas.com/techsup/contact/index.html

Good luck!
cynthia

Re: proc print cell width

prholland — Wed, 07 Feb 2007 16:30:27 GMT

Is there any format applied to the long fields? It may be worthwhile to add a FORMAT statement to the PROC PRINT step to reset formats to default, e.g.:

PROC PRINT DATA=dsn;
VAR col1 col2 longcol3;
FORMAT col1 col2 longcol3;
RUN;

........Phil Holland

Re: proc print cell width

deleted_user — Wed, 07 Feb 2007 19:29:59 GMT

thank you both for your reply. I adjusted the size of the cells (cellwidth and cellheight) and it is working now.

Sk