帮我看一下这道题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

You have a collection of raw data representing the reading scores on three groups of subjects :control group C,method A group,method B group.The data are arranged so that a group code is followed by one or more scores for that group,and scores for any group can span more than one record of raw data.Write a SAS program that will read the data below and create a SAS data set reading with variables GROUP and SCORE,one set per obervation.
DATA TESTSCORE
C 303 102 150 B 202 C 300 B 450 400 399
420 A 289 280 278

如果只有两个变量的话，是不是结果是这样的呢:
group score
c 303
102
150
300
B 450
400
399
420
A 289
280
278
但是如何把A B C 分离出来呢
thank you

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：Presenting Collection Variables Thank you represent collection subjects arranged reading control

我全然不懂，看来要好好学习了

One of solutions listed fellow

data testscore(DROP=X);
input x $ @@;
RETAIN G;
if x in('A','B','C') THEN DO;
G=X;
END;
ELSE DO;
V=X; OUTPUT;
END;
CARDS;
C 303 102 150 B 202 C 300 B 450 400 399
420 A 289 280 278
;
PROC SORT;
BY G;
RUN;

非常感谢，但是有一点不是很明白，为何要把datalines放在最后呢？一般的情况下，都是datalines放在input 下边的？