在Proc SQL Teradata传递中使用SAS宏变量

您可以使用

%BQUOTE()

%let input_date = 2015-06-01;proc sql;  connect to teradata as tera(user=&tera_user password="&tera_pwd" tdpid=terap);  create table MYDATA as   select * from connection to tera  (   select * from TD.DATA where date = %BQUOTE('&INPUT_DATE')  );  disconnect from tera;quit;