topic na in SAS Programming

na

edasdfasdfasdfa — Wed, 28 Aug 2019 16:49:45 GMT

Re: Not sure why there is an Error

PaigeMiller — Wed, 28 Aug 2019 16:32:16 GMT

What does the error say? Show us the SASLOG (not just the errors, but the log for the entire PROC that has the error). Paste the log into the window that appears when you click on the {i} icon.

Re: Not sure why there is an Error

edasdfasdfasdfa — Wed, 28 Aug 2019 16:50:11 GMT

Re: Not sure why there is an Error

PaigeMiller — Wed, 28 Aug 2019 16:40:13 GMT

Please paste the log into the window that appears when you click on the {i} icon.

Re: Not sure why there is an Error

hashman — Wed, 28 Aug 2019 16:44:58 GMT

@edasdfasdfasdfa:

SQL doesn't understand the => operator, hence the syntax error. Use either >= or the mnemonic GE instead, and it will go away.
Your outer CASE clause is not closed with ELSE. Though It's not a syntax error, you'll get a missing value as a result if no WHEN condition in that outer clause is true. SAS will warn you about it in the log, so pay attention or else your output data may be wrong.

Kind regards

Paul D.