求教达人,SAS编程解决一道问题,小生不会做!

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

要把这些学生每个8个学期的总学时,也就是cred1,cred2,cred3对应的学时加总,得出学生在上学期间的总学时,这个怎么用sas编程编出来呢?请达人不吝赐教.student_id对应的是从1到1000...谢谢了<

student_id	semester	cred1	cred2	cred3	grade1	grade2	grade3
1	1	4	4	0	A	A-	A
1	2	4	4	0	A	A	A
1	3	4	4	0	A	A-	A
1	4	4	4	0	A	A	A
1	5	4	4	0	A	A	A
1	6	4	4	0	A	A	A
1	7	4	4	0	A	A	A
1	8	4	4	0	A	A	A
2	1	4	3	1	B+	B+	B+
2	2	4	3	1	B	A	A
2	3	4	4	0	A	A-	B+
2	4	4	4	0	A-	A-	A-
2	5	4	4	0	A-	B+	A
2	6	4	4	0	A-	A-	B
2	7	4	4	0	B+	A-	B+
2	8	4	3	1	A	A-	A
3	1	4	3	1	B-	B-	B-
3	2	4	4	0	B-	C+	B-
3	3	4	3	1	C+	B	B
3	4	4	4	0	B-	B	B-
3	5	4	3	1	C+	C+	B-
3	6	3	4	1	C+	B	B
3	7	3	4	1	B	C+	B
3	8	4	4	0	C	B-	B
4	1	4	4	0	B	C	C+
4	2	4	4	0	B-	B	B-
4	3	4	3	1	B	B-	C
4	4	4	4	0	B	B	B

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：SAS编程 Student cred CRE red

好吧,我承认图片开始没有上传正确

proc sql;
   create table need as
   select distinct student_id,
          sum(cred1) as sum_cred1,
                  sum(cred2) as sum_cred2,
                  sum(cred3) as sum_cred3
   from yourdata
   group by student_id;
quit;

yugao1986 发表于 2011-11-6 19:29
proc sql;
   create table need as
   select distinct student_id,

谢谢了,我今天到实验室试试...不知道怎么跟你联系,还有几道题能帮我个忙吗?

1. data grade1;
   
2. set grade;
   
3. cred=cred1+cred2+cred3;
   
4. run;
   
5. proc sort data=grade1;
   
6. by student_id;
   
7. run;
   
8. data grade2;
   
9. set grade1;
   
10. by student_id;
    
11. retain credtotal;
    
12. if first.student_id then
    
13. credtotal=0;
    
14. credtotal=credtotal+cred;
    
15. if last.student_id;
    
16. keep student_id credtotal;
    
17. run;

复制代码