Variable names in tables

[JeffM1968]

Howdy,

I am trying to use a variable in the middle of a table name.  Is this doable?  I am assuming yes.  Can someone help me with the correct syntax?  I tried it with/without the period and I get an error.

Thanks

Jeff

CREATE TABLE WORK.&Industry._01 AS 

[PaigeMiller]

Much more information is needed:

1. What is the value of &industry?
2. What is the exact word-for-word error message?
3. Can you send me some bacon?

[JeffM1968]

&Industry = Tech

[PaigeMiller]

You need to use the dot after &VARIABLE. The is no underscore immediately before &VARIABLE.

[sustagens · Accepted solution]

If you are just creating the table in the temporary WORK library, try removing "WORK." you can do away without specifying it in front of your table name.

There needs to be a period after the &variable_name. because there is a suffix after it.

It may also be worthwhile checking the line where Industry is assigned a value.

All of the following variations work:

%let Industry=Tech;
%put &=Industry;

proc sql;

/*create table WORK._&Industry._01 as */
/*create table _&Industry._01 as */

/*create table WORK.&Industry._01 as */
/*create table &Industry._01 as */

select * from sashelp.cars;
quit;

[JeffM1968]

All of these tidbits did the trick.

Thanks!!

[Reeza]

Check how your macro variable is being created and resolved. You may have some spaces after it causing it to resolve as:

 WORK.TECH      _01 AS 

You can check by using the appropriate debugging options and seeing this in your log:

options mprint symbolgen;

If this is the case, you can fix it by using CALL SYMPUTX() (note the X) or TRIMMED option if you're creating the macro variable via SQL which will remove the trailing spaces.