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

delete rows from a LASR table

Reply
Contributor
Posts: 50

delete rows from a LASR table

Hi Experts,

 

I am trying to delete some observations from a LASR tablel test but geting the

ERROR: Update access is not supported for file LASRLIB.test.

 

proc sql noprint;
delete
FROM    LASRLIB.test

where businessdate = today() - 3;
quit;

 

-Rahul

Regular Contributor
Posts: 172

Re: delete rows from a LASR table

Rahul, why not just reload the data in the data query builder using the exception as a filter.
Peter
Contributor
Posts: 50

Re: delete rows from a LASR table

Hi Peter,

 

Thanks for your prompt reply.

 

I can't reload the data on daily basis as table size is to large it takes 10-12 hours for full load so I loading data on daily basis by incremental load using Append Tables.

But here I need to delete last 3 days data from LASR Table and append updated last 3 days data.

 

Regards

Rahul

Regular Contributor
Posts: 172

Re: delete rows from a LASR table

[ Edited ]

Rahul,

then please check out this web page. The answes should be there

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

LASR.png

I never tested it sadly....so good to see your feedback.

Greetings Peter 

Contributor
Posts: 50

Re: delete rows from a LASR table

Hi Peter,

 

Sorry to say but didn't get anything helpful in the given link.

 

Regards

Rahul

Regular Contributor
Posts: 172

Re: delete rows from a LASR table

No Problem, that is all I can contribute for now.
Maybe check with your local SAS support.
Greetings and good luck.
Frequent Contributor
Posts: 112

Re: delete rows from a LASR table

PROC IMSTAT allows you to make changes to data that is loaded in LASR.

 

Check out this SAS Global Forum paper: Tips and Techniques for Efficiently Updating and Loading Data into SAS® Visual Analytics


Tricia Aanderud
Zencos Consulting
Twitter: @taanderud - Follow me!

Post a Question
Discussion Stats
  • 6 replies
  • 639 views
  • 2 likes
  • 3 in conversation