topic Re: Reading Date/Time Fields Into SAS in SAS Procedures

Reading Date/Time Fields Into SAS

xtc283x — Tue, 14 Jul 2015 10:30:24 GMT

I have a pipe delimited file that contains several date/time fields with information like this: '2/8/2015 0:00:00' What is the datetime function that would read these fields in and allow me to use the daypart() or timepart() functions to break them out separately?

Thanks!

Re: Reading Date/Time Fields Into SAS

AskoLötjönen — Tue, 14 Jul 2015 10:57:05 GMT

Anydtdtm informat is quite clever :

data have;

attrib dtm format=datetime21. informat=anydtdtm21.;

input dtm ;

cards;

2/8/2015 0:00:00

;

run;

data want;

set have;

attrib datep format=date9.;

attrib timep format=time8.;

datep=datepart(dtm);

timep=timepart(dtm);

run;

Re: Reading Date/Time Fields Into SAS

xtc283x — Tue, 14 Jul 2015 12:16:20 GMT

Thanks, Asko. That works!

Re: Reading Date/Time Fields Into SAS

BrunoSilva — Tue, 14 Jul 2015 13:07:00 GMT

Hello,

This litle script will help you to find any informat in the future

%let STR_TO_FIND=%str(2/8/2015 0:00:00);

data find_informat;

length source $ 100;

format result datetime.;

set sashelp.vformat;

where fmttype eq "I";

source_str="&STR_TO_FIND.";

result=inputn(source_str,fmtname);

if result ne .;

keep source_str result fmtname;

run;

Best regards,

Re: Reading Date/Time Fields Into SAS

xtc283x — Tue, 14 Jul 2015 13:24:23 GMT

Thanks, Bruno!