I see my post was not sent quite as it was written, not seen from my browser at least, so text to a topic starts beside the illustration to the previous topic instead of under it. I hope it's still understandable. ... View more

Assuming you already have consulted the documentation:https://documentation.sas.com/?docsetId=etlug&docsetTarget=p1fdvid6xvcmyin1xen12huf3llt.htm&docsetVersion=4.905&locale=en   What happens? This is a transformation that use SAS macro code, so try to seem what actual code is being executed (MPRINT). Whna trying PROC HTTP, are you subitting it in the same Worskspace Server as DI? ... View more

Can you be more specific about what application or component of SAS Viya you are using when you say you created an ETL? Or have you created a SAS Enterprise Guide job to load data into a CAS table on SAS Viya?   Ron ... View more

@AnandsinhSindha wrote: get some score based on above code but i am not getting my desired output.... Of course not, i wrote: "The following step should get you started", meaning that it is up you to decide which function to use and which score is low enough to indicate a match. ... View more

If your imported dataset looks like this, the MDYAMPM informat will also work in the INPUT function: data have; input BA $30.; datalines; CONTACT_DATE 12/18/2009 12:00:00 AM 12/22/2009 12:00:00 AM 12/22/2009 12:00:00 AM 8/31/2010 12:00:00 AM 3/5/2012 12:00:00 AM CONTACT_DATE 9/23/2011 12:00:00 AM 9/26/2011 12:00:00 AM 2/7/2012 12:00:00 AM 2/7/2012 12:00:00 AM CONTACT_DATE 5/25/2010 12:00:00 AM 5/25/2010 12:00:00 AM 5/2/2011 12:00:00 AM 5/3/2011 12:00:00 AM 7/14/2011 12:00:00 AM 7/14/2011 12:00:00 AM 7/14/2011 12:00:00 AM 7/14/2011 12:00:00 AM 7/14/2011 12:00:00 AM 7/14/2011 12:00:00 AM 7/14/2011 12:00:00 AM 7/14/2011 12:00:00 AM 7/14/2011 12:00:00 AM 7/14/2011 12:00:00 AM 7/14/2011 12:00:00 AM 7/14/2011 12:00:00 AM 7/14/2011 12:00:00 AM 7/17/2011 12:00:00 AM 7/14/2011 12:00:00 AM 10/30/2011 12:00:00 AM 10/30/2011 12:00:00 AM 10/30/2011 12:00:00 AM 10/30/2011 12:00:00 AM 10/30/2011 12:00:00 AM ; data want; set have (rename=(BA=_BA)); where _BA not in("","CONTACT_DATE"); BA = input(_BA,mdyampm32.); format BA e8601dt19.; run; Result: 1 12/18/2009 12:00:00 AM 2009-12-18T00:00:00 2 12/22/2009 12:00:00 AM 2009-12-22T00:00:00 3 12/22/2009 12:00:00 AM 2009-12-22T00:00:00 4 8/31/2010 12:00:00 AM 2010-08-31T00:00:00 5 3/5/2012 12:00:00 AM 2012-03-05T00:00:00 6 9/23/2011 12:00:00 AM 2011-09-23T00:00:00 7 9/26/2011 12:00:00 AM 2011-09-26T00:00:00 8 2/7/2012 12:00:00 AM 2012-02-07T00:00:00 9 2/7/2012 12:00:00 AM 2012-02-07T00:00:00 10 5/25/2010 12:00:00 AM 2010-05-25T00:00:00 11 5/25/2010 12:00:00 AM 2010-05-25T00:00:00 12 5/2/2011 12:00:00 AM 2011-05-02T00:00:00 13 5/3/2011 12:00:00 AM 2011-05-03T00:00:00 14 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 15 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 16 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 17 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 18 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 19 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 20 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 21 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 22 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 23 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 24 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 25 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 26 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 27 7/17/2011 12:00:00 AM 2011-07-17T00:00:00 28 7/14/2011 12:00:00 AM 2011-07-14T00:00:00 29 10/30/2011 12:00:00 AM 2011-10-30T00:00:00 30 10/30/2011 12:00:00 AM 2011-10-30T00:00:00 31 10/30/2011 12:00:00 AM 2011-10-30T00:00:00 32 10/30/2011 12:00:00 AM 2011-10-30T00:00:00 33 10/30/2011 12:00:00 AM 2011-10-30T00:00:00 ... View more