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

Error: update access is not supported for file <extension.filename>

Reply
Occasional Contributor
Posts: 6

Error: update access is not supported for file <extension.filename>

I am creating a blank dataset 'empty' and then trying to append data to it from dataset lasrlib.rebates_data:


options mlogic mprint symbolgen;
%vdb_dt(LASRLIB.empty);
data lasrlib.empty;

Informat Retailer $3.;
Informat CODE $16.;
Informat NAME $66.;
Informat DESCRIPTION $20.;
Informat COLOURS $10.;
Informat UNIT_OF_MEASURE_UOM nlnum12.;
Informat USD_GROSS_PRICE_New nlnum12.;
Informat USD_REBATE_PRICE_New nlnum12.;
Informat USD_NET_PRICE_New nlnum12.;
Informat USD_REBATE_PRICE_REUSE nlnum12.;
Informat USD_PRICE_Reuse nlnum12.;
Informat AUD_GROSS_PRICE_New nlnum12.;
Informat AUD_REBATE_PRICE_New nlnum12.;
Informat AUD_NET_PRICE_New nlnum12.;
Informat AUD_REBATE_PRICE_REUSE nlnum12.;
Informat AUD_PRICE_Reuse nlnum12.;
Format Retailer $3.;
Format CODE $16.;
Format NAME $66.;
Format DESCRIPTION $20.;
Format COLOURS $10.;
Format UNIT_OF_MEASURE_UOM nlnum12.;
Format USD_GROSS_PRICE_New nlnum12.;
Format USD_REBATE_PRICE_New nlnum12.;
Format USD_NET_PRICE_New nlnum12.;
Format USD_REBATE_PRICE_REUSE nlnum12.;
Format USD_PRICE_Reuse nlnum12.;
Format AUD_GROSS_PRICE_New nlnum12.;
Format AUD_REBATE_PRICE_New nlnum12.;
Format AUD_NET_PRICE_New nlnum12.;
Format AUD_REBATE_PRICE_REUSE nlnum12.;
Format AUD_PRICE_Reuse nlnum12.;
;
run;

proc append base=lasrlib.empty data=lasrlib.Rebates_data

 

Continuously getting error: update access is not supported for file <extension.filename>

Respected Advisor
Posts: 3,063

Re: Error: update access is not supported for file <extension.filename>

My understanding is you need to use PROC IMSTAT to do in-memory LASR table appends:

 

http://support.sas.com/documentation/cdl/en/inmsref/70021/HTML/default/viewer.htm#p10dosb1fybvpzn1hw...

 

 

Occasional Contributor
Posts: 6

Re: Error: update access is not supported for file <extension.filename>

SA SKiwi, you are absolutely correct, and I had to use proc imstat. This issue that I am experiencing is while working with SAS Visual Analytics, I remember I have used proc append in the similar manner several times in SAS Enterprise Guide and it worked perfectly fine. not sure whats wrong in here. Thank you!

Ask a Question
Discussion stats
  • 2 replies
  • 245 views
  • 2 likes
  • 2 in conversation