In fact, the figure was generated from ----------------------------------------------------------- %macro filter_age(age_start, age_end); %local today_; %let today_ = %sysfunc(intnx(year, %sysfunc(today()), 0), date9.); proc sql outobs = &a; create table filter_age as select distinct cif_num, yrdif(birth_dt, "&today_"d, 'actual') as age from test quit; %mend filter_age; %filter_age(10, 20); ----------------------------------------------------------- "test" data is CIF_Num Birth_Dt 123 12NOV1993 1234 16AUG1976 12345 29OCT1964 ----------------------------------------------------------- and what my expected is that after input the age interval, I can create a table including all of information about this specific generation. That is why I add "where calcuated age between &age_start and &age_end"
... View more