Can this be done? I see posts related to IML but I do not have access to IML. Can this be done directly or does it have to be exported to some other format then imported to SAS?  ... View more

When using PROC REPORT to perform a transposition, the procedure produces a blank tab in the workbook, which is not desired as all define statements are set to NOPRINT as shown below. Since I prefer to to use PROC REPORT for this and not PROC TRANSPOSE, is there a way to suppress this behavior? As it is each time a similar PROC REPORT step is encountered in the code, an additional tab (blank) is produced prior to the actual written final report.   PROC REPORT DATA = AEDECODB OUT = AEDECODP NOWD ; COLUMN SYSTEMORGANCLASS AEDECOD EYEFL,COHORT,( PCT EVENTS) DUMMY; DEFINE AEDECOD / ' ' GROUP NOPRINT; DEFINE SYSTEMORGANCLASS / ' ' GROUP NOPRINT ; DEFINE COHORT / ' ' ACROSS ORDER = FORMATTED noprint; DEFINE EYEFL / ' ' ACROSS ORDER = FORMATTED noprint ; DEFINE PCT / ' ' NOPRINT; DEFINE EVENTS /' ' NOPRINT; DEFINE DUMMY/ ' ' NOPRINT; RUN; ... View more

If text runs past a cell border in ODS PDF what options are there to force it to remain within the border lines?  ... View more

I used the PARSKIP functionality as shown in the template below, but it did not affect the spacing between the tables in ODS PDF. Was it applied incorrectly?   proc template; define style styles.BlueK; parent=styles.pearl; class colors / 'link2' = cx0000FF 'link1' = cx800080 'docbg' = cxFAFBFE 'contentbg' = cxFAFBFE 'systitlebg' = cxFAFBFE 'titlebg' = cxFAFBFE 'proctitlebg' = cxFFFFFF 'headerbg' = cxEDF2F9 'captionbg' = cxFAFBFE 'captionfg' = cx112277 'bylinebg' = cxFAFBFE 'notebg' = cxFAFBFE 'tablebg' = cxFAFBFE 'batchbg' = cxFFFFFF 'systitlefg' = cx112277 'titlefg' = cx112277 'proctitlefg' = cx112277 'bylinefg' = cx112277 'notefg' = cx112277; class Header / bordercolor = cxB0B7BB backgroundcolor = cxEDF2F9 color = cx112277; class RowHeader / bordercolor = cxB0B7BB backgroundcolor = cxEDF2F9 color = cx112277; class fonts / 'TitleFont2' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv",2, bold) 'TitleFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv",3,bold) 'StrongFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv",2, bold) 'EmphasisFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv",2, italic) 'FixedFont' = ("<monospace>, Courier",2) 'BatchFixedFont' = ("SAS Monospace, <monospace>, Courier, monospace",2) 'FixedHeadingFont' = ("<monospace>, Courier, monospace",2) 'FixedStrongFont' = ("<monospace>, Courier, monospace",2,bold) 'FixedEmphasisFont' = ("<monospace>, Courier, monospace",2,italic) 'headingEmphasisFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv",2,bold italic) 'headingFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv",2, bold) 'docFont' = ("<sans-serif>, <MTsans-serif>, Helvetica, Helv",2); class Table / cellpadding = 2pt; style systemfooter from titlesandfooters / font_weight=light font_size=8pt; Style parskip / fontsize=4Pt; end; run; ... View more

How can one scan inside an EG project from another EG project looking for certain keywords? The purpose would be to determine where a specific table was referenced without having to manually open every project. ... View more