topic Re: Error using WHERE clause in SAS Programming

Error using WHERE clause

David_Billa — Mon, 14 Oct 2019 12:44:03 GMT

Could you please help me to get rid of this error? CEDED_FLG is a character field.

26         proc sql;
27         create table temp as select * from cashflow
28         where CEDED_FLG = “Y/N”;
ERROR: Expression using equals (=) has components that are of different data types.
ERROR: The following columns were not found in the contributing tables: 'N”'n, '“Y'n.

Re: Error using WHERE clause

PeterClemmensen — Mon, 14 Oct 2019 12:46:32 GMT

Your code is fine. The code below runs without errors.

However, it seems like CEDED_FLG is a numeric variable.

data cashflow;
    CEDED_FLG="Y/N";
run;

proc sql;
create table temp as select * from cashflow
where CEDED_FLG = "Y/N";
quit;

Re: Error using WHERE clause

PaigeMiller — Mon, 14 Oct 2019 12:52:13 GMT

@David_Billa wrote:

Could you please help me to get rid of this error? CEDED_FLG is a character field.

26         proc sql;
27         create table temp as select * from cashflow
28         where CEDED_FLG = “Y/N”;
ERROR: Expression using equals (=) has components that are of different data types.
ERROR: The following columns were not found in the contributing tables: 'N”'n, '“Y'n.

In your data set cashflow, CEDED_FLG is not a character variable, it must be a numeric variable.

Re: Error using WHERE clause

Tom — Mon, 14 Oct 2019 12:52:46 GMT

Looks like you have been bitten by the Microsoft "smart" quotes. Instead of a quoted string SAS is seeing two goofy variable names being divided.

Use only normal ASCII characters in the code. Not typesetting characters intended for book publishing.