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 🙂
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.