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

Greg_Azevedo_KP — Mon, 14 Jun 2021 15:35:55 GMT

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';

#-#-

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

Norman21 — Sat, 19 Jun 2021 13:40:13 GMT

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)?