An error was reported in the “INTO Clause” dictionary entry in the SAS Macro Language: Reference.
In the following example, the log output should have quotation marks:
Example 3: Storing Values of All Rows in One Macro Variable
This example stores all values of the column (variable) STYLE in the macro variable TYPES and separates the values with a comma and a blank.
proc sql;
select distinct quote(style)
into :types separated by ', '
from sasuser.houses;
%put Types of houses=&types.;
When this program executes, this line is written to the SAS log:
Types of houses=CONDO, RANCH, SPLIT, TWOSTORY
The log output should have quotation marks:
Types of houses="CONDO ", "RANCH ", "SPLIT ", "TWOSTORY"
The documentation will be corrected in the next SAS software release.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.