On the merge function, looking the on-line documentation (http://support.sas.com/documentation/cdl/en/basess/58133/HTML/default/viewer.htm#a001318494.htm) There is a description when two records are merged, and one field has the same name. The documentation indicates the last record read will be the value in the merged record. (from the website) If you do not use the RENAME= option and a variable exists in more than one data set, then the value of that variable in the last data set read is the value that goes into the result record. My question: is there ever a time when the field in the first record will ever be the value in the result record? IE: Record1: field expressn (size char(4)), description code Record2: field expressn (size char(1)), express (value x or space) Data merge_record; Merge (record1, record2) On fields a, b Would merge_record.expressn ever be size char(4) – descriptive code? As I understand the on-line documentation, the merge_record.expressn will always be size char(1) – express (value x or space). Any help would be much appreciated.
... View more