proc template; define tagset tagsets.sylk; indent = 0; map='"'; mapsub='/""/'; define event doc; start: put 'Content-type: application/vnd.ms-excel' nl; put 'Content-disposition: attachment;filename=rfpcount.sylk' nl nl; /* put 'Content-disposition: attachment;inline' nl nl; */ put 'ID;PSAS8' nl; put 'P;F' nl; put 'P;F;SB' nl; finish: put 'E' nl; end; define event put_value; put value; end; define event colspecs; start: put 'F;W1 ' colcount ' 20' nl; end; define event header; start: put 'F;SDM1;Y' row ';X' colstart nl; put 'C;Y' row ';X' colstart; put ';K"'; put value; finish: put '"'; put nl; end; define event data; start: /* Header section (column headers are bold) */ put 'F;SDM1;Y' row ';X' colstart nl / cmp(section, "head"); /* Always */ put 'C;Y' row ';X' colstart; put ';K"'; put value; finish: put '"'; put nl; end; end; run;