The following data set work.in has an index in the variable id and the following SAS program is submitted:
为什么这道题的答案是:
The index on id is deleted
我查了一下dictionary 这个library,发现index ID还是存在的啊?求大神解答。。。
/*******************************************************
options msglevel=i;
data in(index=(id));
input id dept $ var_1 var_2;
cards;
123 math 20 30
121 art 40 10
124 science 30 50
;
data im;
set in(keep =id var_1 var_2 rename=(id=idnum));
Total=sum(of var_1 var_2);
/*by idnum;*/
run;
proc sql;
create table inlook as
select *from dictionary.indexes
where libname='WORK';
quit;