I have  some tables in html. How do I save them as EXCEL spreadsheets with formatting?   ... View more

Good points, @SASKiwi, @Kurt_Bremser.   I think controls are very necessary, the bigger the contract and responsibilities, the most careful in controls. As said, I think any company outsourcing any service, should not let go completely the ownership, since, in the end, it is yourself who answer the questions.   In other hand, a couple of additional comments:   - I think the question (correct me if wrong) is not that focused on SAS Datawarehouse service (which would be great) but just SAS Admin. And this service does extensively exist, as SAS Application Maintenance, at SAS and Partners spread along the globe. Some with more expertise and quality, some with less. But hourly rates and service packages are also different amongst them.   - I also would like to say that my experience says about control, double-verify contract/actions/etc, specially in short term, but it tells me as well that trust and middle-ground is as much as important in the long run. It is healthy to bear this in mind. Interesting thing is that I saw delivery times, costs and relationships to deviate a lot... not because anything else than trust. ... View more

Can you please send me details on how you were able to use Sim Studio from JMP on Windows?  Before assessing whether it's possible on Linux, we want to fully understand what you did on Windows.  At this point, I think we are at a level of detail that warrants transitioning to email communication;  my email address is Ed.Hughes@sas.com. Thanks! ... View more

I'm not sure if this will work for you but I was able to get the validation and emi scripts to work by copying the emi-framework folder to the $SAS_config/Web/SASEnvironmentManager/grid/$grid_node folder at the same level as the agent folder.   [root@xnzxpwa102x xnzxpwa102x.nndc.kp.org]# ll total 24 drwxr-xr-x.  8 sas Sas 3864 Nov  8 15:43 agent-5.8.0-EE drwxr-xr-x. 11 sas Sas 3864 Aug 31 13:33 emi-client drwxr-xr-x. 18 sas Sas 3864 May 24 15:21 emi-framework ... View more

Hi,   I found a pretty cool add-in to Base SAS on www.tatesoft.com that may be very usefull to you. The tool called Log Analyser is integrated into Base SAS and can produce Log summary report in a second. You may also analyse log in details if you wish. Really great tool! ... View more

I think I found it..... SYSTASK with WAITFOR should do the trick. Thanks ... View more

Are you trying to point the libref to a different location? Or are you just re-running the code that assigned the libref? If the latter then test first before defining the library.  Here is can example command using the IFC and LIBREF functions to conditionally issue the libname statement only when the libref does not already exist. 4    %sysfunc(ifc(%sysfunc(libref(macros)),libname macros '~/temp',)); NOTE: Libref MACROS was successfully assigned as follows:       Engine:        V9       Physical Name: /home/abernt/temp 5    %sysfunc(ifc(%sysfunc(libref(macros)),libname macros '~/temp',)); The other thing to consider is changing the SASMSTORE option before trying to modify the libref. ... View more

Ahhh. Just the opposite of what I thought it should be Thanks. ... View more

Hi: When you use the tasks and wizards in the SAS Add-in for Microsoft Office, you are essentially using the same tasks and wizards as the SAS Enterprise Guide tasks and wizards. You might find more help, therefore, in the Enterprise Guide forum. In addition, this paper talks about how to customize graphs using the EG wizards, it might be of some help. http://support.sas.com/resources/papers/proceedings10/236-2010.pdf cynthia ... View more

Hi! If intend to use picture format you do not have to multiply the value it is in the picture..... proc format; picture negpct 0 - high = '009.999%' (mult=100000) low - 0 = '009.999%' (prefix='-' mult=100000) ; run; ... View more

Hi: You might want to work with Tech Support on this question. I don't believe that what you want can be done with stored processes in AMO with the 9.1.3 version of the Enterprise Intelligence Platform or whether it could be done with the 9.2 version of the Platform. Tech Support would know (or could find out) definitively. cynthia ... View more

Correction (truncated info): "When working with a DATA step and using a function, you specify one or argument(s) as string constant (in quotes or double-quotes) and/or one or more SAS variables, and ...". Scott Barry SBBWorks, Inc. ... View more