Help using Base SAS procedures

SQL Error Messsages

Reply
Contributor
Posts: 42

SQL Error Messsages

Hi All,

Is there a system option which will give me more meaningful error messages in EG than the below?

ERROR: Prepare error: ICommandPrepare:Smiley Tonguerepare failed.
SQL statement: SELECT C.CLAIMID , C.CLAIMNUMBER , AI.DESCRIPTION , AI.ESTIMATEAMOUNT FROM CBMRV_ASSESSMENTITEM AI , CBMRV_INCIDENT
I , CBMRV_CLAIM C , CBMRVL_REFERENCELISTS VC , CBMRVL_REFERENCELISTS AA WHERE C.CLAIMID = I.CLAIMID AND I.INCIDENTID =
AI.INCIDENTID ORDER BY C.CLAIMID VC.DESCRIPTION.

Thank you for your help.
Super User
Posts: 5,260

Re: SQL Error Messsages

You probably should open a track on SAS support for this.
There are a number of usage notes that describes different kind of prepare errors.
I'm not sure if you can get any more information than this. If your data resides in an external RDBMS, you could try the sastrace global option, see on-line doc for details.
/Linus
Data never sleeps
Valued Guide
Posts: 2,175

Re: SQL Error Messsages

surprising to see no FROM in the generated syntax
Ask a Question
Discussion stats
  • 2 replies
  • 147 views
  • 0 likes
  • 3 in conversation