Hello everyone, I really need some advise. I have table whose column names are numbers and I can't change this setting. Now I am trying to find a solution how to union this table with others in SAS Studio. Here's what I got so far: options msglevel=i;
options noquotelenmax;
options validvarname=ANY; /* for variables*/
filename genFuncs FILESRVC folderpath='/department/lib_name' filename='general_functions_v2.sas';
%include genFuncs / source;
proc cas;
%casFunctions;
outCaslibName="lib_name";
casTableName="table_union";
tmpTableName = casTableName || "_" || rand("Integer", 111111, 999999);
createTableString="create table lib_name." || tmpTableName ||" {options replace=true} as (
select v.month from lib_name.normal_table v
union all
select t.'198'n from lib_name.uqly_table t
)"; and I can't convince SAS, that '198'n is the month column name. error
... View more
