SAS中文论坛

标题: how to avoid dulpicated entry? [打印本页]

作者: shiyiming 时间: 2004-12-15 10:29
标题: how to avoid dulpicated entry?
[color=red:639a6][size=200:639a6]i got a dataset and a text entry, the text entry is used to add new record, but before the insertion get excuted,i want first check if the new enry is already existed in that dataset. if it is, stop,oherwise, do proc insert. my code is listed below, but somehow. the first option has never get excuted. could someone tell me which part went wrong?thank you [/size:639a6][/color:639a6]

作者: shiyiming 时间: 2004-12-15 12:01
标题: 显然的PROC SQL中的UNION
显然的PROC SQL中的UNION

另外你的程序好象忘贴了

作者: shiyiming 时间: 2004-12-15 12:36
标题: can u show me a example,bro?
[color=red:ec2d2]heihei, don't know which doc is related to the union, thanks[/color:ec2d2]

作者: shiyiming 时间: 2004-12-16 05:00
标题: reset dataset problem
after using union, it works,thanks. but when i reset(refresh/update) the Variable Value List of a combobox which is linked to this unioned dataset, it gives error messege, and say the programe halt.

submit continue;                                                                                           data Prog.ServiceID;
         set uni;
      run;
   endsubmit;

   DataSet_ServiceID.table='Prog.ServiceID';
   refresh;
   VarValueList_ServiceID.dataset  ='Prog.ServiceID';
   VarValueList_ServiceID.variable ='SERVICEID';


ERROR: The value specified for the dataSet attribute is not valid. Specify another value.
Parameters passed to method _SETATTRIBUTEVALUE:
  1 (Character Literal) = 'dataset'
  2 (Character Literal) = 'Prog.ServiceID'
Program returning prematurely at line 488
AF Program: PROG.MRP.MAIN.FRAME

i found the sas/af language is fu***** idiot~~~~~~~~~~~~

欢迎光临 SAS中文论坛 (http://mysas.net/forum/)