BookmarkSubscribeRSS Feed
Rahul_SAS
Quartz | Level 8

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

9 REPLIES 9
PeterWijers
Lapis Lazuli | Level 10
Rahul, why not just reload the data in the data query builder using the exception as a filter.
Peter
Rahul_SAS
Quartz | Level 8

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

PeterWijers
Lapis Lazuli | Level 10

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 

Rahul_SAS
Quartz | Level 8

Hi Peter,

 

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

 

Regards

Rahul

PeterWijers
Lapis Lazuli | Level 10
No Problem, that is all I can contribute for now.
Maybe check with your local SAS support.
Greetings and good luck.
TriciaAanderud
Lapis Lazuli | Level 10

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

Twitter: @taanderud - Follow me!

jakubniescior
Fluorite | Level 6

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".

PeterWijers
Lapis Lazuli | Level 10

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.

jitinsethi07
Obsidian | Level 7

Hi,

 

This conversation is partially related to my issue too, kindly see:

 

https://communities.sas.com/t5/SAS-Visual-Analytics/Deleting-LASR-records-using-proc-imstat-with-Mer...

 

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.

 

Solution:

Using imstat statement--(not working)

 

proc imstat data=LASRLIB.A;
merge LASRLIB.A (in=a)
                  B    (in=b);
if a and b;        

run;
deleterows / purge; 
run;

 

(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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 9 replies
  • 3721 views
  • 11 likes
  • 5 in conversation