Desktop productivity for business analysts and programmers

create a table name with a variable name

Reply
Occasional Contributor
Posts: 16

create a table name with a variable name

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.

Super Contributor
Posts: 356

Re: create a table name with a variable name

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

Occasional Contributor
Posts: 16

Re: create a table name with a variable name

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

Ask a Question
Discussion stats
  • 2 replies
  • 335 views
  • 0 likes
  • 2 in conversation