ask for a question

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

data cr_postpay2a;
   set cr_postpay2a (in= a) total_calls;
   if  charged_party_number = total_calls.charged_party_number and a.hours_flag = total_calls.hours_flag
   then total_calls=total_calls.total_calls;
   keep charged_party_number     
,SiteID         
,Site_Name         
,Band         
,Address         
,Post_Code         
,Locality         
,hours_flag         
,calls         
,total_calls        
,calls_percentage      
,business_flag
;
   run;
how to modify these in order to select data from total_calls dataset? Coz I just use java method way but it is not used in sas .Thanks everyone

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏1 回帖

关键词：question Quest Ask Est TIO ask question

以兄台这水平，满篇E文，一般人还真不容易看懂啊。。。
ask for an answer!
ask a question!
。。。
您就别再coz了，先吧最基本的整明白吧~

sorry buddy I cant type chinese at moment.I am working now if any confused I am sorry

You don't know SAS at all.

You don't know SAS at all.

peterpan_aus 发表于 2012-1-17 11:12
sorry buddy I cant type chinese at moment.I am working now if any confused I am sorry

Would you please translate your java language into a layman's language to give us an idea what you want exactly? How could you expect your question to be answered properly if it cannot be perfectly understood? You can't just assume everyone is an expert in both Java and SAS.
劳驾能把java的语言翻译成日常用语，您到底要实现什么？
如果别人不能完全看懂你的问题，又怎么回答你的问题？
你觉得别人应该又懂SAS又懂java？

misslost 发表于 2012-1-17 13:10
Would you please translate your java language into a layman's language to give us an idea what you ...

我的意思是画黄线的部分有问题，怎么改才可以让total_calls中的total_calls赋值到cr_postpay2a中的total_calls
条件是 charged_party_number = total_calls.charged_party_number and hours_flag = total_calls.hours_flag
我惯性思维是把 total_calls.charged_party_number作为一个在total_calls里的变量。我知道怎么用proc sql来写只是想学习怎么用base来写

Kalet 发表于 2012-1-17 12:55
You don't know SAS at all.

对我刚刚从teradata sql那边转过来写sas，那麻烦这位高人给我一点solution可以吗？

这是用proc sql写的
proc sql;
update cr_postpay2a as u
set total_calls = (select total_call from total_calls as v
                                        where u.charged_party_number = v.charged_party_number  
                                and         u.hours_flag = v.hours_flag);
quit;
希望可以起到抛砖引玉大家一起学习进步，我承认我英语不好表达也不清楚，但是没办法公司就是没有中文系统，而且早上有点着急，我不是装B，这里冒犯到各位，说声不好意思！

peterpan_aus 发表于 2012-1-17 19:12
这是用proc sql写的
proc sql;
update cr_postpay2a as u

最好有实际数据。/*another method*/
proc sort data=total_calls
  nodupkey
  out=total_calls_sorted(keep=charged_party_number hours_flag total_call
                         rename=(tatal_call=total_call_v2))
  ;
  by charged_party_number
     hours_flag
  ;
run;
data cr_postpay2a_v2;        
  if _n_=1 then do;
    if 0 then set total_calls_sorted;
    declare hash
      ht(dataset: "total_calls_sorted");
      ht.definekey("charged_party_number",
                   "hours_flag");
      ht.definedata("total_call_v2");
      ht.definedone();
  end;
  set cr_postpay2a;
  rc=ht.find(key: charged_party_number,
             key: hours_flag);
  if rc=0 then total_call=total_call_v2;
          else total_call_v2=.;
  drop rc total_call_v2;
run;