topic Re: Creating a concatenated Libname using a macro (%let) in SAS Programming

Creating a concatenated Libname using a macro (%let)

Bahr — Wed, 12 Jun 2019 20:05:26 GMT

Hi,

I sometimes work on my desktop and sometimes on my laptop. When I work on my laptop, I access files on the desk via the network, both the data and the jobs.

So when I am on the desktop I have this, accessing the data which is on desktop:

libname data1 "d:\data1";

libname data2 "d:\data2";

libname data3 "d:\data3";

libname data4 "d:\data4";

etc.

When I am on the laptop, I access the data on the desktop using the name for the desktop on the network:

libname data1 "\\SmithDT\data1";

libname data2 "\\SmithDT\data2";

libname data3 "\\SmithDT\data3";

libname data4 "\\SmithDT\data4";

What that means is every time I switch back and forth between the desktop and the laptop, I have to change or comment out the libname that is not correct. I would like be able to set it up where I only make one change, the drive name (depending on whether I am on the desktop or laptop), and have it concatenate with the subdirectory.

I have tried using %Let Drive="d:\" or %Let Drive="\\SmithDT" , and %Let SubDir="data", but then it does not seem possible to concatenate &Drive and &Subdir, because the ' becomes part of the value of the macro variable.

Thanks for any ideas, I'm using SAS 9.4

Re: Creating a concatenated Libname using a macro (%let)

Reeza — Wed, 12 Jun 2019 20:33:33 GMT

Don't put quotes around the macro variable and that's all. You can also just add some conditional logic for the program to detect where you're running from and then conditionally run one set of the code.

%let drive =D:\;

libname data1 = "&drive.\data1";

You can also use the LIBNAME function in a data step which allows you to dynamically build your string.

In general, a lot of options to solve this issue.

Re: Creating a concatenated Libname using a macro (%let)

SASKiwi — Wed, 12 Jun 2019 20:19:17 GMT

Using a UNC path should work on both computers - libname data1 "\\SmithDT\data1"; - then you wouldn't need to change any code.

Re: Creating a concatenated Libname using a macro (%let)

Tom — Wed, 12 Jun 2019 20:30:48 GMT

In macro code quotes are just like any other character (although strings inside of single quotes are not processed by the macro processor). So you should NOT include the quotes in the value of your macro variable.

%let top=D:;
libname data1 "&top\data1";
libname data2 "&top\data2";
libname data3 "&top\data3";

In regular SAS code you need quotes around strings so that the compiler knows you mean a sting literal and not a name or keyword. But the macro processor just looks for & and % triggers to know when it needs to take action so there is no need to add the quotes. Just add quotes into the code that you are using the macro variables (or macro code) to generate where SAS itself needs the quotes. Like the quotes around the path in the LIBNAME statement above.

Re: Creating a concatenated Libname using a macro (%let)

ScottBass — Thu, 13 Jun 2019 04:24:29 GMT

You've had replies about how macro variables are just literal text that get resolved during program compilation.

You've also had the suggestion to use the UNC path for both scenarios.

If that doesn't work for some reason, you can try this approach:

%macro allocate_libraries;
   %let computername=%sysget(COMPUTERNAME);
   %if (&computername eq FOO) %then %do;
      libname data1 "d:\data1";
      libname data2 "d:\data2";
      libname data3 "d:\data3";
      libname data4 "d:\data4";
   %end;
   %else
   %if (&computername eq BAR) %then %do;
      libname data1 "\\SmithDT\data1";
      libname data2 "\\SmithDT\data2";
      libname data3 "\\SmithDT\data3";
      libname data4 "\\SmithDT\data4";
   %end;
%mend;
%allocate_libraries

Substitute FOO and BAR with your desktop and laptop computer names.

This assumes that you're running Base SAS (i.e. DMS) on both machines. If you're running EG, then COMPUTERNAME would be the name of the server.

Re: Creating a concatenated Libname using a macro (%let)

ballardw — Fri, 14 Jun 2019 20:19:26 GMT

I don't want to add confusion but you may want to be careful using the phrase "concatenated libname" as in your subject line as that sounds like you want to concatenate libraries, i.e. reference multiple storage areas with a single library name.

