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