topic Re: can you reference a macro variable in libname in SAS Programming

can you reference a macro variable in libname

siliconcreature — Tue, 05 Apr 2011 20:04:43 GMT

Hi there,

can you make this code work?

%let dir = "C:\";
libname c &dir;

Re: can you reference a macro variable in libname

siliconcreature — Tue, 05 Apr 2011 20:17:32 GMT

I mean this works under sas/windows, but not working with sas UNIX

Re: can you reference a macro variable in libname

RickM — Tue, 05 Apr 2011 20:30:44 GMT

I haven't used UNIX in years (and never for SAS) but I thought UNIX uses the forward slash '/' for pathnames while the default in windows is the backslash( though it will accept the forward slash as valid) so try switching it in your program.

Re: can you reference a macro variable in libname

DBailey — Tue, 05 Apr 2011 20:49:05 GMT

Are you perhaps trying to get your unix server based sas to see a directory on your local windows machine? I don't think that will work unless the sas server can "see" your local machine. There are some technologies that can let that happen, but the path would not be "c:\", it would be however your local drive was mounted to the unix server.

Re: can you reference a macro variable in libname

Ksharp — Wed, 06 Apr 2011 10:15:22 GMT

How about:
[pre]
%let dir = C:\;
libname c "&dir";

[/pre]

Ksharp

Re: can you reference a macro variable in libname

Ksharp — Wed, 06 Apr 2011 10:20:19 GMT

How about:
[pre]
%let dir = C:\;
libname c "&dir";

[/pre]

Ksharp

Re: can you reference a macro variable in libname

siliconcreature — Thu, 07 Apr 2011 14:34:31 GMT

your way is working, thank you.

Re: can you reference a macro variable in libname

PatrickG — Thu, 02 Jun 2011 15:13:12 GMT

Yeah, don't use the double quotes. With the double quotes around it, the %let stores them (along with the good stuff inside) in the symbol table...

15 %let dir = "C:\";
16 %put &dir;
"C:\"