Macro- creating a table name with two macro variables

[antzlck1]

Hi,

Here is the first part of a macro I’m trying to create. However I get an error trying to run the &a._&b part i.e. create a table in WORK. Can someone let me know what is going on? What am I missing? I’ve never created SAS macros before so this all new to me.  

Thank you

%macro xyz(a,b);

PROC SQL;

   CREATE TABLE &a._&b AS

   SELECT DISTINCT t1.&b,

[antzlck1]

Apologies.  I've solved this. 

[Reeza]

Perhaps post the solution, but please mark it solved as well 🙂

[LinusH]

I guess that the solution is to have double periods after the &a. A single period is being eated by the macro variable resolution.