Hi, Thanks for the response. I have found a command that can perform this. TASKKILL is an executable available on windows and has a lot of parameters to filter processes to kill. Albert ... View more

Problem is solved by changing security settings IE: Security: "Initialize and script ActiveX control not marked as safe" was disabled and must be enabled. ... View more

Hi Cynthia: There are no more title_size suboptions available for the tagset tableeditor. But I think that your solution with the title statement is a good workaround. The only little mistake is that f=10pt needs to be h=10pt. Anyway thanks for the solution. If you don't want to alter the style template (one solution), then a different solution would be to try this at the statement level (whereever your TITLE statements are): title2 f=10pt 'Title 2 text'; title3 f=10pt 'Title 3 text'; etc, etc Albert ... View more

Macro and SAS code: /*--------------------------------------------------------------------- ! ESRMGL46 : Macro to CREATE directly formatted EXCEL ! : ! Author : CST - Albert Jacobs (AJA) / Jos Van der Plancken (JVDP) ! Parm : !--------------------------------------------------------------------- ! Date !Vs! Opdracht / Contract ! Name !--------!--!-------------------------------------------------!------- ! !00! Start development / in production ! AJA/JVDP ! !00! ! ! !00! ( see ECAR 1283166 ) ! ! !00! macro ESRMGL46: added this info Header, ! DDE ! ! ! ( =in accordance with STANDARD PROCEDUREs ! !28/04/09!00! Prepared for ValueSource ! DDE '---------------------------------------------------------------------*/ %macro esrmgl46(size=10); libname t1047 'esrpt000.dsns.t1047.templat.test' disp=shr; ods path t1047.templat(read) sashelp.tmplmst(read); ods tagsets.tableeditor file=_webout rs=none style=t1047.mystyle options(excel_zoom="90" excel_scale="90" excel_frozen_headers="yes" sheet_name="Table" excel_table_move="1" file_format="ext" nowrap="yes" fontfamily="arial" header_size="&size" rowheader_size="&size" data_size="&size" title_size="15" ); %put &sysver; %mend; %macro esrm5702; /*---------------------------------------------------------------. ! esdm5702: Detail cijfers-Alle modellen ! ! Auteur: CST - Jan Van Lint ! ! Rapitweb : KPI4 Verhouding stock-repair per week ! ! Alle modellen ! !----------------------------------------------------------------! ! Datum !Vs! Opdracht ! Naam ! !--------!--!-------------------------------------------!--------! !04/07/07!00! begin ontwikkeling ! Jan ! .----------------------------------------------------------------*/ libname geg 'ESCPT000.DSNS.ASSET.WEEK.test' disp=shr; data wkpi4; set geg.assets; where status ='Operational' or (status='Repair' and (stock='KBC MAG - HP' or stock =: 'KBC MAG - DROPPOINT')); if stock =: 'KBC MAG - DROPPOINT' then do; stock = 'KBC MAG - DROPPOINT'; end; run; proc sort data=wkpi4; by model status; run; data kpi4 (keep=model statuscode rep oper perc); set wkpi4; by model status; if first.model then do; rep=0; oper=0; end; If status= 'Repair' then rep+1; else oper+1; If last.model then do; if oper = 0 then Perc=100; else Perc=round((rep*100)/oper,.01); output kpi4; end; run; proc sort data=kpi4 ; by model; run; /* Sorteren van de gebruikerstabel per model */ proc sort data=geg.models out=tabm (drop=kpi5 group5); by model; run; /* Merge van de bestanden*/ data kpi4m; merge kpi4 (in=in1) Tabm (in=in2); by model; if in1 and in2; run; proc sort data=kpi4m; by kpi4 model; run; data _null_; call symput('fjaar',compress(year(today()))); run; data _NULL_; date=date(); weekt=int(( date+(6-(mod(date,7))-7*((mod(date,7))<3))- mdy(1,1,year(date+(6-(mod(date,7))-7*((mod(date,7))<3)))))/7); call symput('weekt',compress(weekt)); run; options nodate pageno=1 symbolgen mprint missing = ''; %esrmgl46; title 'Assets in repair in proportion to operational assets'; title2 h=50 'All models'; title3 "For week &weekt of &fjaar"; proc report data=kpi4m box nowd ls=120; column KPI4 model statuscode rep oper perc; define kpi4 / order 'Type' width=10; define model / order width=40; define statuscode / order width=40; define rep / display 'Repair' width=7; define oper / display 'Operat.' width=8; define Perc / display 'Perc' format=6.2; compute perc; if (oper < 100 and perc > 5) or(oper >100 and perc>2) then call define (_col_,"style","style={background=red}"); endcomp; run; ods tagsets.tableeditor close; %mend esrm5702; ... View more

