我现在有如下数据:
ID language
1 Chinese
1 English
2 Chinese
2 English
3 Japanese
3 Chinese
3 French
我想把ID相同的情况合并到一起,就是变成如下表格:
ID language
1 Chinese, English
2 Chinese, English
3 Japanese, Chinese, French
请问应该如何编code?我现在的code是这样子的
data t;
set ttt;
by visitor;
retain language"";
if first.visitor then language=language !!"," !! language;
if last.visitor then language=trim(left(tranwrd(language, ",", " ")));
run;
但是行不通,实在想不出来了,十分感谢各位大侠出手相救~