topic Re: Code or syntax Error in SAS Programming

Code or syntax Error

CathyVI — Mon, 25 Jul 2022 15:40:04 GMT

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;

Re: Code or syntax Error

Reeza — Mon, 25 Jul 2022 15:49:08 GMT

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;

Re: Code or syntax Error

Reeza — Mon, 25 Jul 2022 15:54:36 GMT

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;

Re: Code or syntax Error

CathyVI — Mon, 25 Jul 2022 15:57:14 GMT

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

Re: Code or syntax Error

ballardw — Mon, 25 Jul 2022 16:10:25 GMT

@CathyVI wrote:

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

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.