topic Re: Print list of datasets in LASR in SAS Visual Analytics

Print list of datasets in LASR

L2Fly — Tue, 30 Jan 2018 17:36:21 GMT

Dear All - I apologies in advance if I have this post in a wrong community. I like to know if there is a way to print out list of datasets (LASR tables)! At this time I am just using the screen-shot to do this.

Best

Re: Print list of datasets in LASR

alexal — Tue, 30 Jan 2018 18:51:14 GMT

@L2Fly,

LIBNAME LASRLIB <PLEASE REPLACE WITH THE LIBNAME DEFINITION FOR YOUR LASR SERVER>;

data tablemem;
    set lasrlib._T_TABLEMEMORY;
run;

proc sort data=tablemem nodupkey;
by Tablename;
run;

proc print data=tablemem;
    title "LASR Server Tables";
    var Tablename;
run;

Re: Print list of datasets in LASR

L2Fly — Mon, 05 Feb 2018 16:43:30 GMT

Thank you for your response and sorry for a late reply. When I login into EG, I select my server OA or VA and under libraries I see my LASR LIB, for example it is called "My LASR Lib" and Libref is set to "MyLASRLB".

when I use the above code with using either of the names it fails with "ERROR: Library My LASR Lib does not exist. Also I am getting the following as well

37 proc sort data=tablemem nodupkey;

38 by Tablename;

ERROR: Variable TABLENAME not found.

thanks again

Re: Print list of datasets in LASR

alexal — Mon, 05 Feb 2018 17:38:08 GMT

@L2Fly,

Please show me full SAS log.

Re: Print list of datasets in LASR

L2Fly — Mon, 05 Feb 2018 17:47:23 GMT

Thank you @alexal, before I send you the log file can you tell me if I need to use the Library name or Libref name? When I used library name since it had space in it I used "library name".

Best

Re: Print list of datasets in LASR

alexal — Mon, 05 Feb 2018 17:52:56 GMT

@L2Fly,

can you tell me if I need to use the Library name or Libref name?

LIBNAME. You should have something like that:

LIBNAME LASRLIB SASIOLA  TAG=VAPUBLIC  PORT=10031 HOST="<YOUR_LASR_HOST>"  SIGNER="<MIDDLE_TIER_URL>/SASLASRAuthorization" ;

Re: Print list of datasets in LASR

L2Fly — Mon, 05 Feb 2018 18:13:57 GMT

Here is the code I use

LIBNAME LASRLIB "Adhoc LASR LIB" TAG=ADHLASR PORT=10041 HOST="MySASServerHost.com";

data tablemem;

set lasrlib._T_TABLEMEMORY;

run;

proc sort data=tablemem nodupkey;

by Tablename;

run;

proc print data=tablemem;

title "LASR Server Tables";

var Tablename;

run;

here is the property of my library

Here is the result

1 The SAS System 10:00 Monday, February 5, 2018

1          %_eg_hidenotesandsource;
5          %_eg_hidenotesandsource;
30
31         LIBNAME LASRLIB "Adhoc LASR LIB" TAG=ADHLASR PORT=10041 HOST="MySASServerHost.com";
                                            ___
                                            22
ERROR 22-7: Invalid option name TAG.

31       ! LIBNAME LASRLIB "Adhoc LASR LIB" TAG=ADHLASR PORT=10041 HOST="MySASServerHost.com";
                                                        ____
                                                        22
ERROR 22-7: Invalid option name PORT.

31       ! LIBNAME LASRLIB "Adhoc LASR LIB" TAG=ADHLASR PORT=10041 HOST="MySASServerHost.com";
                                                                   ____
                                                                   22
ERROR: Libref LASRLIB is not assigned.
ERROR: Error in the LIBNAME statement.
ERROR 22-7: Invalid option name HOST.
32

33         data tablemem;
34             set lasrlib._T_TABLEMEMORY;
ERROR: Libref LASRLIB is not assigned.
35         run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.TABLEMEM may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.TABLEMEM was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

36
37         proc sort data=tablemem nodupkey;
38         by Tablename;
ERROR: Variable TABLENAME not found.
39         run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

40

41         proc print data=tablemem;
42             title "LASR Server Tables";
ERROR: Variable TABLENAME not found.
43             var Tablename;
44         run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
2 The SAS System 10:00 Monday, February 5, 2018

      cpu time            0.00 seconds

