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;
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;
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;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.