topic ERROR: Expression using equals (=) has components that are of different data types. in SAS Enterprise Guide

ERROR: Expression using equals (=) has components that are of different data types.

Ela_84 — Fri, 16 Aug 2019 07:05:14 GMT

Hi there everyone,

I'm still new to the sas world and currently stuck trying to format a variable.

I have a proc sql step and I'm hitting a sequel table but the column I'm matching it with is not numeric. I'm wanting to format b.AccountNumber; to numeric but not sure what steps to take.

see below

proc sql; create table FTY1 as select
a. *
,b. ResponseCodeMessage

from FTY a left outer join COL.biz b on a.Account_number=b.AccountNumber;
quit;

Re: ERROR: Expression using equals (=) has components that are of different data types.

PeterClemmensen — Fri, 16 Aug 2019 07:05:27 GMT

I assume that b.AccountNumber is the one that is not numeric?

proc sql; create table FTY1 as select
a. *
,b. ResponseCodeMessage
from FTY a left outer join COL.biz b on a.Account_number=input(b.AccountNumber, best.);
quit;

Re: ERROR: Expression using equals (=) has components that are of different data types.

Ela_84 — Fri, 16 Aug 2019 07:07:00 GMT

that's correct - Thank you SOOOO much.

I will give it a try and let you know if it works.

Appreciate this alot.

Re: ERROR: Expression using equals (=) has components that are of different data types.

PeterClemmensen — Fri, 16 Aug 2019 07:11:07 GMT

Anytime, let me know if it works for you

Re: ERROR: Expression using equals (=) has components that are of different data types.

Ela_84 — Fri, 16 Aug 2019 07:13:24 GMT

Thank you so much Draycut - it worked appreciate the help again.

Have an awesome day!

Re: ERROR: Expression using equals (=) has components that are of different data types.

rajeshm — Thu, 13 Aug 2020 13:14:14 GMT

Thanks for the answer ,useful to me.

q1: one col is numeric and one col is char. when comparing which is best ? char to numeric conversion or numeric to char ? please give some explanation,please.

Re: ERROR: Expression using equals (=) has components that are of different data types.

TomKari — Thu, 13 Aug 2020 19:31:04 GMT

It depends...

Don't you love that answer? But seriously, it does, and here are some of the considerations.

If you're SURE that your character column always contains number, and you can reliably convert them to numeric, then I would go with numeric, as it's not subject to odd formatting issues (does '5 ' equal '5'? does ' 5' equal '5'?)

If you're going to have issues (e.g. converting 'abc' to numeric), then you might want to go with character. It may be challenging to figure out how to convert your numeric value to character, SAS has lots of functions to help. (There's the subject for your next question!)

In either case, be cautious about numbers with fractions. They don't always convert nicely to the hexadecimal used by computers, and two numbers that look similar can actually be different.

My two cents worth!

Tom

Re: ERROR: Expression using equals (=) has components that are of different data types.

rajeshm — Sat, 15 Aug 2020 19:20:30 GMT

thanks for reply.

I did not get answer for my question.

we can convert from numeric to character (or vice versa)

My intention is to know which conversion should be happened to get better performance?

(char to numer or numer to char)??

Re: ERROR: Expression using equals (=) has components that are of different data types.

PaigeMiller — Sat, 15 Aug 2020 19:43:50 GMT

@rajeshm wrote:

we can convert from numeric to character (or vice versa)

My intention is to know which conversion should be happened to get better performance?

(char to numer or numer to char)??

What do you mean by "performance"?

Re: ERROR: Expression using equals (=) has components that are of different data types.

rajeshm — Sun, 16 Aug 2020 21:44:48 GMT

several ways to find a solution to a problem.
suppose i have a case to compare numeric with char.
if i convert character to numeric and comparing with numeric will be executed in less time ? or
if i convert numeric to character and comparing with character will be executed in less time?

Re: ERROR: Expression using equals (=) has components that are of different data types.

PaigeMiller — Sun, 16 Aug 2020 21:49:24 GMT

I don't know, buy you can find the answer easily enough.

Create data sets where the variable of interest is numeric and a similar data set where the variable of interest is character.

Then compare by converting to character to numeric. Then compare by converting numeric to character. Which one runs faster?