Help using Base SAS procedures

Proc Export Issues

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Proc Export Issues

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.

mdr and event.JPGmdr.JPG

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;

mdr and event.JPGevent.JPG


Accepted Solutions
Solution
‎04-14-2014 06:49 PM
PROC Star
Posts: 7,363

Re: Proc Export Issues

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

View solution in original post


All Replies
Solution
‎04-14-2014 06:49 PM
PROC Star
Posts: 7,363

Re: Proc Export Issues

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

Occasional Contributor
Posts: 14

Re: Proc Export Issues

Thank you, Arthur!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 720 views
  • 0 likes
  • 2 in conversation