proc sql; create table WANTas select a.addname,a.addtype,a.placement_type, b.placement_tactic from HAVE (where=(placement_tactic is missing and addtype='Default')) a left join HAVE (where=(placement_tactic is not missing and addtype ^='Default')) b on a.placement_type=b.placement_type;   insert into WANT   select * from HAVE (where=(placement_tactic is not missing and addtype ^='Default')); quit; ... View more

data _null_;    x=today();    b=intnx('week',x,0,'B');    e=intnx('week',x,0,'E');    format _all_ weekdate30.;    put (_all_)(=);    run; 15         data _null_; 16            x=today(); 17            b=intnx('week',x,0,'B'); 18            e=intnx('week',x,0,'E'); 19            format _all_ weekdate30.; 20            put (_all_)(=); 21            run; x=Wednesday, April 9, 2014 b=Sunday, April 6, 2014 e=Saturday, April 12, 2014 ... View more