How to simplify date&time

Crubal — Thu, 09 Jul 2015 23:03:28 GMT

Hi,

I have a question about SAS basic procedure, how to convert time like "2014-03-17 16:58:39.512986+0000" to a time only with day(month), hour and minute. Like "03-17 16:58"

Thanks so much!

Re: How to simplify date&time

Ksharp — Fri, 10 Jul 2015 13:04:16 GMT

HoHo. You are luck you have SAS.

Code: Program

proc format;
picture fmt
 other='%0m-%0d %0H:%0M'(datatype=datetime);
run;
data x;
a="2014-03-17 16:58:39.512986+0000";
b=input(scan(a,1,'.'),anydtdtm24.);
format b fmt12.;
run;
proc print;run;

Log: Program

Notes (7)

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

54 proc format;

55 picture fmt

56 other='%0m-%0d %0H:%0M'(datatype=datetime);

NOTE: Format FMT is already on the library WORK.FORMATS.

NOTE: Format FMT has been output.

57 run;

NOTE: PROCEDURE FORMAT used (Total process time):

real time 0.02 seconds

cpu time 0.01 seconds

58 data x;

59 a="2014-03-17 16:58:39.512986+0000";

60 b=input(scan(a,1,'.'),anydtdtm24.);

61 format b fmt12.;

62 run;

NOTE: The data set WORK.X has 1 observations and 2 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

63 proc print;run;

NOTE: There were 1 observations read from the data set WORK.X.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.03 seconds

cpu time 0.02 seconds

65 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Results: Program

1	2014-03-17 16:58:39.512986+0000	03-17 16:58

Re: How to simplify date&time

RW9 — Fri, 10 Jul 2015 13:38:25 GMT

Hi,

If its just character you want (and should still sort correctly:

new_var=substr(dt,6,11);

topic How to simplify date&time in SAS Procedures

How to simplify date&time

Re: How to simplify date&time

Code: Program

Log: Program

Results: Program

Re: How to simplify date&time