Transcription of Imputing ISO8601 Dates From Character Variables Containing ...
{{id}} {{{paragraph}}}
Example: air traffic controller
Imputing ISO8601 Dates From Character Variables Containing ...
Paper FC06 Imputing ISO8601 Dates From Character Variables Containing partial Dates John R. Gerlach, MaxisIT Abstract Assume that there is an initiative to include legacy studies into a database such that the original data are converted into SDTM domains in compliance with CDISC standards. One aspect of this effort involves date Variables that must follow ISO8601 rules. This sub-task would be easy if the data were stored in SAS data sets and, specifically, the Dates were stored as SAS date Variables . Unfortunately, the plethora of data is stored mostly as raw text files. Moreover, Dates are stored as Character Variables in various formats ( , mmddyyyy, yyyymmdd). Even worse, the date Variables contain partial Dates and, perhaps, bogus values. This paper explains a SAS macro that imputes ISO8601 Dates from Character Variables Containing even partial Dates . Introduction The International Standard ISO 8601 specifies numeric representations of date and time. This standard is based on the Gregorian calendar (introduced in 1582) for Dates and the 24-hour clock for time.
Paper FC06 Imputing ISO8601 Dates From Character Variables Containing Partial Dates John R. Gerlach, MaxisIT Abstract Assume that there is an initiative to include legacy studies into a database such that the original data are converted
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
Introduction Date and Time, Dates and Times, Calendar of Meets divisions • up, Dates, Calendar of Meets—divisions • up, Language Reference: Dictionary, Fourth Edition, 2010: From Unfriendly Text File to SAS, 2010 From Unfriendly Text File to SAS, Models for Survival Analysis with Covariates, San Anton School, THE AXIS STATEMENT: YOUR ALLY FOR CONTROLLING, SAS with Style: Creating your, Style Template for RTF Output