Rune:

Macro is really just text replacement / generation. Once the macro variable is resolved, your statement looks like:

proc sql; create table "SKVE9499".Sakstab as select * from "SKVE9499".sak; etc... quit;

As you know, that's invalid SQL. What you want follows ( note the double periods, the first to end the macro variable name, the second as needed for the typical libname.dataset syntax )

proc sql; create table &bibl..Sakstab as select * from &bibl..sak; quit;

-----Original Message----- From: Rune Runnestoe [mailto:rune@FASTLANE.NO] Sent: April 30, 2003 8:27 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Macro for referencing a library

I want to replace the library SKVE9499 with a macro in the following code.

proc sql; create table SKVE9499.Sakstab as select * from SKVE9499.sak;

I define the macro like this: %let bibl=SKVE9499;

and try to reference the macro like this: proc sql; create table "&bibl".Sakstab as select * from "&bibl".sak;

but receive error in the log. How is the correct table reference ?

Regards Rune Runnestoe