Regarding the file you asked me to attach - I can not attach files because of security issues, can I email it to you? And as for using an HTML output to create multiple worksheets - I tried that, the HTML files are created but the Excel file does not, here attached is the code I used and the log. Thank you very much for your help! /***my code***/ proc sort data=sashelp.class out=test; by age; run; ods tagsets.msoffice2k path="\\icc-tlv\root\dwh\BOXI\I_SHAARO\Auth_Statistics\status_zero_monthly" file="temp.html" newfile=output; proc print data=test; by age; run; ods tagsets.msofice2k close; ods tagsets.msoffice2k_x file="multiple.xls" style=statistical options( worksheet_source="11#\\icc-tlv\root\dwh\BOXI\I_SHAARO\Auth_Statistics\status_zero_monthly\temp.html, 12#\\icc-tlv\root\dwh\BOXI\I_SHAARO\Auth_Statistics\status_zero_monthly\temp1.html, 13#\\icc-tlv\root\dwh\BOXI\I_SHAARO\Auth_Statistics\status_zero_monthly\temp2.html, 14#\\icc-tlv\root\dwh\BOXI\I_SHAARO\Auth_Statistics\status_zero_monthly\temp3.html, 15#\\icc-tlv\root\dwh\BOXI\I_SHAARO\Auth_Statistics\status_zero_monthly\temp4.html, 16#\\icc-tlv\root\dwh\BOXI\I_SHAARO\Auth_Statistics\status_zero_monthly\temp5.html" ); data _null_; file print; put "test"; run; ods tagsets.msoffice2k_x close; /***log***/ 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROJECTPATH=''; 5 %LET _CLIENTPROJECTNAME=''; 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; 9 OPTIONS DEV=ACTIVEX; 10 GOPTIONS XPIXELS=0 YPIXELS=0; 11 FILENAME EGHTML TEMP; 12 ODS HTML(ID=EGHTML) FILE=EGHTML ENCODING='utf-8' STYLE=Analysis 12 ! STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/4.3/Styles/Analysis. 12 ! css") 12 ! ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/graph/v92/sasgraph.exe#version=9,2") 12 ! NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation; NOTE: Writing HTML(EGHTML) Body file: EGHTML 13 14 GOPTIONS ACCESSIBLE; 15 ods tagsets.msoffice2k_x file="multiple.xls" style=statistical 16 options( 16 ! worksheet_source="11#\\icc-tlv\root\dwh\BOXI\I_SHAARO\Auth_Statistics\status_zero_monthly\t 16 ! emp.html, 17 12#\\icc-tlv\root\dwh\BOXI\I_SHAARO\Auth_Statistics\status 17 ! _zero_monthly\temp1.html, 18 13#\\icc-tlv\root\dwh\BOXI\I_SHAARO\Auth_Statistics\status 18 ! _zero_monthly\temp2.html, 19 14#\\icc-tlv\root\dwh\BOXI\I_SHAARO\Auth_Statistics\status 19 ! _zero_monthly\temp3.html, 20 15#\\icc-tlv\root\dwh\BOXI\I_SHAARO\Auth_Statistics\status 20 ! _zero_monthly\temp4.html, WARNING: The quoted string currently being processed has become more than 512 characters long. You might have unbalanced quotation marks. 21 16#\\icc-tlv\root\dwh\BOXI\I_SHAARO\Auth_Statistics\status 21 ! _zero_monthly\temp5.html" 22 ); WARNING: Tagset TAGSETS.MSOFFICE2K_X not found; the default tagset will be used instead. NOTE: Writing TAGSETS.DEFAULT Body file: multiple.xls 23 24 data _null_; 25 file print; 26 put "test"; 27 run; NOTE: 1 lines were written to file PRINT. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.00 seconds 28 29 ods tagsets.msoffice2k_x close; 30 2 The SAS System 18:29 Monday, January 21, 2013 31 32 33 34 GOPTIONS NOACCESSIBLE; 35 %LET _CLIENTTASKLABEL=; 36 %LET _CLIENTPROJECTPATH=; 37 %LET _CLIENTPROJECTNAME=; 38 %LET _SASPROGRAMFILE=; 39 40 ;*';*";*/;quit;run; 41 ODS _ALL_ CLOSE; 42 43 44 QUIT; RUN; 45
... View more
