topic importing different date types in SAS Programming

importing different date types

sg_kr — Wed, 05 Sep 2018 11:03:24 GMT

Hi ,

i have a file with date variable of different date types like date9. ,date10. & mmddyy10.

i want to import all together into one dataset with one format and informat.

can i use anydtdte here, does it work?

Re: importing different date types

RW9 — Wed, 05 Sep 2018 11:14:54 GMT

Try it, its what it is for, though you might be better off importing as text and applying your own set of imputation rules (i.e. we have dates as ISO - text, and numeric, and date and time in separate variables, hence we have original , parts, and imputed).

Re: importing different date types

Reeza — Wed, 05 Sep 2018 15:00:43 GMT

If you have mmddyy and ddmmyy it's likely to get it wrong. Hopefully you don't

Are those date types all in the same column in the same file?
If so, anydtdte is likely your best choice, but it may not be 100% accurate. Is that ok for what you're doing?

@sg_kr wrote:

Hi ,

i have a file with date variable of different date types like date9. ,date10. & mmddyy10.

i want to import all together into one dataset with one format and informat.

can i use anydtdte here, does it work?