I realy don't know the answer and need to reach out to a broader audience for help.    One of Our SAS users has a piece of code written in T-SQL. He wants us to Schedule it on SAS server. What can be pros and cons here? What to expect?    For some databases we are using a availability Groups, and when some of the users run queries agains these databases using pass-though, users will be routed to the wrong instance and Lock the database.  ... View more

Hi I just want to clarify in what order given steps will be executed in proc sql. Let us say we have table A 91 000 000 rows and table B with 2 900 000. We want to left join these table on id and using where statement filter out based on a condition. proc sql; create table test as select a.* from a left join b on a.id=b.id where a.status=1; Will tables be joined first and then filter in where close will be applied? Or are we reading row by row from table a, checking condition and if it met run left join? What is the best way to join such a big tables? ... View more

Hi   We have recently installed LSF to run codes for our business users.    Jobs in LSF have 3 different exit codes:   0 - Successfully  1- Finished with warnings 2 - Finished with ERRORS.   Some of user codes generate WARNINGS which are excepted. Is it somehow possible to force LSF to except warnings?    And another question is about combination of complete+rerun.    I.e i have a job that failed. I want to click on Complete and then rerun, to remove this job from "Exit"-state. Is it some extra configuration steps i need to do? Now i only get  "No starting points or exited items. Flow cannot rerun". I don't want to rerun it, i just want to move it from exit to Done.      ... View more

Hi   We have some users building a models in SAS Enterprise Miner. Some of the project is pretty big, 4.5GB( for me it's big). I heard that it's possible change some options or setup in SAS EM so it doesn't save some many unnecessary files. ... View more

Hi   We applied hot-fixes yesterday and suddenly we get error when we export i communication node:   Customers(3): Error in the stored process or a called macro - vendor code: 10000, message: COMM24408. Export output name must include all of 'CAMPCD' 'COMMCD' 'OCCURNBR' and no other macros Publish on reexecution.   Any changes were done to campanjas.    Name for export file should look like this: _&CAMPCD._&COMMCD._&OCCURNBR but for some reasons "_" is omited.    Local SASsupport was not so eager to help.  ... View more

Hey.    I have been struggling with this code for some days now. I read all posts in community, tried to google but still not able to solve my problem.    I get this error message. I understand that i need to fix encoding but i'm not sure what and where i shoud put it.    ERROR: org.springframework.ws.client.WebServiceTransportException: Cannot process the message because the content type 'text/xml; charset=UTF-8' was not the expected type 'application/soap+xml; charset=utf-8'. [415]   This my code: FILENAME request 'D:\Admin\Request.xml'; FILENAME response 'D:\Admin\Response.xml'; proc soap in=request out=response url="url.svc" soapaction='GetLoanCaseByReferenceNumber' debug="D:\Admin\soap.txt" ; run;   and this is my request.xml <?xml version="1.0"?> -<soap:Envelope soap:encodingStyle="http://www.w3.org/2001/12/soap-encoding" xmlns:soap="http://www.w3.org/2001/12/soap-envelope"> <soap:Header/> -<soap:Body xmlns:tem="http://tempuri.org/"> -<tem:GetLoanCaseByReferenceNumber> <tem:referenceNumber>?</tem:referenceNumber> </tem:GetLoanCaseByReferenceNumber> </soap:Body> </soap:Envelope>   Did somebody have the same problem and how it was solved? I found an article but it was more java related.  ... View more