- %macro varnames(libname,dataset);
- %global varlist;
- PROC SQL noprint;
- SELECT name INTO :varlist
- separated by " "
- FROM dictionary.columns
- WHERE libname=upcase("&libname.") AND memname=upcase("&dataset.");
- QUIT;
- %PUT &varlist.;
- %mend;
- %varnames(sashelp,class);
- data _null_;
- if find("&varlist.",'a1') then do;
- put '变量a1在数据集sashelp.class中!';
- end;
- else do;
- put '变量a1不在数据集sashelp.class中!';
- end;
- run;