sorry I am wrong, my dates are like this. I should make that in  week, weekbegin,weekend.   24/03/2018 22/03/2018 19/03/2018 16/03/2018 15/03/2018 15/03/2018 15/03/2018 14/03/2018 14/03/2018 13/03/2018 10/03/2018 10/03/2018 09/03/2018 09/03/2018 ... View more

Thanks a lot, SS ... View more

Thanks Surya, It is working but start date and end dates should be dynamic, As I said start date/week is weekend of March.(Sunday to Saturday). Thanks, SS ... View more

Last weekend of the every march (week start on sunday ends on Saturday). ... View more

Thanks Kurt, My base sas code is working fine but I want to make it dynamic and I don't want to sort the data because by variable name is different in other tables (ex: ID, in other table this ID is "empID") so I am looking in proc sql. my all macro %macro test(dsname,varname); %if %varexist(&dsname,&varname) %then %do; %if %getvartype(&dsname,&varname)=C %then %do; if &varname ne ' ' then &varname = "xxxxx"; %end; %else %if %getvartype(&dsname,&varname)=N %then %do; if &varname ne . then &varname =11111; %end; %end; %mend test; %macro all(dsname); %test(&dsname,Name); %test(&dsname,forename); %test(&dsname,sal); %mend all; Thanks,   SS ... View more

below logic is working but I want to make  that dynamic in macro data d; set a; if id in(10,11,12,13,14,15,16,17,18,19) then %all(a) ; run; ... View more

a dataseet   Name Sex Age Height Weight id Alfred M 14 69 112.5 1 Alice F 13 56.5 84 2 Barbara F 13 65.3 98 3 Carol F 14 62.8 102.5 4 Henry M 14 63.5 102.5 5 James M 12 57.3 83 6 Jane F 12 59.8 84.5 7 Janet F 15 62.5 112.5 8 Jeffrey M 13 62.5 84 9 John M 12 59 99.5 10 Joyce F 11 51.3 50.5 11 Judy F 14 64.3 90 12 Louise F 12 56.3 77 13 Mary F 15 66.5 112 14 Philip M 16 72 150 15 Robert M 12 64.8 128 16 Ronald M 15 67 133 17 Thomas M 11 57.5 85 18 William M 15 66.5 112 19   b dataset; id 10 11 12 13 14 15 16 17 18 19 now I want repalce the values of name varable with XXXX. if  the condition meets in b datasets(based on ID) elase don't change. ... View more

data names; set names; %all(name); where id in (Erased);/*((this kind of approach i am looking for)*/ run; ... View more

Thanks Satish, %macro var(ds,var); if &var ne ' ' then &var = "xxxxx"; %mend var; %macro all(ds); %var(&ds,var); %mend all; ... View more

yes,It is working and I accepted it. Thanks, SS ... View more