proc sql调用宏变量

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

1. proc sql noprint;
   
2. select contract_no into :contract_no separated by '","'
   
3.         from aaa;
   
4. quit;
   
5. 
   
6. proc sql;
   
7. create table bbb as
   
8.         select a.contract_no,
   
9.         from database.ccc a
   
10.         where a.contract_no in ("&contract_no.");
    
11. quit;

复制代码

提取远程Oracle数据库内ccc表内命中&contract_no.的信息，因特殊原因必须使用宏变量降低跑数据时间，请问如何修改才能跑通？

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：proc sql ROC sql contract separate 宏变量

Is contract_no numeric or character ?
If it is numeric:
    proc sql ;
      select distinct contract_no into : contract_no separated by ','
      from aaa;
    quit;


If it is character:
    proc sql ;
      select distinct "'"||strip(contract_no)||"'" into : contract_no separated by ','
      from aaa;
    quit;


GOOD LUCK

xiami2000 发表于 2018-1-31 12:14
Is contract_no numeric or character ?
If it is numeric:
    proc sql ;

It is character type variable. Thank you so much.Pity,micro variable 'contract_no' is unavilable in the 'proc sql' step connect to oracle. Like:

1. proc sql;
   
2. connect to oracle as oracledata(user=* password=** path=***);
   
3. create table ccc as
   
4.         select * from connection to oracledata(
   
5.                 select a.contract_no
   
6.                 from database.bbb a
   
7.                 where a.contract_no in (&contract_no.)
   
8.         );
   
9. disconnect from oracledata ;
   
10. quit;

复制代码

Did you create macro varible 'contract_no' as ??
   proc sql ;
       select distinct "'"||strip(contract_no)||"'" into : contract_no separated by ','
       from aaa;
     quit;
If so, please use %put &contract_no to display here.