topic Re: How can i concatinate values in one observation with commas? in SAS Programming

How can i concatinate values in one observation with commas?

kindbe17 — Thu, 04 May 2023 10:08:57 GMT

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;

Re: How can i concatinate values in one observation with commas?

PeterClemmensen — Thu, 04 May 2023 10:14:53 GMT

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

Re: How can i concatinate values in one observation with commas?

kindbe17 — Thu, 04 May 2023 10:16:30 GMT

i need them but they must be separated with commas,

Re: How can i concatinate values in one observation with commas?

PeterClemmensen — Thu, 04 May 2023 10:19:43 GMT

I understand. But why?

Re: How can i concatinate values in one observation with commas?

yabwon — Thu, 04 May 2023 10:48:39 GMT

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

Re: How can i concatinate values in one observation with commas?

pink_poodle — Thu, 04 May 2023 10:49:33 GMT

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