How to transform string value into timestamp data format?

Hansmuffs — Mon, 21 Feb 2022 16:38:17 GMT

Hi,

how to transform this string value into a timestamp format like dd.mm.yyyy hh:mm?

17.02.22  08:06

This is not working:

format BEGINN_TMP DATETIME19.;
BEGINN_TMP = input(BEGINN, DATETIME19.);

Re: How to transform string value into timestamp data format?

FreelanceReinh — Mon, 21 Feb 2022 19:25:33 GMT

Hi @Hansmuffs,

With the usual German locale

options locale=DE_DE;

this works:

data have;
string='17.02.22  08:06';
run;

data want;
set have;
dt=input(string, nldatm.);
format dt nldatms14.;
run;

except for the year 2000 (!). So, better use 4-digit years, as we've learned end of last century.

Documentation of the surprising Y2K issue of the NLDATMw. informat :

data _null_;
input dt nldatm.;
put dt nldatms14.;
cards;
17.02.98 08:06
17.02.99 08:06
17.02.00 08:06
17.02.01 08:06
17.02.02 08:06
;

Log (Windows SAS 9.4M5 with locale DE_DE and YEARCUTOFF=1926):

753   data _null_;
754   input dt nldatm.;
755   put dt nldatms14.;
756   cards;

17.02.98 08:06
17.02.99 08:06
NOTE: Invalid data for dt in line 759 1-19.
             .
RULE:       ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
759         17.02.00 08:06
dt=. _ERROR_=1 _N_=3
17.02.01 08:06
17.02.02 08:06
NOTE: DATA statement used (Total process time):

topic How to transform string value into timestamp data format? in SAS Programming

How to transform string value into timestamp data format?

Re: How to transform string value into timestamp data format?