I have recently moved from SAS EG 6.1 to SAS EG 7.1. We use a macro which merges on some extra information based on postcode, which includes a variable called STHA. In many of our datasets, we already have STHA defned numerically (which we can format) but the Macro merges on a character variable named STHA. In SAS EG 6.1 this returned an error (or warning maybe, I forget) that STHA has been defined as both character a numeric, but it would happily power through and keep going. Since moving to SAS EG 7.1, rather than powering through, it seems that the data step where STHA is merged on returns the same error/warning and returns an empty dataset (which causes the whole Macro to fall down). Am I right in thinking that, as of SAS EG 7.1, merge won't work at all if any variables have been defined as both character and numeric? Or is something else likely to be at play here? Thanks very much for your help.
... View more