Your Ad Here

advanced code snippet search

Posted By

sarathannapareddy on 06/14/09


Tagged

cat CATS CATX CATT


Versions (?)

Concatenation Functions/CALL ROUTINES

 / Published in: SAS
 

URL: http://studysas.blogspot.com/2009/06/concatenation-functions-call-routines.html

CATS/CATT/CATX Call Routines CAT/CATS/CATT/CATX Functions These Functions and Call Routines can be used to join two or more strings together. Even though we can use the concatenation operator in combination with the STRIP, TRIM, or LEFT functions, these functions make it much easier to put strings together and if you wish, to place one or more separator characters between the strings. One advantage of using the call routines than the functions is improved performance. Note: *Call routine executes faster than the function… in specific…

Expand | Embed | Plain Text 
  1. * CATS/CATT/CATX Call Routines
  2.       CAT/CATS/CATT/CATX Functions
  3.       These Functions and Call Routines can be used to join two or more strings together.
  4.       Even though we can use the concatenation operator in combination with the STRIP, TRIM, or LEFT functions, these functions make it much easier to put strings together and if you wish, to place one or more separator characters between the strings.
  5.       One advantage of using the call routines than the functions is improved performance.
  6.       Note: *Call routine executes faster than the function� in specific�
  7.  
  8.       CALL CATS:
  9.       To concatenate two or more strings, removing both leading and trailing blanks.
  10.       CATS () stands for concatenate and strip.
  11.       Just think the �S� at the end of the CATS as �Strip Blanks�.
  12.       Syntax: CALL CATS (result, string-1<, string-n>);
  13.  
  14.       Example:
  15.  
  16.       A=�ABC�;
  17.       B=� CONSULTING�;
  18.       C=�INC �;
  19.       D=� TEAM �;
  20.  
  21.  
  22.       FUNCTION= RESULT
  23.       CALL CATS(RESULT, A,B)= "ABCCONSULTING"
  24.       CALL CATS(RESULT, A,B,C)= "ABCCONSULTINGINC"
  25.       CALL CATS(RESULT, "HELLO",D)= "HELLOTEAM"
  26.  
  27.     * CALL CATT:
  28.       To concatenate two or more strings, removing only trailing blanks.
  29.       Just think the �T� at the end of the CATT as �Trailing Blanks� or �Trim Blanks�.
  30.       Syntax: CALL CATS (result, string-1<, string-n>);
  31.  
  32.       Example:
  33.       A=�ABC�;
  34.       B=� CONSULTING�;
  35.       C=�INC �;
  36.       D=� TEAM �;
  37.  
  38.       FUNCTION= RESULT
  39.       CALL CATT(RESULT, A,B) ="ABC CONSULTING"
  40.       CALL CATT(RESULT, A,B,C)= "ABC CONSULTINGINC"
  41.       CALL CATT(RESULT, "HELLO",D)= "HELLO TEAM"
  42.  
  43.     * CALL CATX:
  44.       To concatenate two or more strings and removing both leading and trailing blanks and places a single space, or one or more characters of our choice, between each strings.
  45.       Just think the �X� at the end of the CATX as �add eXtra blank.�
  46.       Syntax: CALL CATX (separator, result, string-1<, string-n>);
  47.       Example:
  48.  
  49.       A=�ABC�;
  50.       B=� CONSULTING�;
  51.       C=�INC �;
  52.       D=� TEAM �;
  53.  
  54.       FUNCTION =RESULT
  55.       CALL CATX(" ",RESULT, A,B) ="ABC CONSULTING"
  56.       CALL CATX(" ,", RESULT, A,B,C) ="ABC,CONSULTING,INC"
  57.       CALL CATX(' / ', RESULT, "HELLO",D) ="HELLO/TEAM"
  58.       CALL CATX(' *** ', RESULT, "HELLO",D) = "HELLO***TEAM"
  59.  
  60.       Examples:
  61.       CAT:
  62.       The CAT function is identical to the operator
  63.       AE=aeterm aedecod aebodsys;
  64.     * Same result can be achieved using the following code;
  65.       AE=CAT (aeterm, aedecod, aebodsys); 
  66.  
  67. ****************************************************************************;
  68.  
  69.     * CATS:
  70.       AE=trim (left (aeterm)) trim (left (aedecod)) trim (left (aebodsys));
  71.     * Same result can be achieved using the following codes;
  72.       AE=CATT (aeterm, aedecod, aebodsys);
  73.       CALL CATT AE, aeterm, aedecod, aebodsys); 
  74.  
  75. ********************************************************************************;
  76.  
  77.     * CATT:
  78.       AE=trim (aeterm) trim (aedecod) trim (aebodsys);
  79.     * Same result can be achieved using the following codes;
  80.       AE=CATT (aeterm, aedecod, aebodsys);
  81.       CALL CATT (AE, aeterm, aedecod, aebodsys);
  82.       ***************************************************************************;
  83.     * CATX:
  84.       AE=trim (left (aeterm))�/� trim (left (aedecod)) �/� trim (left (aebodsys));
  85.     * Same result can be achieved using the following codes;
  86.       AE=CATX (� / �,aeterm, aedecod, aebodsys);
  87.       CALL CATX (� / �, AE, aeterm, aedecod, aebodsys);
  88.       ****************************************************************************;
  89.     * NOTE: Don�t forget to use the Length statement for the concatenated variable.

Report this snippet  

You need to login to post a comment.