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

delete rows from a LASR table

Reply
Contributor
Posts: 64

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: 173

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: 64

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: 173

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: 64

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: 173

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: 123

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!

Occasional Contributor
Posts: 9

Re: delete rows from a LASR table

I just wanted to know if you managed to find anything related to this question, because I have similar problem.

I need to delete ~1000 rows every hour from roughly table with 22 000 000 rows of data.

 

If you have any questions I asked in topic "Best way for frequent and fast refresh of data on LASR server".

Regular Contributor
Posts: 173

Re: delete rows from a LASR table

Hi there

this is the sas code if you want to delete LASR data with scheduled scripting

 

libname LASR sasiola PORT=10010 HOST="xxxxxxx.xxxxxxx.xxx" ;  (server name)
OPTION NOSYNTAXCHECK;
option DBIDIRECTEXEC;


PROC IMSTAT data=LASR.Cust_Compl /*noprint*/;
WHERE Company <> '';
RUN;
deleterows / purge;
RUN;

 

Later I add the new data with proc append.

greetings and good luck.

Ask a Question
Discussion stats
  • 8 replies
  • 1398 views
  • 11 likes
  • 4 in conversation