SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Decode EXEC.EX_DATE column in DataFlux repository

Reply
Occasional Contributor
Posts: 9

Decode EXEC.EX_DATE column in DataFlux repository

Does anybody have a query to decode the EXEC.EX_DATE column in the DataFlux repository?  It kinda looks like a Unix date integer, but it is in decimal format so I am not sure how to decode it.

Thanks,

Brett

Occasional Contributor
Posts: 8

Re: Decode EXEC.EX_DATE column in DataFlux repository

took me half a day to find out, but here is the result:

attrib new_date format=datetime20.;

new_date = intnx('dtyear',ex_date*3600*24,-60,'S');

Ask a Question
Discussion stats
  • 1 reply
  • 317 views
  • 3 likes
  • 2 in conversation