topic Re: Column heading in SAS Programming

Column heading

lca — Thu, 27 Sep 2012 07:13:13 GMT

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 — Thu, 27 Sep 2012 07:55:35 GMT

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 — Thu, 27 Sep 2012 09:34:07 GMT

Thank you 🙂