The libname does that by something such as

libname all ( "d:\data1" "d:\data2" "d:\data3" "d:\data4");

Not a good idea if you have multiple data sets with the same name but can be useful to reference data sets stored in separate locations without having to keep track of which set is in which library.

Re: Creating a concatenated Libname using a macro (%let)

Bahr — Fri, 14 Jun 2019 21:34:17 GMT

Thanks, you're right, I didn't mean to concatenate the libname but
concatenate the, well, I don't know what it could be called, the
actual library name, like you do a character variable.

but actually, that may do what I wanted:

libname test ("\\Desktop\data" "d:\data\");

If that were on the laptop with access to the network, then it would
go to the Desktop via the network, but if it did not have access to
the network, then it would go to the second choice.

>Hi Bahr,
>
>ballardw (Super User) posted a new reply in
>SAS
>Programming on 06-14-2019 04:19 PM :
>
>
>----------
>
>
>Re:
>Creating a concatenated Libname using a macro (%let)
>
>
>
>I don't want to add confusion but you may want to be careful using
>the phrase "concatenated libname" as in your subject line as that
>sounds like you want to concatenate libraries, i.e. reference
>multiple storage areas with a single library name.
>
>Â
>
>The libname does that by something such as
>
>Â
>
>libname all (Â "d:\data1"Â Â "d:\data2" Â "d:\data3" Â "d:\data4");
>
>Â
>
>Not a good idea if you have multiple data sets with the same name
>but can be useful to reference data sets stored in separate
>locations without having to keep track of which set is in which library.
>
>Reply
>|
>Accept
>as Solution |
>Like
>this message
>
>
>
>----------
>SAS Support Communities sent this message to
>bahr.weiss@gmail.com.
>You are receiving this email because a new message matches your
>subscription to a topic.
>To control which emails we send you please go to,
>manage
>your subscription
>
>

Re: Creating a concatenated Libname using a macro (%let)

Bahr — Fri, 14 Jun 2019 21:40:17 GMT

Wow, that was simple but exactly what I wanted, thanks very much.

Re: Creating a concatenated Libname using a macro (%let)

Bahr — Fri, 14 Jun 2019 23:11:17 GMT

Thanks, actually I have three different ways to do it, all of which
are very interesting for other reasons as well. I didn't know about
the =%sysget(COMPUTERNAME) thing, which is interesting for several
reasons (it can create an indicator in the Log which computer was
being used). Thanks again.

Re: Creating a concatenated Libname using a macro (%let)

Patrick — Sat, 15 Jun 2019 01:29:28 GMT

@Bahr wrote:
...

but actually, that may do what I wanted:

libname test ("\\Desktop\data" "d:\data\");

If that were on the laptop with access to the network, then it would
go to the Desktop via the network, but if it did not have access to
the network, then it would go to the second choice.

@Bahr

That's not going to work. If one of the paths is invalid then the libname will throw an error.

Re: Creating a concatenated Libname using a macro (%let)

Bahr — Sat, 15 Jun 2019 13:34:17 GMT

Actually, on my version of SAS it generates a warning but not an
error, and writes to the first sub-directory that is valid.

810 libname test ('d:\data\Recap III' 'd:\data\recap');
WARNING: One or more libraries specified in the concatenated library
TEST do not exist. These libraries were removed from the concatenation.
NOTE: Libref TEST was successfully assigned as follows:
Levels: 1
Engine(1): V9
Physical Name(1): d:\data\recap
811 data test.temp;x=1;run;

NOTE: The data set TEST.TEMP has 1 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

812 proc contents data=test.temp;run;

NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Re: Creating a concatenated Libname using a macro (%let)

Bahr — Mon, 17 Jun 2019 03:13:10 GMT

Thanks everyone for all of the very interesting solutions. They were useful not only for this particular issue but also for better understanding of the libname command and the %let macro.

Re: Creating a concatenated Libname using a macro (%let)

Bahr — Mon, 17 Jun 2019 03:16:49 GMT

thanks, I hadn't realized that yet.