Proc Export Issues

[Tegan]

I can't get these proc export queries to run on these variables.  Is there something wrong with the formatting, or with my query, or both?

Proc export data=MAUDE.Total1999thru2013 (where=(MDR_REPORT_KEY<'50'))

dbms=excel file="...\Output\test11.xls";

run;

ERROR: WHERE clause operator requires compatible variables.

ERROR: Export unsuccessful.  See SAS Log for details.

Proc export data=MAUDE.Total1999thru2013 (where=(MDR_REPORT_KEY ='100'))

dbms=excel file="...\Output\test13.xls";

run;

ERROR: WHERE clause operator requires compatible variables.

ERROR: Export unsuccessful.  See SAS Log for details.

Proc export data=MAUDE.Total1999thru2013 (where=(EVENT_KEY ='100'))

dbms=excel file="...\Output\test14.xls";

run;

141! Destination\Output\test14.xls";

ERROR 22-322: Syntax error, expecting one of the following: ;, DATA, DBLABEL, DBMS, DEBUG, FILE,

              LABEL, OUTFILE, OUTTABLE, REPLACE, TABLE, _DEBUG_.

ERROR 76-322: Syntax error, statement will be ignored.

142  run;

[art297 · Accepted solution]

Remove the quotes from your value in the where option.  The field is numeric e.g. 50, but you are trying to compare it to '50' i.e., character

[Tegan]

Thank you, Arthur!