I am using a simple sql query with a macro variable in the FROM statement: %LET vormonat = 201303; %LET dynmonat = vormonat; proc sql; create table &workbib..i_fdb2bereich as select distinct bp_bereich, bp_fdb_nr from lls_com._&&&dynmonat.._EGK_VB_GESAMT where bp_referenz_nr = 0; /* Berater für Basket auswählen */ quit; 1st step: lls_com._&&&dynmonat.._EGK_VB_GESAMT && resolves to & &dynmonat. resolves to vormonat 2nd step: &vormonat._EGK_VB_GESAMT I get the error: 45 create table &workbib..i_fdb2bereich as 46 select distinct bp_bereich, bp_fdb_nr 47 from lls_com._&&&dynmonat.._EGK_VB_GESAMT NOTE: Line generated by the macro variable "DYNMONAT". 47 lls_com._&Vormonat _ 22 76 ERROR 22-322: Syntax error, expecting one of the following: a name, ;, (, ',', ANSIMISS, AS, CROSS, EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, ORDER, OUTER, RIGHT, UNION, WHERE. ERROR 76-322: Syntax error, statement will be ignored. Whats wrong? Thx, Stefan
... View more