ods tagsets.DEFAULT

[HannaZhang]

Hi,all

  I have a dataset(PC3_sort) wihout observation，there are many variables with Chinese label in this dataset,

I want to export this datasets in XML format  like this

I had trying with the fllowing code，but it is a Blank Excel；Please help me out. Thank you.

ods listing close;
title "Custom Excel Output";
ods tagsets.DEFAULT file="F:\offline listing\Documents\listing\LIS55_10周期以后PK采集给药周期的核查.xml";
proc print data=PC3_sort  label;
   var  _all_;
run;

[ChrisNZ]

I can't use Chinese characters in my code as my server is configured in latin1, but this works fine for me:

ods escapechar='^'; 
ods tagsets.default file="%sysfunc(pathname(WORK))\ods_default.xml";
ods tagsets.excelxp file="%sysfunc(pathname(WORK))\ods_excelxp.xls";
proc print data=sashelp.class  label;
  label age="^{unicode 4F02}";
run;
ods listing close;

[HannaZhang]

I choose YES ，then opened this excel，it is empty.

I don't know where the problem is.

[ChrisNZ]

what does the file look like in a text editor?

[HannaZhang]

text editor?

[ChrisNZ]

A text editor like notepad.

Have at least one observation in your table. Populate the variables with spaces if needed.