topic Re: -merge- error message in SAS Procedures

-merge- error message

VS — Fri, 13 Dec 2013 03:07:52 GMT

Hi,

I am trying to merge two files on DRG variable, which is character in both files (it includes numbers and letters).

But i get an error message:

31 data allmatched5 ;

32 merge allmatched4 (in=dat) HIP.DRG (in=drg);

ERROR: Variable drg has been defined as both character and numeric.

I've tried to 're-build' DRG to see what will happen, but the message persists.

I would be very grateful if anyone has any ideas/suggestions how to deal with this issue.

Thanks

Victoria

DATA HIP.DRG (DROP = DRG RENAME = (TEMP = DRG));

SET HIP.DRG;

TEMP = PUT(DRG, 4.);

RUN;

DATA allmatched4 (DROP = DRG RENAME = (TEMP = DRG));

SET allmatched4;

TEMP = PUT(DRG, 4.);

RUN;

PROC SORT DATA=allmatched4;

BY DRG;

RUN;

PROC SORT DATA=HIP.DRG;

BY DRG;

RUN;

DATA allmatched5 ;

MERGE allmatched4 (in=dat) HIP.DRG (in=drg);

by DRG;

if (dat) then merge = 1;

if (drg) then merge = 2;

if (drg and dat) then merge = 3;

RUN;

Re: -merge- error message

Astounding — Fri, 13 Dec 2013 03:19:20 GMT

DRG is a character variable in your data set. You can't also use it as an IN= variable, which would be numeric. Just change the name of the IN= variable from DRG to anything else that isn't already in use.

Re: -merge- error message

Quentin — Fri, 13 Dec 2013 03:23:32 GMT

Hi,

Your datasets allmatched4 and HIP.DRG both have a character variable named drg in them, right?

When you code in=drg as below:

 merge allmatched4 (in=dat) HIP.DRG (in=drg);

You are asking SAS to create a numeric variable named drg which will be 1 if a record was read from HIP.DRG, else 0.

So because there is already a character variable named drg in the program data vector, trying to create a numeric variable named drg causes the error.

If you change to in=indrg , your code should work.

HTH,

-Q.

Re: -merge- error message

VS — Fri, 13 Dec 2013 03:28:18 GMT

Thanks you both!!! For the solution and promptness!