Hi, Actually, my basic problem is I have too much stuff in the title part that should be displayed for all the pages of the report. With compute block I am not getting proper alignment in ods pdf. so I used PROC report for soem of the titles part. Basically I want to achieve the following things which are not working right now: 1. Both left and right alignments in a single line statement(compute block) which is not happening so I used proc report. 2. I want result for each 'make' on separate page. 3. Also the header block (with name,address info) should appear on each page just below the titles. My Code goes somewhat like below: PROC SQL; CREATE TABLE header1(TEXT1 CHAR(30), TEXT2 CHAR(30), TEXT3 CHAR(30)); INSERT INTO header1 SET TEXT1="Name:..... ", TEXT2="text....", TEXT3="macro variable..." SET TEXT1="Contact no.......", TEXT2="text......", TEXT3="macro variable..." SET TEXT1="Adress1...... ", TEXT2="text...", TEXT3="text...." SET TEXT1="Adress2..........", TEXT2="text...", TEXT3="text...." SET TEXT1="text", TEXT2="text...", TEXT3="text...."; RUN; ods pdf file="C:\Users\sxkamtekar\Desktop\xyz.pdf" startpage=no; ods escapechar="^"; TITLE1 JUSTIFY=CENTER font=ARIAL height=8pt "Title1" HEIGHT=8PT JUSTIFY=RIGHT "PAGE#: ^{thispage}"; TITLE2 JUSTIFY=CENTER FONT=ARIAL HEIGHT=8PT "Title2"; TITLE3 JUSTIFY=CENTER FONT=ARIAL HEIGHT=8PT "Title3" HEIGHT=8PT JUSTIFY=RIGHT "Run Date: %sysfunc(date(),MMDDYY8.)"; TITLE4 " "; TITLE5 JUSTIFY=CENTER FONT=ARIAL HEIGHT=8PT "Title5"; TITLE6 JUSTIFY=CENTER FONT=ARIAL HEIGHT=8PT "Title6"; TITLE7 " "; PROC REPORT DATA=header1 noheader NOWD STYLE(REPORT)=[RULES=NONE CELLPADDING=1 bordercolor=LIGHTgrey borderwidth=0.5 FONT_FACE=arial ] STYLE(COLUMN)=[FONT_FACE=ARIAL FONT_SIZE=8PT ]; COLUMN text1 text2 text3; DEFINE text1 / display style(column)=[just=left cellwidth=2in]; DEFINE text2 / display style(column)=[just=left cellwidth=1.5in]; DEFINE text3 / display style(column)=[just=left cellwidth=1.5in]; RUN; proc report data=sashelp.cars (obs=35) STYLE(REPORT)=[RULES=NONE CELLPADDING=1 frame=void FONT_FACE=arial font_size= 8pt ] STYLE(COLUMN)=[FONT_FACE=ARIAL FONT_SIZE=8PT ]; COLUMN make model type origin msrp; DEFINE make / group STYLE(COLUMN)=[CELLWIDTH=1IN JUST=left]; DEFINE model / DISPLAY STYLE(COLUMN)=[CELLWIDTH=1IN JUST=left]; DEFINE type / DISPLAY STYLE(COLUMN)=[CELLWIDTH=1IN JUST=left]; DEFINE origin / DISPLAY STYLE(COLUMN)=[CELLWIDTH=1IN JUST=left]; DEFINE msrp / sum STYLE(COLUMN)=[CELLWIDTH=1IN JUST=left]; break after make / page summarize suppress STYLE=[FONT_WEIGHT=BOLD]; run; ods pdf close; --- Arya
... View more