topic Re: Concatenate character variables with CATX in SAS Health and Life Sciences

Concatenate character variables with CATX

SureshPadwal — Thu, 06 Mar 2014 11:49:14 GMT

Hi,

I'm stuck while using CATX function.

I have thirty string variable(COL1 to COL30) and i want to join this all variable separeated by comma by using CATX. It doesnt working.

Is there is any other way to do this.

Your little help may be great help.

Re: Concatenate character variables with CATX

Amir — Thu, 23 Feb 2017 12:56:23 GMT

Hi,

Have you tried something like:

data _null_;
  col1='column 1';
  col2='column 2';
  col3='column 3';
  result=catx(',',of col1-col3);
  put result=;
run;

which for me gives:

result=column 1,column 2,column 3

If this does not work for you please post your code, what you expect and the log showing the error.

Also from @BrunoMueller:

You can make use of variable lists in the CATX function, see also sample below using an array:

data want;
  length colString $ 120; 
  array myVars{30} $ 4 col1 - col30;
  nChar = rank("A");
  do i = 1 to dim(myVars);
    myVars{i} = byte(nChar);
    nChar + 1; 
  end; 

  colString = catx(",", OF myVars{*});
run;

Re: Concatenate character variables with CATX

BrunoMueller — Thu, 23 Feb 2017 12:53:00 GMT

Hi as Amir mentioned you can make use of variable lists in the CATX function, see also sample below using an array:

data want;
  length colString $ 120; 
  array myVars{30} $ 4 col1 - col30;
  nChar = rank("A");
  do i = 1 to dim(myVars);
    myVars{i} = byte(nChar);
    nChar + 1; 
  end; 

  colString = catx(",", OF myVars{*});
run;

Re: Concatenate character variables with CATX

SureshPadwal — Thu, 23 Feb 2017 12:53:52 GMT

Hi Amir,

I have data like this with missing values. variables are character.

Col1 col2 col3 col4….col28

3 . 7 8….25

2 6 . 11….28

;

I want

Col1 col2 col3 col4….col28 result

3 4 7 8….25 3,4,7,8,…,25

2 6 9 11….28 2,6,9,11,….28

I have written:

data d3;
   length result $ 50;
   SP=',';
   result =catx(SP, of col1-col28);
run;

LOG is:

NOTE: Character values have been converted to numeric values at the places given by:
      (Line):(Column).
      19:16   19:21  
NOTE: Invalid numeric data, COL5='           1*           6' , at line 19 column 21.

Hope this clear.

Re: Concatenate character variables with CATX

BrunoMueller — Thu, 06 Mar 2014 12:55:39 GMT

the Note

NOTE: Character values have been converted to numeric values at the places given by:

(Line):(Column).

19:16 19:21

NOTE: Invalid numeric data, COL5=' 1* 6' , at line 19 column 21.

Indicates that char values have been converted to numeric values, they are not coming from the CATX function

Re: Concatenate character variables with CATX

Amir — Thu, 06 Mar 2014 12:57:12 GMT

Hi,

Thanks for posting what you have. You shown some missing data, but you haven't said what result you want if the data is missing.

The data step does not seem complete as there is no input data specified, either through a set statement, or infile statement, or by some other means.

One of the log messages:

NOTE: Invalid numeric data, COL5=' 1* 6' , at line 19 column 21.

shows data "1* 6'", are you expecting this kind of data too? Are you trying to perform maths on the character data?

I think we still need to be shown a clearer picture of what you have. Try posting a sample data step which we can run that shows what the problem is.

Regards,

Amir.

Re: Concatenate character variables with CATX

SureshPadwal — Fri, 07 Mar 2014 04:59:12 GMT

Hi Bruno and Amir,

Its working. Thanks for your valuable suggestions and time.