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 🙂
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.