Hi to all: I have this lovely report that I spent a lot of time on, that uses PROC PRINT to create a hard copy report. My client has now requested that the report be saved a s an Excel spreadsheet and look exactly the same :smileyalert: My problem is that the current hardcopy report has a BYLINE and I can't seem to reproduce it using ODS and EXCELXP. Some info:  I am using SAS 9.1.3 on Windows using ODS and tagsets EXCELXP v1.85.  I have "sheet_interval=none" in my EXCELXP options, I am using PROC PRINT and PROC REPORT to generate the report to a file (just to see if one had the error and the other didn't).  I have the same "BY" statement as in the hard copy code. Here is the odd thing - if I have "OPTION NOBYLINE", the resuting spreadsheets (both) are readable, but (obviously) there is no BY line.  If I code "OPTION BYLINE", I am unable to open either spreadsheet with that stupid (!!!) "Problems During Load" XML error on the "Table". Is there a way to get the BY line to print on the report?  I assume that it can be done with a BREAK BEFORE in PROC REPORT, but I would like it to look the same as in the original PROC PRINT. PROC REPORT CODE: * option byline;           *<----<< causes the problem *;   ods listing close;        run;                      ods tagsets.ExcelXP                          options(sheet_name='Summary'                       orientation='landscape'                papersize='LETTER'                     embedded_titles='yes'                 embedded_footnotes='yes'                 FitToPage='yes'                                            sheet_interval='None'                              suppress_bylines='no'                             zoom='90'                                         ROW_HEIGHT_FUDGE='1'                   absolute_column_width='12,12,12,12,12,12,12,12,12,12,12');    proc report data=reptdata   nowd split='*' missing        style(REPORT)={font_face=Arial font_size=9pt}        style(HEADER)={background=#eeeeee}                   style(SUMMARY)={font_face=Arial font_size=9pt};   BY var1  notsorted;         column var1 var2 var3 ...snip... var11;               define var1                / group        noprint;    define var2                / display      'label2';   define var3                / display      'label3';    ....snip....     define var11               / display      'label11';    rbreak after / summarize;   compute net;                          if _break_= '_RBREAK_' then var11 = var10.sum - var9.sum;                            else var11 = .;               endcomp;                                 TITLE1 j=c "FOR &rptdate";                           RUN;       ods tagsets.excelxp close;                  run;     ... View more

Hi All: I am using PROC GREPLAY to display 2 graphs side-by-side with ODS HTML output. Does anyone know how to put a TITLE on the resulting page that contains a hyperlink? I would like to create 2 HTML pages (with 2 graphs each) with hyperlinks that point to the other page. Thanks in advance. ... View more

Hi All: I'm no great shakes with Macro vars and processing, so I hope someone here can help out. I have this program: [pre] %let period=Daily; %include source(DAILY_PROCESS); %let period=Weekly; %include source(WEEKLY_PROCESS); %let period=Monthly; %include source(MONTHLY_PROCESS); %if %eval(day("&t_day"+1)) = 1 %then %do; %let period=Quarterly; %include source(QUARTERLY_PROCESS); %let period=Yearly; %include source(YEARLY_PROCESS); %end; [/pre] But I get an error on the %if statement- I can't use it 'in open code'. (Value of &t_day is yesterday). I'm sure you can see what it is that I am trying to do here. This is the entire program - there are no DATA steps until the process code is included. Thanks in advance. ... View more

Hi All: I have an image that I have added to my PROC REPORT that is a hyperlink when output using ODS HTML. Is there a simple way to center the image in the cell (left / right, not up / down). The cell is created with the width of the column header (which I can't change) and the image is much more narrow than the cell width (it is just a button to press) and it seems to be left justified. Thanks in advance. ... View more

Hi all: I'm not great with macros but I have a problem. How do I correct a 'divide by zero' when the values in question are macro variables? Here is a chunk of my code: [pre] proc sql; select unique count(*) into :d_rec_count from worka; select unique count(*) into :d_clo_count from worka where resolvedDT ne .; select unique &d_clo_count/&d_rec_count into :d_clo_percent from worka; quit; run; [/pre] but when the divisor in the last 'select' is 0 (zero), I get a message 'No rows were selected' and the value of &d_clo_percent is incorrect. I think what I need to do is check that the value of the divisor is zero and set d_clo_percent to 0 (zero) somehow. Thanks in advance. ... View more

Hi All: I thought that this would be easy, but apparently, I was wrong... All I want to do is add some "white" space between 2 words in a title. Because the output is HTML, if I just use spaces, I would need about a million to get an inch of white space, and that is not worth it. I used the escapechar="^" and the "^_" which adds a "nbsp;" (with an ampersand) between the words, but this really messes up the title (causes the title to wrap and removes the justification!) (I'm using v9.1.3) Thanks in advance. ... View more