topic Re: syntax correction in SAS Programming

syntax correction

Geo- — Sun, 02 Sep 2018 23:37:59 GMT

Re: syntax correction

PeterClemmensen — Fri, 31 Aug 2018 08:58:40 GMT

You have to provide more information than this. Does your code produce an error? Where does your code act differently than you expect?

Re: syntax correction

RW9 — Fri, 31 Aug 2018 09:13:44 GMT

Please start by posting code as actual text, using a code window - its the {i} above post area. Secondly please post the log showing the error/warning you are inquiring about, and the code that is run as part of the log.

Re: syntax correction

FreelanceReinh — Fri, 31 Aug 2018 11:20:01 GMT

Or start by correcting the most obvious syntax errors:

line 2: missing %SYSFUNC call for MONTH function
line 5: missing percent sign before "PUT"
line 6: missing equals sign in KEEP= dataset option
line 10: incorrect "=" in WHERE statement
line 11: unbalanced closing parenthesis
missing double quotes around dataset name in DECLARE statement
missing data item in DEFINEDATA method
missing OUT keyword in OUTPUT statement of PROC SUMMARY
PROC SORT step misses a BY statement, but uses a "CLASS statement"

Has variable name CONTI_CARD_FALG been misspelled in the dataset CCARDDB.CCM_EXPD_CARD_SNAP_M_20150131?

Re: syntax correction

ballardw — Fri, 31 Aug 2018 15:56:37 GMT

In addition to @FreelanceReinh's suggestions I think you need to look very closely at your double quote characters. For example the quotes around ACCT appear to be word processor quotes and not programming quotes that look like:

HH.DEFINEKEY("ACCT");

If someone copies code from the internet or a work processor document sometimes you have "smart quotes" or similar characters instead of the ones that the program syntax parser expects.

ALL of those quotes need to be " characters.

Re: syntax correction

Geo- — Sun, 02 Sep 2018 02:57:27 GMT

thanks for your reply.I could not copy it into text since it's a exam in our company system..the correction is only considered from syntax way,no other consideration is needed