SAS中比较(查询除外)的标签

Question

hi我正在运行以下程序。第一个查询返回我需要的内容。。。我只是想添加一个列来了解对象的内部环境。第二个查询不起作用，因为它查看"P"one_answers"t"列并比较

1(

proc sql;
create table ALL_compare_PROD_TEST as 
(select * from PROD Except select * from TEST)
UNION ALL 
(select  * from TEST Except select * from PROD)
ORDER BY code ASC
;QUIT;

2(

proc sql;
create table ALL_compare_PROD_TEST as 
(select 'P'as PROD, * from PROD Except select * from TEST)
UNION ALL 
(select 'T'as TEST, * from TEST Except select * from PROD)
ORDER BY code ASC
;QUIT;

Answer 1

听起来您只需要另一个级别的子查询。此外，您还希望P和T在同一个变量中。

proc sql;
create table ALL_compare_PROD_TEST as 
select 'P' as SRC,* from (select * from PROD except select * from TEST)
UNION ALL 
select 'T' as SRC,* from (select * from TEST except select * from PROD)
ORDER BY code ASC
;
quit;