I am using this proc report code to generate output in stored process, after generated the sequence numbers in title statement, will generate the output in ppt based on sequence numbers in title statement. i am initiating slideno =1 for first page, slide no is incrementing for each proc report graphs. i.e. for each output object(table or graph) i am giving unique slide number in title. so during page break, its generating multiple tables, so i want to have different sequence numbers in title statement.After generated #XXnnn## with proper title for each proc report or graph, in this XX is for object type and nnn is for page sequence number. this #XXnnn# would be useful to sort the objects before generate it in PPT. data summary_final1; retain Pgbrk 0 ; set summary_final1; if mod(_n_ ,25 ) = 1 then pgbrk + 1; Run; %let pot = %sysfunc(putc(&vdpId,prdlvlname.)); title "#6A&slideNo.#SUMMARY - &pot."; /* increase slide number, must be unique */ %increaseSlideNo; proc report data=summary_final1 nowd split='#' style(report)={rules=none frame=void cellspacing=0pt cellpadding=0pt font_style=roman font_size=8pt font_weight=bold font_face="Arial"} style(header)={foreground=white background=verydarkblue cellspacing=0pt cellpadding=0pt font_style=roman font_size=8pt font_weight=bold font_face="Arial"} style(column)={background=white cellspacing=0pt font_size=8pt font_weight=medium font_face="Arial"} split='*'; ; column Pgbrk CUSTOMER_ATTRIB_4_DESC CUSTOMER_NM %end; _&prev_year.YY_REQ %do i=1 %to &num_vars1; &&varaa&i %end; _N&curr_year.Y_ _N&curr_year.&prev_year._YoY %do i=1 %to &num_vars2; &&varba&i %end;; define Pgbrk / group noprint; define CUSTOMER_ATTRIB_4_DESC / group display 'Customer Units' order order=data style=[just=l vjust=t]; define CUSTOMER_NM / display 'Customer name' style=[just=l vjust=t]; define _&prev_year.YY_REQ / display "&prev_year.Y* *REQ" style(header)={background=cxeeeeee color=black} style(column)={background=cxeeeeee} analysis format=nlnum32.; %do i=1 %to &num_vars1; define &&varaa&i / display "&&varac&i* *&&varab&i" analysis format=nlnum32.; %end; define _N&curr_year.Y_ / display "&curr_year.Y* *REQ + F" style(header)={background=cxeeeeee color=black} style(column)={background=cxeeeeee} analysis format=nlnum32.; define _N&curr_year.&prev_year._YoY / display "&prev_year./&curr_year*YoY* " style(header)={background=cxbbbbbb color=black} style(column)={background=cxbbbbbb} analysis format=nlnum32.; %do i=1 %to &num_vars2; define &&varba&i / display "&&varbc&i* *F" analysis format=nlnum32.; %end; break after pgbrk / page; compute CUSTOMER_NM; /* Set bold text to last row */ if CUSTOMER_NM in ("") then do; call define(_row_,'style','style=[font_weight=bold]'); end; endcomp; run;
... View more
