Hi, I published a SAS Report from SAS Enterprise Guide to SAS Web Report Studio. My Problem is when i open the portal/wrs, the sas style is diffrent from the style in the EG. I want to see get the AMODefault style. If I'm using the url portlret instead of the publish option it works fine any suggestions ? Example of my report: ods html STYLE=AMODefault STYLESHEET=(URL="file:///C:\inetpub\wwwroot\BIClientStyles\AMODefault.css"); proc report data = m_m_2 ; title1 'דוח התחשבנות חוזי ברמת חברה'; column Hevra Premiums Commissions 'Paid Claims'n 'Premium Reserve Retained'n 'Premium Reserve Released'n 'Interest On Deposit'n 'Tax On Interest'n Balance Outstanding; define Hevra/format=$n_hevra. group; define Premiums / sum format=comma10.; define Commissions / sum format=comma10.; define 'Paid Claims'n / sum format=comma10. 'Paid Claims'; define 'Premium Reserve Retained'n / sum format=comma10. 'Premium Reserve Retained'; define 'Premium Reserve Released'n / sum format=comma10. 'Premium Reserve Released'; define 'Interest On Deposit'n / sum format=comma10. 'Interest On Deposit'; define 'Tax On Interest'n / sum format=comma10. 'Tax On Interest'; define Balance / sum format=comma10.; define Outstanding / sum format=comma10.; title2 "&title"; compute before _page_; text1="&date_report Mid Quarter $1=NIS &Mid_Quarter "; line text1 $; text2=" "; line text2 $; endcomp; run; ods html close; ... View more

Hi, Im using tagsets excelxp with the following options: OPTIONS( embedded_titles='yes' embedded_footnotes='yes' Autofit_Height= 'YES' ); In the code im having a title statment like this: title1 j=left color=black underline=1 "I.L.D INSURANCE CO. LTD " j=center color=black " BORDERAU FOR REINSURANCE FOR MONTH &date_run"; in the output the results are 2 titles instead of 1: The first title is I.L.D INSURANCE CO. LTD and the second (below the first title): BORDERAU FOR REINSURANCE FOR MONTH &date_run. How can i get the title to be one and not seperated like, like i get if im using ods html? Thanks in advance ... View more

Hi, I build a proc report and i tried to create a style on a specific column (_c4_). The problem is that i want the style to apply to the column heading as well (and not only to the cells) a short example to my proc report: proc report data=pol_10 nowindows split='|' out=a; columns Ezor_c Hoze ,(Stscbt By_zone) Commerical; define Ezor_c/'zone' group; define Hoze/across format=hoze_label.; define Stscbt/'Stscbt' sum format=comma20.; define By_zone/'%|By Zone ' computed format=percent15.2; define Commerical/'100%|Commerical ' format=comma20. ; rbreak after / summarize ; compute after; Ezor_c='TOTAL'; if _break_ = '_RBREAK_' then do; call define(_row_,'style','style={font_weight=bold}'); end; endcomp; compute By_zone; _c3_=_c2_/&sum_207; _c5_=_c4_/&sum_503; *the style apply only to the cells; call define('_c4_', "style", "style={background=gray}" ); endcomp; compute Commerical/ ; Commerical=sum(_c2_,_c4_); endcomp; quit; Could you please guide me? have a wonderful holiday season and happy new year. ... View more

Hi, I have two datetime variables, and i want to count the time intevals between them. e.g: 03MAY2010:12:48:00 24FEB2010:08:50:00 the result should be -3.58h Ant suggestions? ... View more