BookmarkSubscribeRSS Feed
L2Fly
Pyrite | Level 9

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

14 REPLIES 14
alexal
SAS Employee

@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
Pyrite | Level 9

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
SAS Employee

@L2Fly,

 

Please show me full SAS log.

L2Fly
Pyrite | Level 9

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
SAS Employee

@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
Pyrite | Level 9

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        

 

 

 

 

alexal
SAS Employee

@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
Pyrite | Level 9

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
SAS Employee

@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
Pyrite | Level 9

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
SAS Employee

@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
Pyrite | Level 9

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
Barite | Level 11

Seems like engine SASIOLA is missing from the libname

alexal
SAS Employee

@L2Fly,

 

With that libname statement, everything should work.

 

@nhvdwalt,

 

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 14 replies
  • 1346 views
  • 0 likes
  • 3 in conversation