Hi Experts, I have a library with many datasets of same variables. I am tryng to count the number of observations of each dataset by names and place them in a master dataset(result). Below are the datsets which ends with daykey. libname ab "/c:/users/desktop/files"; data_201800107 data_201800114 data_201800121 data_201800128 data_201800207 data_201800214 data_201800221 data_201800228 data_201800302 data_201800309 data_201800316 data_201800323 data_201800320 I can do this with the below code. data result; if _n_ = 1 then delete; run; %macro test; %do i = 0 %to 87; data _NULL_; OFFSET1=&i; X1=PUT(DAY(INTNX('Day',TODAY(),-(OFFSET1+0),'b')),Z2.); y1=PUT(MONTH(INTNX('Day',TODAY(),-(OFFSET1+0),'b')),Z2.); z1=PUT(YEAR(INTNX('Day',TODAY(),-(OFFSET1+0),'b')),$4.); dayk=z1||y1||x1; call symput("dayk",dayk); run; %put &dayk; %if %sysfunc(exist(ab.data_&dayk.)) %then %do; proc sql; create table new_&dayk. as select count(*) as count,name, from ab.data_&dayk. group by name; quit; data new_&dayk.; set new_&dayk.; rundate = "&dayk."; run; data result; /*for master data creation */ set result new_&dayk.; run; %end; %end; %mend test; %test; But when these data sets have month and date how can I do this. Below are the sample datasets. libname ab "/c:/users/desktop/files"; data_jan_201800107 data_jan_201800114 data_jan_201800121 data_jan_201800128 data_feb_201800207 data_feb_201800214 data_feb_201800221 data_feb_201800228 data_mar_201800302 data_mar_201800309 data_mar_201800316 data_mar_201800323 data_mar_201800320 Thanks & Regards Sanjay
... View more
