topic Decode EXEC.EX_DATE column in DataFlux repository in SAS Data Management

Decode EXEC.EX_DATE column in DataFlux repository

bmedalen — Fri, 27 Dec 2013 15:28:25 GMT

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

Re: Decode EXEC.EX_DATE column in DataFlux repository

sdoorneveld — Wed, 12 Mar 2014 16:50:13 GMT

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