The SAS Output Delivery System and reporting techniques

Ods tagsets .xml to produce date as numeric

Reply
Super Contributor
Posts: 434

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;

fname1=scan(filename,-1,'/');

processid1=compress(Processid,,'kad');

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

else userid1=userid;

Date_TimeStamp1=input(Date_TimeStamp,E8601DT24.3);

Date=input(Date_TimeStamp,E8601DT24.3);

/*Date=input(Date_TimeStamp,date9.);*/

format Date_TimeStamp1 datetime21.2;

format date e8601dn.;

drop processid userid filename Date_TimeStamp;

run;

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

run;

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

  title;

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;

run;

ods tagsets.excelxp close;

ods listing;

ods listing close;

Super User
Posts: 11,144

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,177

Re: Ods tagsets .xml to produce date as numeric

Which version of the tagset is reported in the saslog?

Ask a Question
Discussion stats
  • 2 replies
  • 286 views
  • 0 likes
  • 3 in conversation