Some more explanation: We only use a procedure on an existing dataset. This dataset can contain 10000 observations, but with a where clause the result could be 0 observations. Albert ... View more

That 's the reason why I suggest for the creation of a new automatic macrovar with the number of observations read or write by a procedure with a where clause. Internally SAS knows this number because you could see it in the log. The availability of such a macrovar gives a lot of possibilities without preprocessing the data or the need for reading twice. Albert ... View more

Yes, I know the exitence of SQLOBS in PROC SQL. But what I suggest is that we need a automatic macrovar like SQLOBS that we could use in all the procedures when we use a WHERE clause. In this case PROC PRINT with a WHERE statement. Albert Jacobs ... View more

Thanks for your reply, but what I want to know is the availability of a macrovar. If such a var exist, then we don't need to read the data twice. Maybe a suggestion for the SASware ballot. ... View more

Peter, The support at SAS Global Forum 2008 was really a breakthrough for the use of all the markup templates, not only EXCELXP. This means that we can use a lot of new features en reports for our SAS/Intrnet applications on mainframe. Attending SAS Global Forum only for this is already worthwhile. We were already waiting more than a year for this solution. Mickael has sent me other solutions, but yours works also. The abend with Excelxp tagset is because of our PRX functions. In 9.1.3 these prx functions do not work very well with encodings other than the compiler encoding which is Ebcdic1047 (or Open_ed-1047). This problem has been fixed in 9.2 The only workaround in 9.1.3 in order to use this tagset from a session encoding different than 1047, Open_ed-1148 in your case, is to used a 1047 compiled tagset. Here the steps in order to get a 1047 compiled tagset: 1) upload a compile the tagset using sas/Connect. On the pc, start SAS with the LOCALE option set to en_US -LOCALE en_US On the Mainframe, start the remote session to remote submit the tagset pgm with the following options: nonlscompatmode locale=en_US encoding=Open_ed-1047 Assign a new library that will contains the 1047 compiled tagset: libname t1047 "mynew.library.lib" ; Update the tagset source code and change the following line define tagset Tagsets.ExcelXP / store = t1047.templat ; define tagset tagsets.config_debug / store = t1047.templat; Remote submit the tagset pgm. 2) Test the 1047 compiled tagset from a 1148 SAS Session. From your SAS session on MVS, using Open_ed-1048, you have to assign a libname to the library that contains the 1047 compiled tagsets. libname t1047 "mynew.library.lib" ; and then, you have to update the ODS path to pick up first the 1047 compiled tagset ods path t1047.templat(read) sashelp.tmplmst(read); Thanks. Albert ... View more

Peter, After the SAS Global Forum I received a solution from Mickael Bouedo: Start SAS with NONLSCOMPATMODE LOCALE=NL_BE. This works fine for most of the templates. Only for excelxp we still have problems with tagattr and numeric fields. Could you please explain in detail how you have downloaded the tagsets. When I go to http://support.sas.com/rnd/base/ods/odsmarkup/index.html, I see the [], $.... If I compile with your params then I receive again the errors. Thanks. ... View more