topic Re: Concatenate all variable into one seperated by delimiter in SAS Procedures

Concatenate all variable into one seperated by delimiter

rakeshvvv — Mon, 07 Jul 2014 14:56:46 GMT

Hi,

I have dataset X with variables COL1 TO COLN....

I wanted to create new varaible to concatenate all collumns sepeareted by delimiter..... COLN coule be col20 or col25...so it has to be generalised for all col starting with COL.... I TRIED THIS WAY BUT NOT WORKING....

data _null_;

separator='%%$%%';

col1='The Olympic ';

col2=' Arts Festival ';

col3=' includes works by ';

col4='Dale Chihuly.';

result=catx(separator,col:);

put result $char.;

run;

Re: Concatenate all variable into one seperated by delimiter

RW9 — Mon, 07 Jul 2014 15:15:27 GMT

Hi, that seems to be an example from the help page. Anyways, use the of colx-coly. Note it will trim your data and hence lose the spaces.

data _null_;

col1='The Olympic ';

col2=' Arts Festival ';

col3=' includes works by ';

col4='Dale Chihuly.';

result=cat(of col1-col4);

put result $char.;

run;

If you need the $ then put it into your strings.

Re: Concatenate all variable into one seperated by delimiter

rakeshvvv — Mon, 07 Jul 2014 15:19:58 GMT

Hi,

I want a generalised solution as there is chance that new collumns(col 5 col6 col7) will be added to the dataset.... I want write in such a way that it would concatenalte all columns starting with name COL so that in case new collumns are added in near future....

Re: Concatenate all variable into one seperated by delimiter

Reeza — Mon, 07 Jul 2014 15:24:15 GMT

Are the variables already defined in the dataset or are you creating them?

If they're already defined you can try:

data want;

set have;

array col(*) col:;

result=catx(",", of col(*));

run;

Re: Concatenate all variable into one seperated by delimiter

stat_sas — Mon, 07 Jul 2014 15:25:44 GMT

data _null_;

separator='%%$%%';

col1='The Olympic ';

col2=' Arts Festival ';

col3=' includes works by ';

col4='Dale Chihuly.';

result=catx(separator,of col:);

put result $char.;

run;

Re: Concatenate all variable into one seperated by delimiter

rakeshvvv — Mon, 07 Jul 2014 15:36:18 GMT

Thanks... This is what iw as looking for......