I am trying to load a dataset from the microsoft SQL server into SAS using Proc SQL (as shown below)
One of the variable name contains the "&" character, which SAS interpreted as a macro variable reference, giving out a warning message 'WARNING: Apparent symbolic reference B not resolved.'
I am wondering what would be the proper way to reference this variable. Apparently quoting the variable name as literal 'A&B Variable'n does not work in the Proc SQL setting as I've tried it.
proc sql;
connect to sqlsvr(dsn=XXXX user=AAAA password=****);
create table New as
select * from connection to sqlsvr
(
Select
Base.[ID] as ID,
Base.[A&B Variable] as AB_Var
from InputDateSet as Base
);
quit;
Thanks in advance for your help.
... View more