程序問題

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

/*Rename thevariables as stockcode, reportdate, name, reward, allowance, sharehold. Formatdata appropriately.*/

dataexExecutive1;

setExecutive ;

renameStkcd=stockcode Reptdt=reportdate D0101b_en=name D1001b=reward D1002b=allowanceD1101b=sharehold;

Stkcd_num=input(Stkcd,6.);

Rptdt_num=input(Reptdt,YYMMDD10.);

run;

procprint data=exExecutive1;

formatStkcd_num 6.;

formatRptdt_num mmddyy10.;

formatname $30.;

formatreward 10.;

formatallowance 5.;

formatsharehold  5.;

run;

procsql;

CreateTable EXECUTIVE2 as

     select

       Stkcd_num as stockcode, sum(reward)  assumreward, sum(allowance) as sumallowance,sum(sharehold)  assumsharehold,

      fromwork.exExecutive1 as a;

quit;

是那裡出錯了?運行不到

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：appropriate allowance Executive Variables Variable 程序

procsql;


CreateTable EXECUTIVE2 as


     select


       Stkcd_num as stockcode, sum(reward)  assumreward, sum(allowance) as sumallowance,sum(sharehold)  assumsharehold,


      fromwork.exExecutive1 ;


quit;

問題是出在 from  work.exExecutive1 ;這句..但我不知道那裡錯了

WUTeng 发表于 2013-3-23 21:28
procsql;

from  work.exExecutive1 ;前面的那个 ,  是不是要去掉啊

改成from  work.exExecutive1 ;還是不行..
ERROR 79-322: Expecting a FROM.

WUTeng 发表于 2013-3-23 21:34
改成from  work.exExecutive1 ;還是不行..
ERROR 79-322: Expecting a FROM.

你去掉那个逗号，还是有问题吗？
proc sql;
select sex, sum(age)  as age_sum
from sashelp.class;          
quit;

proc sql;
select sex, sum(age)  as age_sum,
from sashelp.class;
quit;

可以了..剛開始學這麼細小的地方真的好難察覺啊//謝謝你啊'!!!!!!!!!!!!!!!!!!!!!!

那如果分類加總呢?
1   2
1   3
1   4
2   2
2   3
3   5
3   6
就是把第1第2第3組分類加起來了?

WUTeng 发表于 2013-3-23 21:54
那如果分類加總呢?
1   2
1   3

data raw;
input a b;
cards;
1   2
1   3
1   4
2   2
2   3
3   5
3   6
;
run;

proc sql;
create table new as
select a, sum(b) as b_sum
from raw
group by a;
quit;