The SQL Procedure Pass-Through Facility is an extension to the SQL procedure that enables you to send DBMS-specific statements to a database management system and to retrieve DBMS data directly.

PROC SQL follows most of the guidelines set by the American National Standards Institute (ANSI) in its implementation of SQL. However, it is not fully compliant with the current ANSI Standard for SQL.

One of the main benefits of using proc sql is that it can simplify your code and reduce the number of steps required to perform complex joins and aggregations. For example, if you want to join ...

Then, you can work with the names rather than the text itself. SAS inserts the new value of the macro variable throughout your PROC SQL statements automatically. After all macro variables are resolved ...

Tried similar but the issue is that the proc can't be edited/compiled on the one server, it throws syntax errors, because FTI is not installed - even though it won't be run because of the check.