Hello Everyone, SAS 9.4 I have missing data in Table A, and Table B contains that missing data. How do I go about taking data from Table B and populating it into Table A? I have attached an over-simplified Excel file to help visualize what I am talking about. Table A is the original data source, Table B is the data source I want to use to populate the missing data in Table A, and Table C is what I would like the end result to be. To be more specific, I am missing some StudentID's from my original data source (Table A). I want to use another data source (Table B) to populate the missing StudentID's in Table A by using a shared column between the two tables, PersonID. Here is what I have tried so far, and I don't think it's working as I want it to. proc sort data=TableA out=TableA_sort;
by PersonID;
run;
proc sort data=TableB out=TableB_sort;
by PersonID;
run;
data TableC;
merge TableA_sort (in=inTableA_sort) TableB_sort (in=inTableB_sort); by PersonID;
if inTableA_sort=1 and inTableB_sort=1;
run; Thank you
... View more