Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Print list of datasets in LASR

Reply
Frequent Contributor
Posts: 80

Print list of datasets in LASR

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

SAS Employee
Posts: 547

Re: Print list of datasets in LASR

@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;
Frequent Contributor
Posts: 80

Re: Print list of datasets in LASR

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

 

SAS Employee
Posts: 547

Re: Print list of datasets in LASR

@L2Fly,

 

Please show me full SAS log.

Frequent Contributor
Posts: 80

Re: Print list of datasets in LASR

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

SAS Employee
Posts: 547

Re: Print list of datasets in LASR

@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" ;
Frequent Contributor
Posts: 80

Re: Print list of datasets in LASR

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

2018-02-05_10-04-26.png

 

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        

 

 

 

 

SAS Employee
Posts: 547

Re: Print list of datasets in LASR

[ Edited ]

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

 

 

Frequent Contributor
Posts: 80

Re: Print list of datasets in LASR

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;

SAS Employee
Posts: 547

Re: Print list of datasets in LASR

@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;
Frequent Contributor
Posts: 80

Re: Print list of datasets in LASR

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        

SAS Employee
Posts: 547

Re: Print list of datasets in LASR

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

Frequent Contributor
Posts: 80

Re: Print list of datasets in LASR

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.

 

 

SAS Employee
Posts: 313

Re: Print list of datasets in LASR

Seems like engine SASIOLA is missing from the libname

SAS Employee
Posts: 547

Re: Print list of datasets in LASR

@L2Fly,

 

With that libname statement, everything should work.

 

@nhvdwalt,

 

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

Ask a Question
Discussion stats
  • 14 replies
  • 214 views
  • 0 likes
  • 3 in conversation