topic Re: Access LASR tables in SAS Enterprise Guide

Access LASR tables

Jim_O_CCCU — Fri, 29 Sep 2017 13:01:07 GMT

EG:7.11

VA: 7.2 (Non-distributed)

Dear all,

I can drag a LASR table from it's libray (in the servers library tree) on to the process flow - which then opens for me to view the data, but am not able to access the same programmatically...

data test;

set myvalib.mytable;

run;

Throws the following:

ERROR: Libref myvalib is not assigned

I have done a right click-->Properties on the library in the tree and have verified that the libref is correct.

Many thanks in advance

Jim

Re: Access LASR tables

SASKiwi — Fri, 29 Sep 2017 23:59:01 GMT

The default LIBREF for the public LASR library is LASRLIB. Does that work in a program?

Re: Access LASR tables

Jim_O_CCCU — Sat, 30 Sep 2017 17:33:03 GMT

Hi,

We don't have anything loaded to the public LASR, are you suggesting loading a table to that server as a test - permissions being lower or something?

Thanks

Jim

Re: Access LASR tables

SASKiwi — Sun, 01 Oct 2017 00:21:17 GMT

OK, so where does MYVALIB point to then? I just guessed it was pointing at the public laser library. Can you post the properties of this library?

Re: Access LASR tables

Jim_O_CCCU — Sun, 01 Oct 2017 11:16:24 GMT

Thanks for coming back.

Yes will, do. I'll pick this up again tomorrow once I'm back in the office.

🙂

Re: Access LASR tables

Jim_O_CCCU — Mon, 02 Oct 2017 08:19:50 GMT

OK Properties of the library are as follows:

Type: Library

Description: Visual Analytics library definition for LASR data

Server: SASVA

Engine: SASIOLA

Location: /Products/SAS VA Admin

Options:

TAG=HPS

HOST=myserverpath

SIGNER:http://myserverpath:80/

SASLASRAuthorization PORT=10011

Libref: MYVALIB

Read Only: No

Temporary: No

++++++++++++++++++++++

Thanks

Jim

Re: Access LASR tables

jltz83 — Thu, 05 Oct 2017 14:28:56 GMT

Is SASVA the selected server in your program editor?

Re: Access LASR tables

itchyeyeballs — Thu, 05 Oct 2017 18:18:00 GMT

Not seen your issue yet but we have had lots of random errors trying to use LASR tables in programs, SAS advised that its not best practice so we create duplicate old school sas7bdat files to use.

I think CAS is different in this regard

Re: Access LASR tables

Jim_O_CCCU — Fri, 06 Oct 2017 09:43:45 GMT

Hi jitz83,

Thanks very much, that worked!

Best regards

Jim