topic Re: ods tagsets.DEFAULT in SAS Programming

ods tagsets.DEFAULT

HannaZhang — Wed, 29 May 2019 09:38:40 GMT

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;

Re: ods tagsets.DEFAULT

ChrisNZ — Thu, 30 May 2019 01:43:54 GMT

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;

Re: ods tagsets.DEFAULT

HannaZhang — Thu, 30 May 2019 01:29:55 GMT

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

I don't know where the problem is.

Re: ods tagsets.DEFAULT

ChrisNZ — Thu, 30 May 2019 01:44:35 GMT

what does the file look like in a text editor?

Re: ods tagsets.DEFAULT

HannaZhang — Thu, 30 May 2019 01:50:35 GMT

text editor?

Re: ods tagsets.DEFAULT

ChrisNZ — Thu, 30 May 2019 22:32:22 GMT

A text editor like notepad.

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