proc sort data=test;
by id visit date;
run;

proc sql;
create table maxvalue1 as
select distinct * from test
group by id
having value=max(value)
order by id, visit, date;
quit;

data maxvalue;
set maxvalue1;
by id visit date;
if first.id;
run;


proc sql;
create table dupvalue1 as
select * from test
group by value
having count(value)>1
order by id, visit,date;
quit;

data dupvalue;
set dupvalue1;
by id visit date;
if first.id;
run;

data wanted;
merge test maxvalue(in=a drop=value) dupvalue(in=b drop=value);
by id visit date;
if a or b then flag="Yes";
run;