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;
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.
then please check out this web page. The answes should be there
I never tested it sadly....so good to see your feedback.
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
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".
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.
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.