How can i concatinate values in one observation with commas?

[kindbe17]

I am tying to cat all values, but seems i am doing it wrong, could you please help me?

proc sql;
create table cars11 as
select make,
type,
Mean (horsepower) as Mean
From sashelp.cars
Group by make, type;
quit;

proc transpose data =new;
var Mean;
run;

data new1;
length MeanM $200.;
set new;
MeanM=strip(put(col1,best.))||","||strip(put(col2,best.));
run;

[PeterClemmensen]

Why do you want all mean values in a single observations?

[kindbe17]

i need them but they must be separated with commas, 

[PeterClemmensen]

I understand. But why?

[pink_poodle]

MeanM = CATX(",", col1, col2, …, coln);

[yabwon · Accepted solution]

You can get it for example like this:

proc sql;
  create table cars11 as
  select make,type,Mean(horsepower) as Mean
  from sashelp.cars
  group by make,type
  ;
quit;

proc transpose data=cars11 out=means;
  var Mean;
run;

data means1;
  set means;
  length MeanM $ 32767;
  MeanM=catx(",", of COL:);
  keep MeanM;
run;

but as @PeterClemmensen wrote, I don't get why ?

If you try to use it in some sort `x IN (...)` condition in SQL, why not just use a subquery? (The only reason for such step would be that you can't pass the data in table and you have to push it in a code.)

Bart