Dear all, I have a forecast report which works fine in ODS HTML and ODS PDF. I'm now trying to display an image in the xls output. For the Excel Output I use ods tagsets.msoffice2k STYLE=sasdocprinter file=_webout; For the report I use the proc report procedure. The forecast report has a column at the right with an image (arrow up or down depending on the data on the left in the same row). This works in HTML like this: compute kz_tzqu; if kz_jahr_alt - kz_kw_alt > 0 then call define (_col_,"style", "Style=&v_url_red."); if kz_jahr_alt - kz_kw_alt = 0 then call define (_col_,"style", "Style=&v_url_blue."); if kz_jahr_alt - kz_kw_alt < 0 then call define (_col_,"style", "Style=&v_url_green."); end; endcomp; Where: %let v_url_red = [preimage='http://myserver/images/arrow_red.gif']; %let v_url_blue = [preimage='http://myserver/images/arrow_blue.gif']; %let v_url_green = [preimage='http://myserver/images/arrow_green.gif']; Could you tell me how I can do this in the ods tagsets.msoffice2k? Best regards, Eva ... View more

Dear all, we have a plot on pdf with many entries in the legend. The legend now gets so big that the plot gets too small. Is it possible to tell SAS to print the plot on one page and the legend on the next page? Unfortunately the legend also has long strings that are shortened automatically. Can I tell SAS not to do this? Best wishes and nice weekend, Eva ... View more

Dear all, I use inline style in my html output. I do this by adding a data field to my data in the data step: ods escapechar = '~'; data work.newfile; set myoldfile; newfield = "~S={font_weight=bold}blablabla~S={}~1n~S={font_size=-1}more text"; run; After that I run a simple proc report. So I have inline style for a font_weight, line break and font_size. Can I do that in excel as well? The above code does not work in excel output. Best wishes Eva ... View more

Hi! in a proc report I create a new row with compute and the line statement. Now I's like to set the background color of this row. However, the call define shows no effect. Here's my code: proc report mydata; column mycol1 mycol2; define mycol1 / group ''; define mycol2 / analysis sum ''; compute after mycol1; @1 line 'my group heading'; call define(_row_,'style','style={font_weight=bold backgroud=blue}'); endcomp; run; Best regards Eva ... View more

Dear all, I know there is a split attribute to the proc report statement. Is there anything like that for data cells? I'd like to set the split at a specific place. As I create the data for the relevant column in a data step before I could insert a special character to mark where the split should take place. Best regards Eva data myfile; set myinput; mycol1 = "This is data where I'd like to split*like after this star"; mycol2 = 1; output; mycol1 = "hello*next line"; mycol2 = 2; output; mycol1 = "another hello*another next line"; mycol2 = 2; output; run; proc report data=myfile; column mycol1 mycol2; define mycol1 / group; define mycol2 / analysis sum; run; How do I define for mycol1 split into 2 rows at the character * ? ... View more

Dear all, I'd like to have a drill down from a SAS PDF Output to another SAS PDF Output. The problem is that I have too many parameters to write them all in the url (the url gets too long). So the style an url attribute won't do that for me in the proc report: style=[url="/mystp&name1=value1&name2=value2"] I solved the problem in HTML by using method=post and hidden fields where I write down the parameter's value for which to drill down. put ''; put " "; The value is altered by a javascript when the user clicks on the report. I doubt that this works with PDF. Can anybody help? Best regards, Eva ... View more