Hello, Now, i just need to make an iteratively proc append to insert "ZERO" observation into each one table listed. %macro havetb; %do i = 1 %to 5; data have&i.; x = 1; run; %end; %mend; %havetb; proc sql; create table total_have as select cats(libname,'.',memname) as nm_tables, modate from dictionary.tables where libname eq 'WORK' and modate gt intnx('month',date(),6) and memtype eq 'DATA'; quit; /* I just need to fix the code below (its getting in looping....) - Its was just my logic, if someone has another way that works just post.*/ /*creates the macro*/ %macro append(want); proc append base = &want. data = &want. (obs=0); run; %mend append; /*making the append for each table*/ data _null_; set total_have end = eof; do until(eof); %append(nm_tables); end; run; Unfortunatelly its not working...
... View more
