BookmarkSubscribeRSS Feed
art297
Opal | Level 21
Running the following code with SAS 9.1.3 m3 on a 4 processor Windows 2003 server:

data _null_;
dt="28SEP10:16:44:00.672"dt;
format dt 15.3;
put dt datetime19.2;
put dt datetime21.4;
put dt datetime22.5;
put dt datetime23.6;
put dt datetime24.7;
put dt datetime28.5;
run;

I get the following results:

28SEP10:16:44:00.67
28SEP10:16:44:00.6720
29SEP10:00:00:00.00000
29SEP10:00:00:00.000000
28SEP10:16:44:00.6719999
29SEP2010:00:00:00.00000

The code appears to work perfectly on SAS 9.1.2. Can anyone explain to me why it doesn't work on 9.1.3?

Art
2 REPLIES 2
Tim_SAS
Barite | Level 11
I don't see the problem on my PC. It might be a good idea to call Tech. Support for this one.

[pre]
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
Licensed to SAS Institute Inc., Site 0000000001.
NOTE: This session is executing on the XP_PRO platform.



NOTE: SAS 9.1.3 Service Pack 3

NOTE: SAS initialization used:
real time 6.85 seconds
cpu time 1.18 seconds

1 data _null_;
2 dt="28SEP10:16:44:00.672"dt;
3 format dt 15.3;
4 put dt datetime19.2;
5 put dt datetime21.4;
6 put dt datetime22.5;
7 put dt datetime23.6;
8 put dt datetime24.7;
9 put dt datetime28.5;
10 run;

28SEP10:16:44:00.67
28SEP10:16:44:00.6720
28SEP10:16:44:00.67200
28SEP10:16:44:00.672000
28SEP10:16:44:00.6719999
28SEP2010:16:44:00.67200
NOTE: DATA statement used (Total process time):
real time 0.77 seconds
cpu time 0.14 seconds
[/pre]
art297
Opal | Level 21
I received an answer from SAS-L. It was a bug that was addressed in a hot fix:

http://support.sas.com/kb/15/924.html

hotfix E9BB78 .

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1076 views
  • 0 likes
  • 2 in conversation