topic Re: WRITE A CODE TO CREATE ALL LIBRARIES AT A TIME FROM A DATASET? in SAS Programming

WRITE A CODE TO CREATE ALL LIBRARIES AT A TIME FROM A DATASET?

Saikiran_Mamidi — Wed, 04 Mar 2020 18:12:56 GMT

DATA A;

INPUT LIBREF$ PATH$;

CARDS;

MYLIB C:\SAS\SAI

MYSAS D:\SAS\RAJA

MYXYZ E:\SAS\RANI

;

RUN;

HERE LIBRARY HAS TO CREATE AS MYLIB IN GIVEN PATH C:\SAS\SAI

LIKE THAT ONE MORE LIBRARY HAS TO CREATE AS MYSAS IN GIVEN PATH D:\SAS\RAJA......

CAN I GET CODE FOR THIS THANK YOU...

Re: WRITE A CODE TO CREATE ALL LIBRARIES AT A TIME FROM A DATASET?

PaigeMiller — Wed, 04 Mar 2020 18:18:13 GMT

Please do not type in all capitals

DATA A;
    INPUT  LIBREF$   PATH $18.;
    call execute(cat('libname ',libref,'"',trim(path),'";'));
CARDS;
MYLIB     C:\SAS\SAI
MYSAS    D:\SAS\RAJA
MYXYZ    E:\SAS\RANI
;

Re: WRITE A CODE TO CREATE ALL LIBRARIES AT A TIME FROM A DATASET?

Saikiran_Mamidi — Wed, 04 Mar 2020 18:35:35 GMT

Very Happy with the code

Can you please explan the code call execute ?

Re: WRITE A CODE TO CREATE ALL LIBRARIES AT A TIME FROM A DATASET?

ballardw — Wed, 04 Mar 2020 18:39:06 GMT

@Saikiran_Mamidi wrote:

Very Happy with the code

Can you please explan the code call execute ?

The CALL EXECUTE creates strings that are placed in the compiler buffer for execution after the data step completes.

Re: WRITE A CODE TO CREATE ALL LIBRARIES AT A TIME FROM A DATASET?

PaigeMiller — Wed, 04 Mar 2020 18:46:02 GMT

@Saikiran_Mamidi wrote:

Very Happy with the code

Can you please explan the code call execute ?

CALL EXECUTE generates SAS code that is run after the DATA step finishes.

So after the data step finishes, the first line created by CALL EXECUTE is:

libname MYLIB   "C:\SAS\SAI";

and this runs, then the next line created runs, and so on.

Re: WRITE A CODE TO CREATE ALL LIBRARIES AT A TIME FROM A DATASET?

Saikiran_Mamidi — Wed, 04 Mar 2020 18:47:09 GMT

got it many thanks.

Re: WRITE A CODE TO CREATE ALL LIBRARIES AT A TIME FROM A DATASET?

Reeza — Wed, 04 Mar 2020 19:36:16 GMT

Typing in all caps is yelling on the internet and it's actually hard to read. Please format your questions.

To answer your question use the LIBNAME() function.https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p1bq8nyxm7y1ygn1i4vyf82z68ls.htm&docsetVersion=9.4&locale=en

RC is the return code which indicates if the function was successful.

DATA A;

INPUT  LIBREF$   PATH$;

rc = libname(libref, path);

CARDS;

MYLIB     C:\SAS\SAI

MYSAS    D:\SAS\RAJA

MYXYZ    E:\SAS\RANI

;

RUN;