Appending two datasets

[tarheel13]

What is the desired format of DOB? You will have to use the conversion functions, either input or put to convert it to the same type. Once you do that you should be able to concatenate your datasets.

[tarheel13]

Please try this. First convert DOB to mmddyy10 in view2 then stack it together with view1 in a data step.

data view2(drop=tempvar);

set SASCDC_2.Arias_VIEW_2(rename=(dob=tempvar));

dob = input(tempvar, mmddyy10.);

run;

data want;

set SASCDC_2.Arias_VIEW_1 view2;

run;

[wlierman]

Hello,

Your coding worked in that the two datasets stacked vertically and the DOB - numeric and text - issue has been solved.

Thank you very much.

I want to recommend your method as a Solution but don't see where I can - because I had already designated a solution but your answer is complete.  I will indicate that this is a Solution, if you could direct me to how to do so.

Thank you again for this help.

wlierman