You can use the INTO clause to create one or more macro variables in the SELECT clause. The INTO keyword is followed by a colon (:) and then the macro variable name.

You cannot create a macro variable in the same SQL step in which you are calling the macro variable. To create a report that does not contain any duplicate items including the values in the macro variable, use the DISTINCT keyword in the SELECT clause.

When storing a value in a single macro variable, PROC SQL preserves leading or trailing blanks. You can use the TRIMMED option in the INTO clause to remove the leading and trailing blanks. Use the INTO keyword followed by a colon (:), followed by the macro variable named, followed by the keyword TRIMMED.

You can use the SEPARATED BY keyword in the INTO clause to specify a character to delimit the values into a macro variable. You do not need to use the TRIMMED keyword with the SEPARATED BY keyword because it removes leading and trailing blanks from each value before performing the concatenation of values.

While the foundation of PROC FedSQL syntax is similar to PROC SQL, there are a few differences when it comes to specific SAS enhancements such as formats. In order to associate a format with a variable in the output, use the PUT function.

In PROC FedSQL when you want to limit the number of rows, use the LIMIT clause in the SELECT statement. The LIMIT clause is the LIMIT keyword followed by the count or the number of rows you want to display in the output. You cannot use INOBS= in PROC FedSQL.