thanks, I hadn't realized that yet. ... View more

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. ... View more

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 ... View more

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. ... View more

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

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 > > ... View more