topic Put # sign in text for column header in PROC SQL in SAS Programming

Put # sign in text for column header in PROC SQL

PamG — Wed, 03 Dec 2025 15:22:31 GMT

How does one put # sign that is included in text for a column label in PROC SQL? When the following is run, # gets dropped from the column header.

proc sql;
select make, count(*) "# of cars" from sashelp.cars group by make;

Quentin — Wed, 03 Dec 2025 15:39:53 GMT

# is being used a split character for the label. You can escape it with /:

proc sql;
select make, count(*)  "/# of cars" from sashelp.cars group by make;