Error: update access is not supported for file

jitinsethi07 — Thu, 16 Feb 2017 05:14:02 GMT

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>

Re: Error: update access is not supported for file

SASKiwi — Thu, 16 Feb 2017 07:08:14 GMT

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#p10dosb1fybvpzn1hw38gxuotopk.htm

Re: Error: update access is not supported for file

jitinsethi07 — Thu, 16 Feb 2017 08:32:04 GMT

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!

topic Re: Error: update access is not supported for file <extension.filename> in SAS Visual Analytics

Error: update access is not supported for file

Re: Error: update access is not supported for file

Re: Error: update access is not supported for file