Print list of datasets in LASR

[L2Fly]

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

[alexal]

@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;

[L2Fly]

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

36

37 proc sort data=tablemem nodupkey;

38 by Tablename;

ERROR: Variable TABLENAME not found.

thanks again

[alexal]

@L2Fly,

Please show me full SAS log.

[L2Fly]

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

[alexal]

@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" ;

[L2Fly]

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        

[alexal]

@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;

[L2Fly]

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;

OR

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;

[alexal]

@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;

[L2Fly]

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        

[alexal]

@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".

[L2Fly]

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.

[nhvdwalt]

Seems like engine SASIOLA is missing from the libname

[alexal]

@L2Fly,

With that libname statement, everything should work.

@nhvdwalt,

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