SAS Support Communities

Hope below query solve your problem   data abc; input datetime $23.; datalines; 19/07/2018 09:34:02 AM 18/07/2018 09:19:50 PM 13/07/2018 06:28:39 PM 12/07/2018 09:58:06 AM 12/07/2018 08:54:34 AM run;   data test; set abc; date_new=input(scan(datetime,1,''),ddmmyy10.); format date_new ddmmyy10.; run; ... View more

You loop from 8 to 1, but use i+1 in the loop, so it tries to access element 9 in the first iteration which does not exist. That is a conceptual mistake.   ... View more

Run this and post the output.  If what you're saying is happening, the compare will not be equal. Otherwise, you have some other issue.   data class; set sashelp.class; run; libname demo 'C:\_localdata\temp\'; data demo.class; set class; run; proc sql; create table demo.class2 as select * from class; quit; proc compare data=demo.class compare=demo.class2; run; ... View more

Respect mate!! ... View more

So you need quotes around string literals. So either add the quotes when making the macro variable.  You can use the QUOTE() function in your SQL query.   It is a common enough problem to convert a space delimited list of words into a list of quoted words that there are many macros available to make the conversion.  For example:  %qlist   But for simple list with just a single space between the words you can do it with a simple call to TRANWRD() function. data subset; set stats; where subs in ("%sysfunc(tranwrd(&List_subs,%str( )," "))"); run;  You can clean up a user entered list that might have multiple spaces between the words by using the COMPBL() function. %let qlist=%sysfunc(compbl(&list_subs)); %let qlist="%sysfunc(tranwrd(&qlist,%str( )," "))"; ... View more

TRANWRD is for a word but you have two words so it's not going to match. Is it possible to have multiple iterations of a persons name in the text? And is it guaranteed that the name is always at the end?   You do want a TRANSLATE/TRANS family of functions for sure though. If you have multiple occurrences it could be problematic though.   @frupaul wrote: Hi Everyone,   I have the following data set:   Code used to create above data set is: data Questions; length Question $100 Name $20; infile datalines dlm=','; input Question $ Name $ ; cards; When was your last interaction with Pablo Matinee,Pablo Matinee When was your last interaction with Lucien Koku,Lucien Koku ;   I want to replace every occurrence of the customer Name in the Question with [Name]. So what i intend to achieve is this:     What i have written so far is:   data New; set Questions; tranwrd(Question,Name,"%str(%[)Name%str(%])"); run;   but this has not worked.  Please can anyone suggest a solution?   Thanks,   ... View more

HI Andreas, Thanks for the proposed solution. It worked but i got a warning. Im guessing it was because of the use of the countw function. However, when i used the scan(ManagerList, -1) and scan(ManagerList, -2) it worked without a warning ... View more

Please mark @RW9's answer as solution, I just added a very small improvement. ... View more

Any books or publications you can refer me to? Thanks ... View more