Date:         Fri, 27 Jul 2007 07:33:04 -0400
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: A DATA MANUPULATION QUESTION

On Fri, 27 Jul 2007 02:45:45 -0400, Gerhard Hellriegel
<gerhard.hellriegel@T-ONLINE.DE> wrote:

>so use something like:
>
>newb = trim(newb)!!", "!!aeterm;
>
>instead. I think that should work from V5.18 ->

It seems to me this would put an unwanted comma and blank at the beginning
of NEWB. Toby's technique would avoid that. Another possibility is to use

   newb = substr(newb,3);

after the last concatenation has been done.

>Gerhard
>
>
>On Thu, 26 Jul 2007 14:02:17 -0400, Job Seeker
><entry_mid_level_sas@YAHOO.COM> wrote:
>
>>Hi mr. Toby,
>>
>>I am using SAS * I do not think her CATX fucntion is avalilable. I am
>>getting an error for it as bellow:
>>
>>93
>>194  Data Need ( Drop = B ) ;
>>195  Length NewB $ 200 ;
>>196  Set Death_15 ;
>>197  By subjid;
>>198  Retain NewB ;
>>199
>>NOTE: SCL source line.
>>200  NewB = CatX( ',' , NewB , aeterm ) ;
>>            ----
>>            68
>>ERROR 68-185: The function CATX is unknown, or cannot be accessed.
>>
>>201  If Last.subjid Then Output ;
>>202  Put subjid= NewB= ;
>>203  Run ;
>>
>>NOTE: Numeric values have been converted to character values at the places
>>given by: (Line):(Column).
>>      200:8
>>WARNING: The variable B in the DROP, KEEP, or RENAME list has never been
>>referenced.
>>NOTE: The SAS System stopped processing this step because of errors.
>>WARNING: The data set WORK.NEED may be incomplete.  When this step was
>>stopped there were 0 observations and 11 variables.
>>NOTE: DATA statement used:
>>      real time           0.26 seconds
>>      cpu time            0.01 seconds
>>
>>
>>Thanks you