The SAS Output Delivery System and reporting techniques

Ods tagsets .xml to produce date as numeric

Super Contributor
Posts: 396

Ods tagsets .xml to produce date as numeric

I've a code like below. When I run this code, I get date field as string in .xml. However I need as numeric in .xml. Kindly someone give insights to achieve dateric this task. I use SAS 9.3.

data log_table;

retain fname1 Date_TimeStamp1 Date  Status processid1 userid1 Details;

set log_analysis;



if userid = : ':' then userid1=substr(userid,2);

else userid1=userid;




format Date_TimeStamp1 datetime21.2;

format date e8601dn.;

drop processid userid filename Date_TimeStamp;


proc export data=log_table outfile='/usr/sas/tir/work/log_table.csv' dbms=csv replace;


ODS tagsets.excelxp file='/usr/sas/tir/work/log_table.xml' style=statistical

  options(autofilter='ALL'  sheet_name='log_analysis'  sheet_interval='none' embedded_titles='Yes');


title1 'Log Analysis Report';

proc Report data=log_table box nowd missing out=work.log_table_final

  style(header) = {background=white foreground=black FONT_WEIGHT = bold bordertopcolor=black borderleftcolor=white

  borderrightcolor=white borderbottomcolor=black};

  columns fname1 Date_TimeStamp1 date  Status processid1 userid1 Details;

  define fname1/style(header)=[background=lightgreen] width =45  display;

  define Date_TimeStamp1/"Date Timestamp1" style(header)=[background=lightgreen] width =16  display;

  define Date/style(header)=[background=lightgreen] width=16 display;

  define Status/ style(header)=[background=lightgreen]  width =5 display;

  define processid1/ style(header)=[background=lightgreen] width =10  display;

  define userid1/ style(header)=[background=lightgreen] width =20  display;

  define Details/style(header)=[background=lightgreen] width =60  display;


ods tagsets.excelxp close;

ods listing;

ods listing close;

Grand Advisor
Posts: 9,748

Re: Ods tagsets .xml to produce date as numeric

What is that numeric value going to represent?

The numeric value SAS uses for a datetime variable is the number of seconds since Midnight 1/1/1960.

Please provide an example of what that number should look like.

Valued Guide
Posts: 2,152

Re: Ods tagsets .xml to produce date as numeric

Which version of the tagset is reported in the saslog?

Post a Question
Discussion Stats
  • 2 replies
  • 3 in conversation