data a;
input x xdat xdatx y@@;
cards;
1 2 3 4
;run;
proc sql noprint;
select distinct name
into :class separated by ' '
from dictionary.columns
where kindex(name,"dat"); quit; */ 所有dat
*/where substr(name,length(name)-2,3)="dat"; 只结尾
data final;
set a;
keep &class;
run;
if you want to find dat in a certain dataset, try this
%macro getvarlst(inds=, string=);
proc sql;
create table varlst as
select distinct name as variable
from dictionary.columns
having memname=upcase("&inds") and kindex(name,"&string");
quit;
%mend;
%getvarlst(inds=a, string=dat);
楼主，我的程序是楼上的仁兄写的，是这样的：
data a;
input x xdat xdatx y@@;
cards;
1 2 3 4
;run;
为了挑出数据集a里面的 xdat xdatx，用以下程序
proc sql noprint;
select distinct name
into :class separated by ' '
from dictionary.columns
where kindex(name,"dat");
quit;
然后你 %put &class的话会出现很多含有“dat”的变量，但这些变量都不在数据集A里面的
谢谢你，SAS还是要多看几本书啊，我们教材根本没这些东西。
proc sql noprint;
select distinct name into :class separated by ' '
from dictionary.columns
where kindex(name,"dat")
and library = "Work"
and memname = 'A'
;
quit;
这个出现运行的时候 library=“work”出错，不过有后面的memname其实也就行了，就是不知道为啥library这里会出错
扫码加好友，拉您进群
全部版块
我的主页
收藏
