I'm fairly consistent with how I set up my SQL joins and for some reason the auto-complete on the from line below, will expand to AS BETWEEN. I'm ending the line on AS B but the enter key always completes BETWEEN. I'm wondering if it would be possible to make an exception to the auto-complete in this common scenario and not have B autocomplete to BETWEEN. This is more of an annoyance but I could imagine how many folks are having the same issue.
PROC SQL;
CREATE TABLE CM_STATS_JOIN
AS SELECT A.*, B.CN AS TOTAL_CM
FROM SW_STATS AS A LEFT JOIN CM_COMBINED AS B
ON A.'PUBLIC HEALTH REGION'N=B.REGION;
QUIT;