Proc Export Issues

Tegan — Mon, 14 Apr 2014 22:42:04 GMT

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;

Re: Proc Export Issues

art297 — Mon, 14 Apr 2014 22:48:59 GMT

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 — Mon, 14 Apr 2014 22:54:55 GMT

Thank you, Arthur!