Column heading

[lca]

Hi,

I have a table with a column name which starts with a number (1Heading).

In SAS base i have no problem with this.

proc sql;

create NewTable test as select

_Heading

from table

;

quit;

But in SAS Enterprise Guide this does not work. I get an error using underscore.

What should I use in front of the column name instead of underscore ?

Lca

[Ksharp · Accepted solution]

By default, SAS Base use option validvarname=v7 , whereas SAS EG use option validvarname=any .

That means you can use the variable name as literal .

proc sql;

create NewTable test as select

'1Heading'n

from table

;

quit;

[lca]

Thank you 🙂