The question is very basic, but your input is greatly appreciated.
I basically need to add '1' in front of the existing value of the variable (no space as delimiter). Here is my best attempt so far:
create table as select * from connection to oracle
select catx('','1',A.Var_Name) AS "#New_Var" from table_name;
I don't quite get what you want. If you have a column in Oracle and want to concatenate a value, you can use:
proc sql; select '1' || a.Var_Name from table_name; quit;