大神们,求问,怎么能把下面原始数据集根据 seq 合并变量txt?
原始:
seq | txt |
1 | a |
1 | b |
1 | c |
1 | d |
2 | a |
2 | b |
想要变成这样:
seq | combine |
1 | a, b, c, d |
2 | a, b |
为方便测试,我dummy了下raw data:
data raw;
length txt $10;
seq=1; txt = 'a';output;
seq=1; txt = 'b';output;
seq=1; txt = 'c';output;
seq=1; txt = 'd';output;
seq=2; txt = 'a';output;
seq=2; txt = 'b';output;
run;
我知道transpose能实现,想问问retain语句能实现吗?或是有什么更简单的方法吗?
拜谢~~