Code or syntax Error

[CathyVI]

Hello,

Who can explain why an getting this error message and how to rectify it. Thanks

My code:

FILENAME REFFILE '/BUBD/BUBD_2021/MXM.xlsx';

PROC IMPORT DATAFILE=REFFILE
DBMS=XLSX
OUT=WORK.IMPORT REPLACE;
GETNAMES=YES;
RUN;

libname outdata "/_PTSU/FS_SAAH/PUD/Data/SASDS/MPOS_2021" Access = readonly;
run;

data outdata.MPOS_2021_alldata;
set work.import;
run;

CathyVI_0-1658763205857.png

[Reeza]

libname outdata "/_PTSU/FS_SAAH/PUD/Data/SASDS/MPOS_2021" Access = readonly;

Read only access is exactly that, read only. You cannot write to the library with this setting, remove it if you want to write to the library.

---

@CathyVI wrote:

Hello,

Who can explain why an getting this error message and how to rectify it. Thanks

My code:

FILENAME REFFILE '/BUBD/BUBD_2021/MXM.xlsx';

PROC IMPORT DATAFILE=REFFILE
DBMS=XLSX
OUT=WORK.IMPORT REPLACE;
GETNAMES=YES;
RUN;

libname outdata "/_PTSU/FS_SAAH/PUD/Data/SASDS/MPOS_2021" Access = readonly;
run;

data outdata.MPOS_2021_alldata;
set work.import;
run;

CathyVI_0-1658763205857.png

---

[CathyVI]

@Reeza I removed the "Access=readonly" but I still have the issue.

CathyVI_0-1658764579109.png

[ballardw]

---

@CathyVI wrote:

@Reeza I removed the "Access=readonly" but I still have the issue.

CathyVI_0-1658764579109.png

---

Means that another permission system, such as your user ID, does not allow that which might be a SAS session setting, a setting for the particular file in that folder or that entire folder.

[Reeza · Accepted solution]

FYI this would be code that is more optimally structured/named:

libname outdata "/_PTSU/FS_SAAH/PUD/Data/SASDS/MPOS_2021";

FILENAME MPOS '/BUBD/BUBD_2021/MXM.xlsx';

PROC IMPORT DATAFILE=MPOS
DBMS=XLSX
OUT=outdata.MPOS_2021_alldata REPLACE;
GETNAMES=YES;
RUN;