Error using WHERE clause

[David_Billa]

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.

[PeterClemmensen]

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;

[PaigeMiller]

---

@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.

[Tom]

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.