topic how can i create multiple libraries in one run in SAS Programming

how can i create multiple libraries in one run

MSK4 — Tue, 08 Sep 2020 07:07:21 GMT

Here i'm having a dataset in which i have variables called libref and path like below

libref path

macro 'ahcb/ajbj/new

base c:/apth/sai

advance d:/sail/new

here i wont create macro, base and advance as libraries.i have used call execute but i'm getting errors.

thanks a ton.

Re: how can i create multiple libraries in one run

Kurt_Bremser — Tue, 08 Sep 2020 07:16:39 GMT

When yout get ERRORs (or WARNINGs or other messages) you do not understand, always (and I mean ALWAYS) post the whole log of that step (or macro definition and execution) by copy/pasting into a window opened with the </> button.

So please show us your log.

Re: how can i create multiple libraries in one run

Kurt_Bremser — Tue, 08 Sep 2020 07:21:57 GMT

You do not need a macro, you can use the LIBNAME function in a data step that reads your dataset.

Re: how can i create multiple libraries in one run

s_lassen — Tue, 08 Sep 2020 11:45:54 GMT

As @Kurt_Bremser remarked, you can use the LIBNAME function, e.g.:

Data _null_;
  set librefs; /* or whatever your data set is named */
  if libname(libref,path) then do;
    msg=sysmsg();
    put msg;
    end;
  else
    put 'Libname ' libref 'was assigned to path ' path;
run;