Hi everyone! I am currently trying to make a stored process with two csv files for output. I already know that the best way for doing this is to output a zip file with these two csv files (the stored process only outputs one file). That being said, I have the code below for doing so: %let hoje = %sysfunc(today(),date9.); %let _ODSDETS=TAGSETS.EXCELXP;
%let rc=%sysfunc(stpsrv_header('Content-type','application/vnd.zip')); /*define o tipo de arquivo (zip)*/
%let rc=%sysfunc(stpsrv_header('Content-disposition','attachment; filename=temp.csv'));
%let _ODSSTYLE=PEARL;
ods csv file = 'FILE1_&HOJE..csv' options(autofit_height = 'YES' FROZEN_HEADERS = 'YES');
PROC PRINT DATA=FILE1 noobs LABEL
style(HEADER)={color=black background=white font_weight=bold font_size=10pt font_face=CALIBRI width=1.8in just=c vjust=c}
style(DATA) = {background=white font_size=10pt font_face=CALIBRI};
format MyVAR $char.;
RUN;
ods csv close;
ods csv file = 'FILE2_&HOJE..csv' options(autofit_height = 'YES' FROZEN_HEADERS = 'YES');
PROC PRINT DATA=FILE2 noobs LABEL
style(HEADER)={color=black background=white
font_weight=bold font_size=10pt font_face=CALIBRI width=1.8in just=c vjust=c}
style(DATA) = {background=white font_size=10pt font_face=CALIBRI};
RUN;
ods csv close;
/*criando pasta zipada*/
ods package(newzip) open nopf;
ods package(newzip) add file='FILE1_&HOJE..csv' path=_webout;
ods package(newzip) add file='FILE2_&HOJE..csv';
ods package(newzip) publish archive
properties(
archive_name="Myfiles.zip"
archive_path=_webout
);
ods package(newzip) close; But the result is an empty file with unknown content type: Does anyone know how I can fix this? Reference: Export zip files using ods
... View more