Prev: Size of Dataset
Next: Update One Table from Another Table Using SQL
From: Ya Huang on 23 Nov 2009 13:07
Hi there,

When options missing is set to blank, a missing datatime value
converted by put and datetime. format will generate a blank string,
but not the case for e8601dt. format, which generate a '.'. This is at
least an inconsitency. I would even call it a bug, since ISO8601 need a
blank string instead of a '.':

1 options missing=' ';
2 data _null_;
3 dt=today();
4 iso=put(dt,e8601dt.);
5 put iso=;
6 dt=.;
7 iso=put(dt,e8601dt.);
8 put iso=;
9 dtm=put(dt,datetime.);
10 put dtm=;
11 run;

iso=1960-01-01T05:03:44
iso=.
dtm=

Ya
 | 
Pages: 1
Prev: Size of Dataset
Next: Update One Table from Another Table Using SQL