Hey Guys, Just for completeness So I've been mucking around with this all day. I decided to go back to the drawing board and just go through all the code line by line. Forget what I'd read on the net and take another look. The issue was in the code where a date had been converted to Char and was being used with a SAS date. This worked in SQL Server because dates are treated like char in the query. So thank you so much for your assistance. I appreciate you all taking the time. I'd read something on the net that said DateAdd doesnt work in SAS- and that's probably true- but it's fine in an explicit pass through. problem solved! ... View more

Not sure how much that'll help. I'm using AMO 5.1 I might take a screenie of the error an flick it over to tech support at SAS. Will post finding here. ... View more