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

Dropping a LASR Table using Manual Code on Visual Data Builder

Reply
Contributor
Posts: 43

Dropping a LASR Table using Manual Code on Visual Data Builder

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

Trusted Advisor
Posts: 1,852

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

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#p1med8qs7yeafjn15d...

 

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

 

Contributor
Posts: 43

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

Posted in reply to JuanS_OCS

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.

 

Error LASR.jpg

 

Thanks.

Albert0

SAS Super FREQ
Posts: 558

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

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

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