all 3 tables have the same file numbers as a column. The country of birth is different on the mothers/fathers table for some file numbers as they have been updated. I need to use these updated records to update the other table but still keep the countries for the records that have not been updated. ... View more

all 3 tables have the same file numbers as a column. The country of birth is different on the mothers/fathers table for some file numbers as they have been updated. I need to use these updated records to update the other table but still keep the countries for the records that have not been updated. ... View more

thanks, that was it. I'm just learning sas. ... View more

I'm a new sas user and I've never heard of brute force. Is this close? data slash (keep=temp); set ytd; format date MMYYN.; run; ... View more

They are in text format. ... View more

Work. thanks. ... View more

Has this error: ERROR: Expression using equals (=) has components that are of different data types ... View more

I'm a new sas user. Not sure how to use the sql. ... View more