language-stata
language-stata copied to clipboard
odbc sql command with macro
I have a sql query in an odbc command that contains a stata macro. It seems that the sql language highlighter is getting hung up on the backtick and treating everything after the backtick until the end of the file as a string.
Example:
odbc load, exec("select `audit_vars' from audit_audit_comp.auditfees") dsn("wrds_pgdata-64") clear
Everything from audit_vars
onwards, until the end of the file, is highlighted as a string.