Issue in Proc export sheet name

[Aayushi_17]

Hi ,

In proc export for excel I have given sheet name as

sheet='Value Level Terminology';

But am getting the output in excel sheet as

'Value_Level_Terminology';

I dont want this '_ ' between the sheet names.Does anyone know how to get the output as 'variable mapping'. thanks in advance.

[SASKiwi]

Try adding this OPTIONS statement before your export code:

options validvarname = any validmemname = extend;

[Aayushi_17]

I tired this but still getting the same output

[andreas_lds]

Please post the code used to export the file. Which SAS version are you using?

[Aayushi_17]

am using 9.4 version.

proc export data=d_outi.variable
outfile='C\newfolder\pricesheet.xls'
label dbms=xls replace;
sheet='variable label';
run;

this is the code i used to export the excel file

[andreas_lds · Accepted solution]

---

@Aayushi_17 wrote:

am using 9.4 version.

proc export data=d_outi.variable
outfile='C\newfolder\pricesheet.xls'
label dbms=xls replace;
sheet='variable label';
run;

this is the code i used to export the excel file

---

The options mentioned by @SASKiwi  don't solve the issue seems to be a feature when creating files in the outdated excel-format xls. Can you change to xlsx?

proc export data=sashelp.class
      outfile="PATH\class.xlsx"
      label dbms=xlsx replace;
   sheet='variable label';
run;

[Aayushi_17]

Thanks this one worked

[Satish_Parida]

The only difference between the codes are dbms=xls(old) and dbms=xlsx. How this fixed this issue?
Asking this to get a clear clarification.

[andreas_lds]

---

@Satish_Parida wrote:
The only difference between the codes are dbms=xls(old) and dbms=xlsx. How this fixed this issue?
Asking this to get a clear clarification.

---

Could be a bug/feature in proc export. Afaik xls supports blanks in sheet-names. You will need to contact tech-support for more information.