02-14-2017 08:35 AM - edited 02-14-2017 08:46 AM
Hope you can help with this question, do you know how to catx group by in Query builder?
02-14-2017 09:10 AM
Its not a simple task in SQL, wrong type of output data structure. Simple in a datastep however:
data want; set have; length fruit_list $2000; retain fruit_list $; by fruit; fruit_list=ifc(first.fruit,list,catx(',',fruit_list,list); run;
Now I have assumed fruit is the first column and is character, list is the second and is character - this is because you have not provided test data in the form of a datastep.
02-14-2017 09:47 AM
Query builder is SQL, so that is not the best tool for the job - if it is at all possible in the tool. You can add code nodes into your EG project can you not, i.e. process the data before you go to your Query Builder? Personally I avoid front ends for coding, they are limited at the best of times, and downright pain in the regions in others.