yes, but my logic (%test macro) is in base sas ... View more

%macro a (inLibref); ods output Members=Members; proc datasets library=&inLibref memtype=data; run; quit; data Members(drop=memname rename=(name=memname)); length libname $8.memname $32. ; set Members; libname="&inLibref"; run; data Vindex; set sashelp.Vindex; where libname="&inLibref"; run; proc sort data=Vindex; by libname memname ; run; proc sort data=Members ; by libname memname ; run; data Members(keep=indxname memname libname) ; merge Members(in=a) Vindex (in=b); by libname memname ; if a and b ; run; proc transpose data=Members out=Members_1 ; by libname memname; var indxname; run; data Members(keep=memname index_var); set Members_1; index_var=compbl(cat(of COL:)); run; %local datasetCount iter inLibref inMember; /*get number of datasets*/ proc sql noprint; select count(*) into :datasetCount from WORK.Members; %put " dataset count is:&datasetCount." quit; /*initiate loop*/ %let iter=1; %do %while (&iter.<= &datasetCount.); data _NULL_; set WORK.Members (firstobs=&iter. obs=&iter.); call symput("inMember",strip(Name)); call symput("index",index_var); run; proc sort data=&inLibref..&inMember. ; by id; run; proc sort data=a; by id; run; data &inLibref..&inMember.(index=(&index)); merge &inLibref..&inMember.(in=a) a(in=b); by id; if a=b then do; if name ne ' ' then name='XXXXX'; end; if a then output; run; %let iter=%eval(&iter.+1); %end; proc datasets library=work; delete Members; run; quit; %mend a; %a(test);   ... View more

replace %test(&inLibref..&inMember.); with this ( if name ne ' ' then name='XXXXX';) ... View more

Thanks,     base id name   1 qq   2 aa   3 ss   4 ss   5 dd   6 dff   7 vff   8 gggg   9 ggggg   10 rrr   11 sss   12 ssss   13 dddd   14 sssss         a id     2     5     6     7     10       %test macro   if name ne ' ' then name='XXXXX'; %macro a (inLibref); ods output Members=Members; proc datasets library=&inLibref memtype=data; run; quit; data Members(drop=memname rename=(name=memname)); length libname $8.memname $32.; set Members; libname="&inLibref"; run; data Vindex; set sashelp.Vindex; where libname="&inLibref"; run; proc sort data=Vindex; by libname memname; run; proc sort data=Members; by libname memname; run; data Members(keep=indxname memname libname); merge Members(in=a) Vindex (in=b); by libname memname; if a and b; run; proc transpose data=Members out=Members_1; by libname memname; var indxname; run; data Members(keep=memname index_var); set Members_1; index_var=compbl(cat(of COL:)); run; %local datasetCount iter inLibref inMember; /*get number of datasets*/ proc sql noprint; select count(*) into :datasetCount from WORK.Members; %put " dataset count is:&datasetCount." quit; /*initiate loop*/ %let iter=1; %do %while (&iter.<= &datasetCount.); data _NULL_; set WORK.Members (firstobs=&iter. obs=&iter.); call symput("inMember",strip(Name)); call symput("index",index_var); run; proc sort data=&inLibref..&inMember.; by id; run; proc sort data=a; by id; run; data &inLibref..&inMember.(index=(&index)); merge &inLibref..&inMember.(in=a) a(in=b); by id; if a=b then do; %test(&inLibref..&inMember.); end; if a then output; run; %let iter=%eval(&iter.+1); %end; proc datasets library=work; delete Members; run; quit; %mend a; %a(test);   ... View more

but it is showing an error. ERROR: BY variables are not properly sorted on data set WORK.A. ... View more

data cc(keep=COL:); set x; a=cat(COL:); /*error */ run; ... View more

Thanks, data Test (keep = col:); this way and also I want to concatenate the variables in a single variable . data cc(keep=COL:); set x; a=cat(COL:); /*error */ run; ... View more

Hi all, How to get below macro values. %utlfkil %utl_submit_r64 WARNING: Apparent invocation of macro UTLFKIL not resolved. WARNING: Apparent invocation of macro UTL_SUBMIT_R64 not resolved.   Thanks, SS ... View more

It is not working for this data. data have; input date ddmmyy12.; week=week(date-84); start=intnx('week',date,0,'b'); end=intnx('week',date,0,'e'); format date start end ddmmyy10.; cards; 26/03/2016 27/03/2017 28/03/2017 24/03/2017 22/03/2016 19/03/2017 16/03/2016 15/03/2017 15/03/2017 15/03/2017 14/03/2017 14/03/2017 13/03/2017 10/03/2017 10/03/2017 09/03/2017 09/03/2017 ; run; ... View more

sorry for this, I know I accepted the solution. my output should be like this. date week begin end 24/03/2018 52 18/03/2018 24/03/2018 22/03/2018 52 18/03/2018 24/03/2018 19/03/2018 52 18/03/2018 24/03/2018 16/03/2018 51 11/03/2018 17/03/2018 15/03/2018 51 11/03/2018 17/03/2018 15/03/2018 51 11/03/2018 17/03/2018 15/03/2018 51 11/03/2018 17/03/2018 14/03/2018 51 11/03/2018 17/03/2018 14/03/2018 51 11/03/2018 17/03/2018 13/03/2018 51 11/03/2018 17/03/2018 10/03/2018 50 04/03/2018 10/03/2018 10/03/2018 50 04/03/2018 10/03/2018 09/03/2018 50 04/03/2018 10/03/2018 09/03/2018 50 04/03/2018 10/03/2018 09/03/2018 50 04/03/2018 10/03/2018 ... View more