45
46         %_eg_hidenotesandsource;
61
62
63         %_eg_hidenotesandsource;
66

Re: Print list of datasets in LASR

alexal — Mon, 05 Feb 2018 18:34:26 GMT

@L2Fly,

This will be your program, but you have to use a SIGNER option in the LIBNAME! Do not forget that.

LIBNAME ADHLASR TAG=ADHLASR PORT=10041 HOST="MySASServerHost.com";
data tablemem;
set ADHLASR._T_TABLEMEMORY;
run;
proc sort data=tablemem nodupkey;
by Tablename;
run;
proc print data=tablemem;
title "LASR Server Tables";
var Tablename;
run;

Re: Print list of datasets in LASR

L2Fly — Mon, 05 Feb 2018 18:48:59 GMT

No luck!

LIBNAME ADHLASR TAG=ADHLASR SIGNER=https://MySASServer.com:443/SASLASRAuthorization PORT=10041 HOST="MySASServer.com";

data tablemem;

set ADHLASR._T_TABLEMEMORY;

run;

proc sort data=tablemem nodupkey;

by Tablename;

run;

proc print data=tablemem;

title "LASR Server Tables";

var Tablename;

run;

LIBNAME "My LASR Library name" TAG=ADHLASR SIGNER=https://MySASServer.com:443/SASLASRAuthorization PORT=10041 HOST="MySASServer.com";

data tablemem;

set ADHLASR._T_TABLEMEMORY;

run;

proc sort data=tablemem nodupkey;

by Tablename;

run;

proc print data=tablemem;

title "LASR Server Tables";

var Tablename;

run;

Re: Print list of datasets in LASR

alexal — Mon, 05 Feb 2018 18:58:55 GMT

@L2Fly,

Please show me full SAS log for this program:

LIBNAME ADHLASR TAG=ADHLASR SIGNER=https://MySASServer.com:443/SASLASRAuthorization PORT=10041 HOST="MySASServer.com";

data tablemem;
set ADHLASR._T_TABLEMEMORY;
run;

proc sort data=tablemem nodupkey;
by Tablename;
run;

proc print data=tablemem;
title "LASR Server Tables";
var Tablename;
run;

Re: Print list of datasets in LASR

L2Fly — Mon, 05 Feb 2018 19:39:31 GMT

1 The SAS System 11:37 Monday, February 5, 2018

1          %_eg_hidenotesandsource;
5          %_eg_hidenotesandsource;
30
31         LIBNAME ADHLASR TAG=ADHLASR SIGNER=https://MyHostName.com:443/SASLASRAuthorization PORT=10041
31       ! HOST="MyHostName.com";
ERROR: Libref ADHLASR is not assigned.
ERROR: Error in the LIBNAME statement.
32
33         data tablemem;
34         set ADHLASR._T_TABLEMEMORY;
ERROR: Libref ADHLASR is not assigned.
35         run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.TABLEMEM may be incomplete. When this step was stopped there were 0 observations and 0 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

36
37         proc sort data=tablemem nodupkey;
38         by Tablename;
ERROR: Variable TABLENAME not found.
39         run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

40

41         proc print data=tablemem;
42         title "LASR Server Tables";
ERROR: Variable TABLENAME not found.
43         var Tablename;
44         run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

45
46
47         %_eg_hidenotesandsource;
62
63
64         %_eg_hidenotesandsource;
67

Re: Print list of datasets in LASR

alexal — Mon, 05 Feb 2018 19:42:35 GMT

@L2Fly,

That is weird. May I ask you to check the libname statement for ADHLASR in SAS Management Console? Just do right-click on the library and select "Display LIBNAME Statement".

Re: Print list of datasets in LASR

L2Fly — Tue, 06 Feb 2018 00:13:31 GMT

Here it is

LIBNAME ADHLASR SASIOLA TAG=ADHLASR PORT=10041 SIGNER="https://MySASVAserver.com:443/SASLASRAuthorization" HOST="MySASVAServer.com" ;

when I run this in EG, it runs OK.

Re: Print list of datasets in LASR

nhvdwalt — Tue, 06 Feb 2018 06:06:22 GMT

Seems like engine SASIOLA is missing from the libname

Re: Print list of datasets in LASR

alexal — Tue, 06 Feb 2018 11:40:42 GMT

@L2Fly,

With that libname statement, everything should work.

@nhvdwalt,

That's funny, thanks. Sometimes, all you need is just a second pair of eyes.