This is more of data issue than stored process issue.   This excel is opening when we extract data for the date range(parameter) 01Jan2014 to 31Dec2016. Not opening for the date range 01Jan2014 to 31Dec2014.   I have run the same code in EG and getting the same error when I open  the excel file.   I am using the below for creating the report.   PROC REPORT data=REPORT_DS split="*" headskip style(header)={background=cx113388 color=cxffffff}; BY CEDENT_DETAILS REINS_PROG_ID BUS_ID BUS_TTL LAYER_NO INCEP_DATE CANC_DATE BROKER_DETAILS PROP_NOPROP ; column sort_order name YEAR&yr3 YEAR&yr2 YEAR&yr1 ; define sort_order/ORDER noprint; define name/"UWY" DISPLAY; define YEAR&yr1./" &yr1 " &stp_format_lead_zero. ; define YEAR&yr2./" &yr2 " &stp_format_lead_zero. ; define YEAR&yr3./" &yr3 " &stp_format_lead_zero. ; compute NAME ; if NAME="Underwriting result" then call define(_row_,'style','style=[font_weight=bold]'); endcomp; RUN;   Please let me know if you find any issue in this code.   Thanks, Sampath ... View more

Hi,   This #byval is resolved only inside ODS layout .   If we code outside ODS layout, it wont be resloved.   Whatever code given is just a sample code. I want to replicate this logic in my actual code.   Thanks, Sampath ... View more

I am attaching sample sas code, log and report(by value F is not printed in 2nd page) for this issue. ... View more

Hi ,   I am writing a pdf page with leftmargin = 2cm. As per my requirement, I need to write some text in the margin area. Is it possible?   I was using ODS REGION X= -0.53cm to write this text in SAS9.2. It was working fine. In SAS9.4, This code is writing the text in x=0cm instead of -0.53cm. I know that only nonnegative values are allowed in x option as per sas online doc.   Please suggest alternate solution to fix this issue in SAS9.4.     Thanks, Sampath ... View more

Hi,   Thanks for the idea. But it is also not giving desired result.   Is there anyother way to have the left margin = 2cm from 2nd page onwards?   I have already tried Proc document and replay it to write the final pdf tile to combine 1st page and the remaining pages. It is also not giving desired result.   Even I tried to change using proc template to change the leftmargin..It is not working.   My requirement:   I am generating 50 PDF files(Each file can have different no of pages in the range of 5 to 20 pages) thru online/Batch with first page using ods layout and ods region with leftmargin =0cm. Only this page is static. Remaining pages are dynamic.   From 2nd page onwards(till the eof),PDF files should have leftmargin=2cm. Currently the final pdf file is having 0cm as leftmargin in all the pages even if I change it after first page using option leftmargin = 2cm.   This is the requirement.   Thanks, Sampath       ... View more