topic Macro- creating a table name with two macro variables in SAS Programming

Macro- creating a table name with two macro variables

antzlck1 — Fri, 04 Mar 2016 18:12:32 GMT

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,

Re: Macro- creating a table name with two macro variables

antzlck1 — Fri, 04 Mar 2016 18:30:59 GMT

Apologies. I've solved this.

Re: Macro- creating a table name with two macro variables

Reeza — Fri, 04 Mar 2016 20:35:23 GMT

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

Re: Macro- creating a table name with two macro variables

LinusH — Sat, 05 Mar 2016 07:12:43 GMT

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