PRXCHANGE or RXCHANGE for String Dates

[sbb]

Hey Fellow SAS_Forum_Campers,

Is this a SAS forum or a Perl forum?

After converting a character-string to a SAS DATETIME variable (seconds since 1/1/1960), you can use the SAS DATETIME format or you can extract the time-portion using the SAS CALL function TIMEPART. See below.

Scott Barry
SBBWorks, Inc.



22 data _null_;
23 dt = input('1/31/2009',mmddyy10.);
24 dttm = dhms(dt,9,9,9.222);
25 tm = timepart(dttm);
26 put dt= date9. dttm= datetime7. dttm=datetime9. tm= time12.3;
27 run;

dt=31JAN2009 dttm=31JAN09 dttm=31JAN2009 tm=9:09:09.222
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 second

Suggested Google advanced search arguments, this topic / post:

using sas dates site:sas.com

datetime date introduction site:sas.com

[Pdogra]

Thanks Sbb.

Well I could also do a substr to carry out the tasks but I am trying to utilise the power of regular expressions and that's very reason why SAS has included that.

Thanks,

PD

[sbb]

Okay, so after you have corrected the format, then what? How will you know that the date, for example, 02/29/2010, is or is not valid? Then, what will you do with the string, if sorting "by chronological date" is needed? This is my point.

Scott Barry
SBBWorks, Inc.


13 data _null_;
14 dt = input('02/29/2010',mmddyy10.);
15 put dt= date.;
16 run;

NOTE: Invalid argument to function INPUT at line 14 column 6.
dt=.
dt=. _ERROR_=1 _N_=1
NOTE: Mathematical operations could not be performed at the following places. The results of
the operations have been set to missing values.
Each place is given by: (Number of times) at (Line):(Column).
1 at 14:6
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

[Pdogra]

My apologies. Don't mean to make this complex. How about if you have datetime. (I am using SAS 9.1.3)


data have;
input have_date $18.;
format date date9.;
date=input(have_date,datetime16.);
cards;
7/1/2010:12:57
06/5/2009:10:57
04/05/2010:9:48
5/06/2010:6:48
;

or

data have;
input have_date $18.;
format date date9.;
date=input(have_date,datetime16.);
cards;
7/1/2010 12:57
06/5/2009 10:57
04/05/2010 9:48
5/06/2010 6:48
;

Datetime is not being read properly
Result (from first prog)


Obs have_date date

1 7/1/2010:12:57 .
2 06/5/2009:10:57 .
3 04/05/2010:9:48 .
4 5/06/2010:6:48 .


According to SAS : The datetime values must be in the following form: ddmmmyy or ddmmmyyyy, followed by a blank or special character, followed by hh:mm:ss.ss (the time). In the date

Message was edited by: Pdogra Message was edited by: Pdogra