Any suggestion best way to get this?
HAVE:
id | fruit |
1 | apple |
1 | orange |
2 | apple |
3 | apple |
WANT:
id | fruit |
1 | apple, orange |
2 | apple |
3 | apple |
Thanks 🙂
Create a variable, and then use it in the TRANSPOSE:
data have;
input id $ fruit $;
datalines;
1 apple
1 orange
2 apple
3 apple
;
data pretrans;
set have;
val = 1;
run;
proc transpose
data=pretrans
out=want (drop=_name_)
;
by id;
id fruit;
var val;
run;
Sorry, slight changes, this is what I want
id | apple | orange |
1 | 1 | 1 |
2 | 1 | |
3 | 1 |
Thanks
Create a variable, and then use it in the TRANSPOSE:
data have;
input id $ fruit $;
datalines;
1 apple
1 orange
2 apple
3 apple
;
data pretrans;
set have;
val = 1;
run;
proc transpose
data=pretrans
out=want (drop=_name_)
;
by id;
id fruit;
var val;
run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.