- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thank you 🙂