Everything is working when I am adding a dot at the end of the space. caps1=' '||caps1; caps=caps1||" ."; ... View more

But my following text mining command is not considering the trailing space. pattern_id=prxparse('/( DONEPEZIL | GALANTAMINE | RIVASTIGMINE | MEMANTINE )/i'); start=1; stop=length(caps); call prxnext(pattern_id, start, stop, caps, position, length); if (position>0)then cm_dementia=substr(caps, position, length); ... View more

what is the solution then. I need to add a trailing space for text mining. ... View more

I have enough length in the variable. The source variable is 100 Char long and i am using the following caps=put(GenericName,$upcase200.); /*Capitalise all letters and setting the length to 200*/ caps = compbl(tranwrd(caps, ",", " ,")); /* Adding a space before a comma */ caps = compbl(tranwrd(caps, ".", " .")); caps = compbl(tranwrd(caps, ";", " ;")); caps = compbl(tranwrd(caps, "&", " + ")); *caps = compbl(tranwrd(caps, "/", " + ")); caps=' '||caps; caps=caps||" ";   ... View more

Thanks. got it ... View more

thanks. It creates a new table. I was wondering if similar thing could be done from the command line without creating a new table as my dataset is very big. ... View more

I inserted a space at the beginning of the character variable. Now it's working. Thanks to both of you. ... View more

I don't want to mask it but consider it as a part of my target string. I want SAS to extract it with the slash. For example "CLOTRIMAZOLE/HYDROCORTISONE" is a single word that I want to pick up. ... View more

Thanks very much. ... View more

Thanks. That worked. ... View more

Some of the key words contain hyphen and backslash which returns error message. pattern_id=prxparse('/(DEMENTIA|ALZH|DEMENTIA|DEMENTIA - ALZH|DEMETIA|DEMENI|DEMENTAI|H/O DEMENETIA)/i'); ERROR: Invalid characters "DEMENETIA)/i" after end delimiter "/" of regular expression "/(DEMENTIA|ALZH|DEMENTIA|DEMENTIA - ALZH|DEMETIA|DEMENI|DEMENTAI|H/O DEMENETIA)/i". ERROR: The regular expression passed to the function PRXPARSE contains a syntax error. NOTE: Argument 1 to function PRXPARSE('/(DEMENTIA|A'[12 of 81 characters shown]) at line 24703 column 13 is invalid. NOTE: Argument 1 to the function PRXNEXT is missing. ERROR: Argument 1 to the function PRXNEXT must be a positive integer returned by PRXPARSE for a valid pattern. Is there any way to get around this problem? ... View more

How can i extract a keyword from a list of words in a variable? For examples, if the variable x ='MyGroup_152 YourGroup_1230 pref_OurGroup_232' I want to extract either of "MyGroup", "Your" and "Our", whichever appears first and save into a different variable.   ... View more