Excel???????? Why the heck would you use Excel to generate SAS code?
%let catalog=work.mycat ;
%let dir=~/test ;
filename code temp;
data _null_;
set sashelp.vcatalg ;
where libname="%upcase(%scan(&catalog,1,'.'))"
and memname="%upcase(%scan(&catalog,2,'.'))"
and objtype='SOURCE'
;
length catalog fname $200 ;
catalog=catx('.',"&catalog",objname,objtype);
fname = catx('/',"&dir",cats(lowcase(objname),'.sas'));
file code ;
put 'data _null_;'
/ ' infile ' catalog :$quote. 'catalog;'
/ ' file ' fname :$quote. ';'
/ ' input;'
/ ' put _infile_;'
/ 'run;'
;
run;
%include code ;
... View more