DATA Step, Macro, Functions and more

Column heading

Accepted Solution Solved
Reply
Occasional Contributor lca
Occasional Contributor
Posts: 10
Accepted Solution

Column heading

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


Accepted Solutions
Solution
‎09-27-2012 03:55 AM
Super User
Posts: 10,044

Re: Column heading

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;


View solution in original post


All Replies
Solution
‎09-27-2012 03:55 AM
Super User
Posts: 10,044

Re: Column heading

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;


Occasional Contributor lca
Occasional Contributor
Posts: 10

Re: Column heading

Thank you :-)

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 217 views
  • 0 likes
  • 2 in conversation