现在有这样的问题:在面板数据中,有一个截面和时序识别变量,分别为area和year,还有若干分析变量,假设有如下的数据:
area year x y z
dd 2011 45 56 66
dd 2012 45 89 34
ee 2011 68 98 78
cc 2011 56 87 45
cc 2012 78 35 65
data aa;
input area $ year x y z ;
cards;
dd 2011 45 56 66
dd 2012 45 89 34
ee 2011 68 98 78
cc 2011 56 87 45
cc 2012 78 35 65
;
run;
proc sql;
create table bb as
select * from aa
where area in (select area from aa group by area having count(*)>1)
;
quit;