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
>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.
>On Thu, 26 Jul 2007 14:02:17 -0400, Job Seeker
>>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:
>>194 Data Need ( Drop = B ) ;
>>195 Length NewB $ 200 ;
>>196 Set Death_15 ;
>>197 By subjid;
>>198 Retain NewB ;
>>NOTE: SCL source line.
>>200 NewB = CatX( ',' , NewB , aeterm ) ;
>>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).
>>WARNING: The variable B in the DROP, KEEP, or RENAME list has never been
>>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