BookmarkSubscribeRSS Feed

An Error in the SAS Macro Language: Reference

Started ‎12-01-2015 by
Modified ‎12-01-2015 by
Views 960

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.

 

 

Version history
Last update:
‎12-01-2015 10:40 AM
Updated by:

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Labels
Article Tags