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
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;
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;
Thank you 🙂
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.