无法在数据步骤中运行调用执行 [英] Unable to run Call Execute within a Data Step

问题描述

我正在尝试在数据步骤中运行插入语句来填充表.运行代码错误时出现以下错误:域错误.日志中没有关于此错误的其他信息.

I am trying to run an insert statement within a data step to populate a table. I get the following error while running the code ERROR: Domain error. There is no other information on this error i the logs.

我正在实施的示例代码是:

The sample code which I am implementing is :

  DATA _NULL_;
  SET DataSetA;

 Call Execute ('Proc Sql; Insert Into TableA Select col1,col2,c.Col2 From Table B Inner        Join ( Select col1,' || Datasetcol1 || ' As col2, ' || Datasetcol2 || ' as Col3 FROM ' || Datasetcol3 || ' ) c On b.Col1=c.col1;quit;');

 run;

如果有 2000 条记录，此代码运行正常，但现在我有 10000 条记录并抛出该错误.Datasetcol1 和 Datasetcol2 是我在查询中使用的数据集的值.

This code runs okay if there are 2000 records but now I have 10000 records and throws me that error. Datasetcol1 and Datasetcol2 are values from the dataset which I am using in the query.

我不知道为什么会出现这个错误.最初，我认为可能是因为处理器工作太多，我使用 sleep 和 wakeup 进行了等待，但是，我仍然收到错误消息.此外，我并不总是收到此错误.有时会发生，有时不会.

I have no idea why this error occurs. Initially, I thought it could be because of the processor having too much work, I put in a wait by using sleep and wakeup , however, I still get the error. Also, I dont get this error always. It happens sometimes and sometimes it doesnt.

推荐答案

我正在运行 Joe 的代码，我没有遇到任何问题.这是在带有 SAS 9.2m3 的 Windows 7 上，因此可能与您的环境不同.此外，由于我没有你的数据，我无法复制你所做的.

I am in the middle of running Joe's code and I am having no issues. This is on Windows 7 with SAS 9.2m3, so that may be different environment than yours. Also since I do not have you data, I can not replicate what you have done.

我看到很多可以改进代码的东西，但错误消息表明 SAS 内部存在一些问题.我通常发现与 SAS 技术支持联系更有效，而不是推测称为 SAS 的黑匣子中可能发生的事情.提交一张票.

I see lots of things which might improve the code, but the error message indicates some problem deep within SAS. I generally find it more efficient to check with SAS Tech support rather than speculate about what may be happening in the Black Box called SAS. Submit a ticket on this.

我在 SAS 支持站点上很好地引用了此错误消息，该消息指向 Oracle 特定问题.http://support.sas.com/kb/14/873.html

I did fine one reference to this error message on the SAS support site which points to Oracle specific issue. http://support.sas.com/kb/14/873.html

这篇关于无法在数据步骤中运行调用执行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！