topic Re: Concatenate dynamic columns starting with a string and numeric in SAS Programming

Concatenate dynamic columns starting with a string and numeric

ywon111 — Thu, 06 Aug 2020 05:14:57 GMT

Hi, Is there a better way to concatenate all these variables that starting with a variable name var and a value attached?

Eg.

var1

var2

var3

var4

var5

This is what I got now, but would pick up variables like var_ which not needed.

var_conc= catx(',', of var:);

Thanks

Re: Concatenate dynamic columns starting with a string and numeric

PeterClemmensen — Thu, 06 Aug 2020 05:35:09 GMT

Provided, that your posted data is representable, you could do

data have;
input (var1 var_1 var2 var_2 var3 var_3)($);
datalines;
a b c d e f
;

data want;
   set have;
   var_conc = catx(',', of var1-var3);
run;

Re: Concatenate dynamic columns starting with a string and numeric

ywon111 — Fri, 07 Aug 2020 04:23:40 GMT

Thanks but this is what I have and need:

data want;
keep skill:;
set have;

How do I concatenate all the skill variables?

Re: Concatenate dynamic columns starting with a string and numeric

ChrisNZ — Fri, 07 Aug 2020 05:03:46 GMT

Why do you change your question half-way?

What exactly do you want? To keep the SKILL: variables but not the SKILL_: variables?

Show us the proc contents of your table, and describe exactly what you want to concatenate.

Re: Concatenate dynamic columns starting with a string and numeric

ywon111 — Sat, 08 Aug 2020 03:29:42 GMT

I've got a long list of skill1, skill2, skill3, skill4, etc variables and need to concatenate all these variables to one. There's a variable skill_ which is not required.
Thanks