LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2007, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page