I use Proc report to create TOC that has URL link to table within same PDF document using anchor= option. I use Do loop from 1 to 150 to set an incremental anchor for table created thru proc report ran within that loop. Anchor works perfectly fine and create Url within TOC for anchors 1 thru 9 but does not create URL for 10th and after. It starts working again starting at 91st anchor till 99th anchor. After lot of research found a documentation on SAA that says not all anchor values are valid. I am trying to understand why would anchor work for 1 to 9 and again 91 thru 99 and not work for any other values. Is there a way to fix this problem? Can you please help. DATA &filename._V1 (drop = num);
length TAG $5.;
RETAIN NUM;
SET &filename._V0;
NUM+1;
TAG=strip(cats('T',put(NUM,3.)));
RUN;
PROC TRANSPOSE DATA = &filename._V1 OUT = &filename._V2 (rename = (_name_ = METRIC col1=VALUE));
BY DESCENDING OBJECTIVE METRIC_NAME TAG;
VAR METRIC_FORMULA METRIC_DEFINITION_1 METRIC_DEFINITION_2 INCLUDE_EXCLUDE RELEVANT_OTHER TARGET_METHOD EG PRIMARY_LEVEL SECONDARY_LEVEL;
RUN;
PROC SQL; CREATE TABLE &filename._V3 AS
SELECT OBJECTIVE, METRIC_NAME, TAG
,CASE WHEN METRIC = 'METRIC_FORMULA' THEN 'Metric Formula'
WHEN METRIC = 'METRIC_DEFINITION_1' THEN 'Metric Definition - Numerator'
WHEN METRIC = 'METRIC_DEFINITION_2' THEN 'Metric Definition - Denominator'
WHEN METRIC = 'INCLUDE_EXCLUDE' THEN 'Inclusion / Exclusion'
WHEN METRIC = 'RELEVANT_OTHER' THEN 'Additional notes'
WHEN METRIC = 'TARGET_METHOD' THEN 'Target Method'
WHEN METRIC = 'EG' THEN 'Experience Group'
WHEN METRIC = 'PRIMARY_LEVEL' THEN 'KR Level - Primary'
WHEN METRIC = 'SECONDARY_LEVEL' THEN 'KR Level - Secondary'
else METRIC END AS METRIC
,VALUE
FROM &filename._V2
;QUIT;
PROC SQL; CREATE TABLE &filename._TOC AS
SELECT DISTINCT OBJECTIVE, METRIC_NAME, TAG, strip(cats("#",TAG)) as RTAG length = 6
FROM &filename._V3
ORDER BY OBJECTIVE DESC, METRIC_NAME, TAG
;QUIT;
OPTIONS NOCENTER ORIENTATION = PORTRAIT NODATE PAGENO = 1 NONUMBER NOBYLINE
TOPMARGIN = 0.5IN BOTTOMMARGIN = 0.8IN LEFTMARGIN = 0.8IN RIGHTMARGIN = 0.8IN;
TITLE;
FOOTNOTE;
ODS PDF FILE = 'TEST.PDF'
STYLE=PRINTER
STARTPAGE = BYGROUP
ANCHOR='REP'
UNIFORM NOTOC
;
ODS ESCAPECHAR ='^';
FOOTNOTE1 J=R COLOR ='#0077B2' HEIGHT=2 FONT = ARIALBLACK '^{THISPAGE}';
FOOTNOTE2 J =L COLOR ='#0077B2'
HEIGHT=5 FONT = ARIALBLACK bold 'KP DIGITAL '
HEIGHT=2 FONT = ARIAL ' Digital Dashboard'
HEIGHT=3 BOLD FONT = ARIALBLACK ' | Metrics Definitions';
ODS TEXT = '^S={just=C fontsize=35pt background=#1A3C6F color=white width=100pct} Metrics Definition';
ODS TEXT = '^S={just=C fontsize=10pt background=white color=white} ';
ODS TEXT = '^S={just=R
preimage="/gpfsFS2/sasdata/adhoc/po/dec/da/data5/Portfolio_view/data/Qualtrics Survey Button.png"
url="https://kp.co1.qualtrics.com/jfe/form/SV_eWZagVi59I2vLsW"}';
ODS TEXT = '^S={just=C fontsize=10pt background=white color=white} ';
ODS TEXT = '^S={just=C fontsize=20pt background=white color=#1A3C6F font_weight=BOLD} Table of Contents^n';
PROC REPORT DATA = &FILENAME._TOC NOWD SPLIT = ' ' NOHEADER MISSING;
TITLE3 J=CENTER BCOLOR=WHITE COLOR='#1A3C6F' HEIGHT=5 BOLD 'Table of Contents';
COLUMN RTAG OBJECTIVE METRIC_NAME ;
DEFINE RTAG /NOPRINT ;
DEFINE METRIC_NAME /GROUP;
DEFINE OBJECTIVE /NOPRINT GROUP ORDER ORDER = DATA;
BREAK AFTER OBJECTIVE / SKIP SKIP;
COMPUTE BEFORE OBJECTIVE/ STYLE =[JUST=L BACKGROUND=#1A3C6F FONT_SIZE=12PT FOREGROUND=WHITE FONT_WEIGHT=BOLD textdecoration=underline];
LINE OBJECTIVE $100.;
ENDCOMP;
COMPUTE METRIC_NAME;
/* RTAG = "#"||(TAG);*/
/* RTAG = cats("#",trim(TAG));*/
CALL DEFINE(_COL_,'URL',RTAG);
ENDCOMP;
RUN;
ods pdf startpage=now ;
%MACRO PDF_TABLE();
%LOCAL I;
PROC SQL NOPRINT;
SELECT COUNT(METRIC_NAME) INTO :MCNT
FROM &FILENAME._TOC;
QUIT;
%DO I = 1 %TO &MCNT;
ODS PDF ANCHOR="T&I.";
PROC REPORT DATA = &filename._V3 (WHERE=(TAG=%sysfunc(quote(T&I.,%str(%')))))
STYLE(Header)={background=charcoal foreground=white }
STYLE(column)={background=white foreground=black}
STYLE(report)=[rules=all bordercolor=charcoal width=100%];
TITLE1 LINK = '#REP' J=LEFT BCOLOR='CHARCOAL' COLOR=WHITE HEIGHT=5 FONT= ARIAL '>BACK';
TITLE2 HEIGHT=5 BCOLOR='white' COLOR=WHITE;
TITLE3 J=LEFT BCOLOR='#1A3C6F' COLOR=WHITE HEIGHT=5 FONT=ARIAL 'Objective: #byval(objective)';
BY DESCENDING OBJECTIVE METRIC_NAME ;
COLUMN OBJECTIVE METRIC_NAME METRIC VALUE;
DEFINE OBJECTIVE /noprint;
DEFINE METRIC_NAME / group noprint ;
DEFINE METRIC / '' ;
DEFINE VALUE / '';
COMPUTE BEFORE _PAGE_ / STYLE = [BACKGROUND=#0077B2 COLOR=WHITE FONTSIZE=5];
LINE @1 'KR / METRIC: ' @15 METRIC_NAME $150. ;
ENDCOMP;
BREAK AFTER METRIC_NAME / PAGE ;
RUN;
%END;
%MEND PDF_TABLE;
%PDF_TABLE();
ODS PDF CLOSE;
... View more
