topic Re: create a table name with a variable name in SAS Enterprise Guide

create a table name with a variable name

paul2877 — Mon, 19 Oct 2015 17:04:32 GMT

data mydb.paul_&acct_mth; set thedata;
run;

I am trying to create a table with the above variable name.. I have declared the variable name in another statement.. but it's giving me an error.

ERROR: User does not have appropriate authorization level for library WC000001.

twocanbazza — Mon, 19 Oct 2015 21:15:46 GMT

Does this work when not using the a macro var in the name, the error indicates and issue with Library permissions not the table name...

Also what is the value of the macrovar when you get the issue?

Barry

paul2877 — Tue, 20 Oct 2015 13:38:06 GMT

I found the issue.. the variable name had a special character in it