topic Re: Dropping a LASR Table using Manual Code on Visual Data Builder in SAS Visual Analytics

Dropping a LASR Table using Manual Code on Visual Data Builder

Albert0 — Mon, 08 Jan 2018 07:55:41 GMT

Hi All,

I would like to ask on what code could I use to drop a table in order for me to delete or drop a table in LASR using Manual Code on Data Builder?

I've tried using the code below using SAS Studio and it works fine. However, when using Data Builder I'm getting an error using the code below.

proc datasets lib= <libname>;

delete <table name>;

quit;

Can anyone suggest an alternative way to do this using Data Builder?

Thanks.

Albert0

Re: Dropping a LASR Table using Manual Code on Visual Data Builder

JuanS_OCS — Mon, 08 Jan 2018 08:10:03 GMT

Hello @Albert0,

some additional information, such as the specific error, would help us.

However, I would initially expect that you are trying to delete a table from LASR server/RAM memory (not the disk), which could explain error during a drop table. Perhaps you would need to use a code as the following one:

http://support.sas.com/documentation/cdl/en/inmsref/67213/HTML/default/viewer.htm#p1med8qs7yeafjn15d3jiwr4fbrs.htm

Otherwise, it could be a problem of permissions on SAS metadata, but let us focus on the error and the code for now.

Hope it helps.

Kind regards,

Juan

Re: Dropping a LASR Table using Manual Code on Visual Data Builder

Albert0 — Tue, 09 Jan 2018 01:29:25 GMT

Hi Juan,

Below is the screenshot of the error. I need to drop the LASR Table because if there are updates on that table I will hit an error because the old table exists. Basically, on my SAS code (using EG) I coded proc dataset so the table will be drop on the LASR Server. But when I migrate it on the Data Builder of VA, it generates me an error. I'm also wondering that why did the proc datasets work using EG and not on VDB but they both drop the same LASR Table.

Thanks.

Albert0

Re: Dropping a LASR Table using Manual Code on Visual Data Builder

alexal — Tue, 09 Jan 2018 12:14:32 GMT

@Albert0,

From where you loading the data? Are you sure that SAS Enterprise Guide and VDB is using the same application server context? How many application server contexts do you have on the server? All of them have been configured to use UTF8? Also, I would like to know the exact version of SAS and see ViewRegistry Report.