Hi Team, I have to generate a report with hyperlink based on Year_Month column value. The hyperlink should be act on as per given highlighted value. I am able to generate the link with my existing .xls file. However the file generating for only one month value 2018M08. Dynamically it is not moving to next file based on Year_Month column value. Could you please assist me? data _null_;
set DATE_chk;
call symput('date'||left(_n_),trim(YEARMON));
call symput('date_c',_n_);
run;
FILENAME fileout "&path/Test-write-from-PC_Summary.html";
options number pageno=1 center nodate orientation=landscape;
ods listing close;
ods html file=fileout style=styles.printer;
proc report data=FINAL nowd headline headskip split = '|';
column YEARMON RCOMMITTEE TOT_SC TOT_PB TOT_PCT;
define YEARMON / "Year|Month" group center width=20
order=data style=[foreground=Blue font_size=2];
define RCOMMITTEE / "Regional Committee" center width = 30;
define TOT_SC / "Total Number of Applications" SUM center width = 5;
define TOT_PB / "Number Shipped to QM" center width = 5;
define TOT_PCT / "Exceptions" center format=percent7.2;
compute RCOMMITTEE; if RCOMMITTEE = 'ZZTOTAL' then
DO;
RCOMMITTEE = "** Total **";
call define (2,"style","style=[foreground=Blue font_size=2]");
END;
endcomp;
compute TOT_SC;
%do i=1 %to &date_c;
call define(_col_,"URL","test-m_&&date&i...xls");
%end;
endcomp;
run;
title;
run;
ods html close;
... View more
