I want to use a macro variable in a WHERE condition in a PROC SQL, but I need to to be evaluated as a number because Var3 below is numeric.   %let horizon=201606: PROC SQL; CREATE TABLE CTX AS SELECT Variables FROM Table1 T1 LEFT JOIN Table2 T2 ON (T1.Var1=T2.Var1) WHERE T2.Var3 le %EVAL(put(&Horizon.,6.)); QUIT;       How can I go about this? ... View more

SAS Enterprise Guide 5.1   I have two similar data sets, say Table1 and Table2 (basically they structurally are the same data set similar variables (with different cell values) regarding different periods), with 64 columns and approximately 550K rows.   I'd like to do the following.   PROC SQL; CREATE TABLE JOINED TABLE AS SELECT Some variables FROM Table1 T1 LEFT JOIN Table2 T2 ON ((T1.Var1=T2.Var1 AND T1.Var2=T2.Var2) OR T1.Var1=T2.Var2); QUIT;   But it's just too slow.   Is there a (much) more efficient way of achieving the same result?   Thanks.     Here's an example.   DATA Data201606; LENGTH Var1 $ 14 Var2 $ 14 WholeBunchOfVars_201606 $ 24 ; FORMAT Var1 $CHAR14. Var2 $CHAR14. WholeBunchOfVars_201606 $CHAR24. ; INFORMAT Var1 $CHAR14. Var2 $CHAR14. WholeBunchOfVars_201606 $CHAR24. ; INFILE DATALINES4 DLM='7F'x MISSOVER DSD ; INPUT Var1 : $CHAR14. Var2 : $CHAR14. WholeBunchOfVars_201606 : $CHAR24. ; DATALINES4; 42001223829005420012238211001913672811803603960 42001223829005420012238291001913672811803603960 42001223829005420012238221001913672811803603960 42005537849003420055378411001728228741505881940 42000000420200 149282958163677760150000 42000001251100 137224761123272858132500 42000002571100 115006036153103523280000 42000002992100 176705643184314704200000 42000003721100 134284160134284151225000 ;;;; DATA Data201607; LENGTH Var1 $ 14 Var2 $ 14 WholeBunchOfVars_201607 $ 24 ; FORMAT Var1 $CHAR14. Var2 $CHAR14. WholeBunchOfVars_201607 $CHAR24. ; INFORMAT Var1 $CHAR14. Var2 $CHAR14. WholeBunchOfVars_201607 $CHAR24. ; INFILE DATALINES4 DLM='7F'x MISSOVER DSD ; INPUT Var1 : $CHAR14. Var2 : $CHAR14. WholeBunchOfVars_201607 : $CHAR24. ; DATALINES4; 42001223829005420012238221001913672811803603960 42001223829005420012238211001913672811803603960 42001223829005420012238291001913672811803603960 48073274008100...50000 48077274928100...150000 48120011318100...200000 48097297288100...200000 48001314298100...250000 48035295388100...575000 48089429268100...600000 48001012248100...600000 48075642348100...700000 42026909980100.000000000.25000 42001115759100.000000000145868575112500 42014081290100.00000000015346509325000 48000000048500.001241385.50000 48000000048400.001241385.150000 ;;;; PROC SQL; CREATE TABLE JOINED_TABLE AS SELECT * FROM Data201606 T1 LEFT JOIN Data201607 T2 ON ((T1.Var1=T2.Var1 AND T1.Var2=T2.Var2) OR T1.Var1=T2.Var2); QUIT; ... View more

I'm on SAS EG 5.1, Windows 7 and my keyboard input is Portuguese (Portugal).   On this link one can read the following.   Jump to the "end of scope" Move caret to matching parenthesis/brace: Ctrl + [, Ctrl + ] Move caret to matching DO/END keyword: Alt + [, Alt + ]   I managed to make the parenthesis shortcut work by hitting Ctrl+0, where 0 is the key above the alphabet, other characters shared by this key are the equal sign (=) and the right curly brace (}). I can't, however, make the other shortcut work. I tried it with %DO and DO and neither worked. I tried placing the cursor at the left of %, immediate left of D, immediate left of O and immediate right of O and neither worked.   Can anyone help me out with this? ... View more