PROC EXPORT * MS-Excel \ SHEET TAB NAME "&&" - Wanted: ICD9 & HCC

[Greg_Azevedo_KP]

I’m new to using SAS a little --- doing a fairly simple data base export to MS-Excel.

It works but am unable to get the MS-Excel Tab Name as needed.

MS-Excel Tab Name --- SAS PROC EXPORT \ SHEET Definition

MS-Excel Tab Name – Wanted: ICD9 & HCC

I’ve tried and it seems to fails to execute.   Is there a way ?    Using SHEET to set the Tab Name.

#-#-#-#-#-#-#-#-#-#-#-#-#

PROC EXPORT DATA=RPTTBL_EDG01                                      

            OUTFILE="\\xxxxx\EDG.YYYY.MM.DD.xlsx"

            DBMS=EXCELCS REPLACE;                                                    

            SHEET='ICD9 ^ HCC';                        

#-#-

[Norman21 · Accepted solution]

The following works for me in SAS EG:

proc export data=sashelp.cars
    outfile="C:\My SAS\_examples_/cars.xlsx"
    dbms=xlsx
    replace;
    sheet="ICD9 & HCC";
run;

Can you try the above (with a different folder for the outfile)?