Thank you. The all caps of Library worked. I am trouble shooting the rest of the code. /* Count distinct IDs in all of these data sets */ data _null_; set dsnames; length str $ 1024; str=cats('proc sql; create table ids as select "' ,memname,'" as memname length=32,count(distinct ptid) as n from Labor.',memname,';quit;'); str2='proc append base=all new=ids; run;'; str3='proc delete data=ids; run;'; call execute(cat(str,str2,str3)); run;
... View more
