HI! SAS 9.4 i'm trying to merge 2 datasets. When i merges this tables i want to change column "name" with condition "st = "POMPLE" and DATE < "01MAR2017"d" , but program changes all observation. Why it's happen? I know that if i do it in a new data step, everything will be executed correctly. I want to undenstand how SAS creating PDV in merging. data first_data; input st $ date date9. ; attrib date format=date9.; datalines; POMPLE 28FEB2017 POMPLE 28FEB2017 POMPLE 01MAR2017 POMPLE 01MAR2017 POMPLE 02MAR2017 POMPLE 02MAR2017 MINR 28FEB2017 MINR 02MAR2017 ; run; data sec_data; input st $ name $; datalines; POMPLE ANNA MINR GERRY ; run; proc sort data=first_data; by st; run; proc sort data=sec_data; by st; run; data merges_clon; merge first_data(in=a) sec_data(in=b); by st; run; data merges; merge first_data(in=a) sec_data(in=b); by st; IF st = "POMPLE" and DATE < "01MAR2017"d THEN name = "MOLLY"; run;
... View more