Hi, I imported an SAS-xpt just to find that administrations are given in two columns (let’s call them D and T). D is a integer giving the days since Jan 1st, 1960 and T an integer giving the seconds since Jan 1st, 1960 midnight. D is redundant, but may serve in checking the conversion from T. Now I’m struggling to convert T into either an ISO-timestamp (desired format “YYYY-MM-DD hh:mm”) or a serial date/time. Example: T 1643629200 In Excel I could convert it to “2012-01-31 11:40” (serial: 40939.486111) by DATEVALUE(“1960-01-01”)+T/86400 – which is correct according to the CRF. Lost in translation.
You could work up a big transformation to complete this task. But I would recommend using a different tool to convert the file to a csv which can be imported into Phoenix for analysis. The tool is called StatTransfer and you can read more on my blog at StatTransfer - Nathan
Hi Nathan, [quote]You could work up a big transformation to complete this task.[/quote] In PHX I essentially gave up. Currently I employ R – which is fine, but requires specific code for every file to import. [quote]But I would recommend using a different tool […] tool called StatTransfer and you can read more on my blog at StatTransfer[/quote] Wow, that helps a lot! THX for posting. However, I think that it would be a good idea if Pharsight implements a working import-function for SAS-timestamps. Time is not an unusual variable in Pk. 