KurtBremser is right. From my experience web apps don't deploy due to some other SAS service that did not start correctly (like Cache Locator) or some external problem like communication errors, etc. The server.log should explain the problem very well
... View more
Hi, On this extra machine you add to the plan file you do not need to select Environment Manager and then deselect the components as you suggested, I am pretty sure you can just add to this machine the "SAS Environment Manager Agent Configuration" component instead. HTH, Eyal
... View more
Hello Pronney2, I am by no means a statistician nor a mathemitician but I am aware of a sample code shipping with IML Studio called FishClusters.sx. This code attempts to find the best number of clusters using different criterias. Maybe it can help you. Eyal
... View more
Hi, I need to calculate the difference between a row vectror and a column vector in a matrix. For example: vr = {10 15} vc = {5 10} m = {5 10, 0 5} m = is the difference between them. m[1.1] = vr[1] - vc[1], m[1,2] = vr[2] - vc[1] etc. Currently I am doing this using a loop. Is there a way to accomplish this using vector/matrix notation? Thanks, Eyal
... View more
You can make this work without explicitly writing PROC IML in your code if you use SAS IML Studio http://support.sas.com/rnd/app/studio/studio.html
... View more
Hi, I am a starter with IML Studio...Sorry for the trivial question. Wondering why the following code does not show the graph result in IML Studio: submit; proc sgplot data=sashelp.class; histogram age; run; endsubmit; I do not see the graph anywhere in IML Studio. Is this supposed to work? Eyal
... View more
Hi Kandasamy, 1. You can pass parameters from the scheduler to the DI job using the SYSPARM command line option. You get the value of the SYSPARM into a SAS macro variable called also SYSPARM. You can then use it as you want. 2. Not sure if this is relevant or not but you can use the Data Integration loop transformation to read the values of a table (audit table) and run another DI job each time passing it the current row value from the table as a parameter. Eyal
... View more
Oops...Sorry. Now I see what you mean... It seems that invoking SQL pass-through causes Data Integration Studio to ignore the hints you specify in the table properties. I have no better solution but to NOT use pass through for this query and then the hints seem to be generated OK (using implicit pass through) or as a last resort and if you need full control of the SQL then write the SQL pass through code yourself as a user written code in the DI job.
... View more
Well...I just tested on DIS 4.4 and it does seem to work fine... Here is the partial SQL code I got (aaaa is the hint I typed - it is just to see if it works or not): from oralocal.CLASSFIT ( ORHINTS = aaaa ), test.FACT1 ; quit; Note that the ORHINTS data set option is found in the "from" statement and not in the "select" statement. Did you look there? If the problem still persists maybe you should contact SAS Technical Support for this. Eyal
... View more
Hi Kandasamy, I just verified the previous replies you got and in the generated SAS code you have the "etls_jobName" macro variable which contains the current job name. So, you do not need to define a parameter for this as it is auto-generated for you in the code. You can use this macro variable anywhere you like - including adding it to an audit table... HTH, Eyal
... View more
Hi, The ORHINTS is a data set option (see http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a001371596.htm) so I *guess* you should see it in the DIS generated code as part of the table name and not in the libname statement. For example, you should see something like DW_F_CONTRATO(orhints='/*+parallel(CONTRAT ,2) */') in your SQL join code. Did you look there? Eyal
... View more
Hello Rick,
I am sampling with replacement and with unequal probabilities.
Specifically, this is the R statement:
mu <- sample(c(4,12),size=1000,replace=T,prob=c(0.75,0.25))
Is the code you wrote doing this?
Is there no built-in IML (or IMLPlus) function for this?
Thanks,
Eyal
... View more
Hello everyone,
Does anyone know if it is possible to protect certain columns/cells when using the ExcelXP tagset?
For example, I am proc printing SASHELP.CLASS and would like to protect the NAME column from changes.
Thanks,
Eyal
... View more
This site uses cookies and related technologies for site operation, analytics and third-party advertising purposes, as described in our SAS Privacy Statement. You may consent to our use of these technologies, reject non-essential technologies or further manage your preferences. To opt out of SAS making information relating to cookies and similar technologies available to third parties for advertising purposes, select "Required only." To exercise other rights you may have related to cookies, select "Manage cookies."
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
