PROC SQL allows a subquery (contained in parentheses) at any point in an expression where a simple column value or constant can be used. In this case, a subquery must return a single value, that is, ...

I am no expert on those tools so can not compare them nor recommend one over another. But I had a project recently where I needed to compare schema and data in SQL Server and I tried out http ...