11-19-2015 07:21 AM
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;
where businessdate = today() - 3;
11-20-2015 12:30 AM
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.
11-20-2015 12:56 AM - edited 11-20-2015 01:00 AM
then please check out this web page. The answes should be there
I never tested it sadly....so good to see your feedback.
11-23-2015 10:34 AM
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
07-14-2017 10:49 AM
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".
07-14-2017 11:18 AM
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)
PROC IMSTAT data=LASR.Cust_Compl /*noprint*/;
WHERE Company <> '';
deleterows / purge;
Later I add the new data with proc append.
greetings and good luck.
12-07-2017 05:53 AM
This conversation is partially related to my issue too, kindly see:
1) I have a dataset A (having millions of records) in LASR library.
2) Importing B file with few hundred rows.
3) Need to compare A and B and delete common records from A (lasr library) without creating a temporary copy.
Using imstat statement--(not working)
proc imstat data=LASRLIB.A;
merge LASRLIB.A (in=a)
if a and b;
deleterows / purge;
(Note: Merge won't work with proc imstat, it is just to show what I exactly need.)
Is there any other way to do it?
Please let me know in case of any gaps.