What is the hex color code for the htmlblue background color?   I found cxEDF2F9 but can still see a line when applied to the borders in my table where I do not want them to appear.   compute after /style = [just = l borderbottomcolor = cxEDF2F9 borderrightcolor = cxEDF2F9 borderleftcolor = cxEDF2F9 fontsize = 7pt]; line 'Note: Groups A and B were combined in this report.'; endcomp; ... View more

Using the following code, a blank page appears as the first page in the report (landscape orientation): %Let Rpt_FS=[Fontsize=0.3] ; %Let Rpt_HDR_FS=[fontsize=1 font_weight=light ]; ods PDF file="c:\Portfolio_Report.pdf" style=HTMLBLUE Startpage=NO pdftoc = 1; title1 "Analysis for the Period"; proc report data = select_data style(column)=&Rpt_FS style(header)=[fontsize=1 BACKGROUNDCOLOR=#4F81B9 FOREGROUND=White] Style(report)=[cellpadding=1 ] style(summary)=[font_weight=bold bordertopwidth=.1pt bordertopstyle=solid bordertopcolor=black borderbottomwidth=.1pt borderbottomstyle=solid borderbottomcolor=black BACKGROUNDCOLOR=#4F81BD FOREGROUND=White] out = xxx; column mmsort ('Major' major) ('Group' group) ('LOB Market' lob_market) ("Amounts in 000s " rr),balance ; define mmsort / ' ' group noprint order = internal; define major/ '' group format = $F_MAJ. mlf style(column)=[cellwidth = 1.0in] ; define Lob_market / '' group format = $f_lob. mlf order = data style(column)=[cellwidth = 0.9in]; define group / '' group style(column)=[cellwidth = 2.75in]; define rr / ' ' format = f_rr. across order = internal style = [cellwidth = 0.7in] ; define balance / ' ' format = comma32. ; compute major/length = 100; if UPCASE(_break_) = "_RBREAK_" then do; major = "Total"; end; else if upcase(_break_) = "MAJOR" and group = ' ' then do; major = "Total "||strip(major); end; endcomp; compute group / length =100; if upcase(_break_) = "GROUP" then do; group = "Total "||strip(group); major = ' '; end; endcomp; break after major/summarize; rbreak after / summarize; break after group/summarize; run; ods pdf close;   ... View more

I have a left table with 153 unduplicated observations and a right table with 15000+ observations.   If I use a where clause on the left table it only returns 153 records. If I remove the where clause and subset the data prior to query processing it returns the correct result (201 records). Why does this happen? Should it not return the same number of records? It acts like an inner join if the where clause is present regardless of the join used.   This returns 201 records (correct); proc sql; create table checkit as select a.an, b.an as cfa, b.load_date, b.amount, b.data_source, b.fa_code from list a left join rfcorex b<<<-subset prior to query processing on a.an= b.an ;   This returns 153 records (inner join behavior  - not correct) proc sql; create table checkit as select a.an, b.an as cfa, b.load_date, b.amount, b.data_source, b.fa_code from list a left join rfcore b<<<-no subset prior to query processing on a.an= b.an where b.data_source contains "XXXXX" ... View more

When building a listing report, ODS is causing text variables to wrap where some spaces are. I used the TAGATTR to remove the wrapping, but then the spaces disappear in some spots in the text variables giving the appearance of names that are run together. They do not appear this way in the dataset. Suggestions as to a workaround?       ods excel file="aaa.xlsx"  options(SHEET_NAME='Recap' autofilter = 'All' embedded_titles='Yes'     absolute_column_width='20,8,30,30,15,14,14,14,14,14,14,14,14,14') style = htmlblue;   Title "YTD Recap for the Period Ending  &Rpt_AS_OF"; Title2 "Summary Report as of &Rpt_Date";   proc report data = recap2 nowd contents = ' '  ; column     name code market area PD_CM_PTS CA_CM_PTS FIN S1_CM_PTS S2_CM_PTS CR NARR COV NUM_POL ZZZ;     define name /  "Name"   style={tagattr='wrap:No'};     define code /  "Code"  ;     define Market / "Market" format = $mkt.  order = data style={tagattr='wrap:No'} ;     define area / "Area" format = $area.  order = data style={tagattr='wrap:No'} ;     define CR/  'CR' format = f8.2 ;     define CA_CM_PTS / 'CC ' format = f8.2 ;     define PD_CM_PTS / 'PD' format = f8.2 ;     define S1_CM_PTS / 'S1' format = f8.2 ;     define S2_CM_PTS / 'S2' format = f8.2 ;     define FIN / 'Fin.' format = f8.2 ;     define NARR / 'Narr.' format = f8.2 ;     define NUM_COV / 'Cov' format = f8.2 ;     define NUM_POL / 'Pol' format = f8.2 ;     define ZZZ  /'Overall' format = f8.3 ; run; ODS excel CLOSE;   NOTE: There were 158 observations read from the data set WORK.RECAP2. NOTE: PROCEDURE REPORT used (Total process time): real time 0.59 seconds cpu time 0.56 seconds   NOTE: Writing EXCEL file: \aaa.xlsx ... View more