topic Re: 88/88/8888 mmddyy10. format in SAS Programming

88/88/8888 mmddyy10. format

sophia_SAS — Fri, 25 Jan 2013 14:52:25 GMT

For the SAS date format mmddyy10., the date January 25, 2013 would be written as "25Jan2013"d.

Applying this format, how would 88/88/8888 be written? If this format cannot be used, what other format is advised in order for SAS to recognize 88/88/8888 as a valid date?

Thanks!

Re: 88/88/8888 mmddyy10. format

AncaTilea — Fri, 25 Jan 2013 15:04:22 GMT

88/88/8888 is not a valid date...

Could you provide more context?

Re: 88/88/8888 mmddyy10. format

DBailey — Fri, 25 Jan 2013 15:51:50 GMT

Also, I believe the mmddyy10. format looks like 01/25/2013 without the quotes and the d.

Re: 88/88/8888 mmddyy10. format

ballardw — Fri, 25 Jan 2013 18:32:54 GMT

What date system are you using that has 88 as either month or day of month (or equivalent)? The NLS system option LOCALE controls the defaults of how dates may be structured and may have some bearing but more details would help.

Re: 88/88/8888 mmddyy10. format

Tom — Fri, 25 Jan 2013 23:01:29 GMT

For SAS to recognize strings like 'xx/xx/xxxx' as dates you would need an INFORMAT, not a FORMAT.

You would use MMDDYY10. if the first part is the month and DDMMYY10. if the first part is the day.

data test;

str='01/01/1960';

dt = input(str,mmddyy10.);

format dt date9.;

put (_all_) (=);

run;

str=01/01/1960 dt=01JAN1960

Re: 88/88/8888 mmddyy10. format

Peter_C — Sat, 26 Jan 2013 12:47:29 GMT

sophia_SAS wrote:

For the SAS date format mmddyy10., the date January 25, 2013 would be written as "25Jan2013"d.

Applying this format, how would 88/88/8888 be written? If this format cannot be used, what other format is advised in order for SAS to recognize 88/88/8888 as a valid date?

Thanks!

SAS won't recognise 88/88/8888 as a date, but you can make it appear so.

It uses a facility I call "embedded formats".

A special value would be stored for the 88 date, and a special informat and format would read it and re-present it with what-ever layout you want.

Here is the construction of the special formats - I'll call them informat and format d88d.

proc format ;

invalue d88d

'88/88/8888' = 8e8 /* special non-date value */

other = [mmddyy14.]

;

* here is a special format to write the 88 dates among normal dates ;

value d88d

8e8 = '88/88/8888'

other = [mmddyy10.]

;

run ;

%put %sysfunc( today(), d88d ) ;

%put %sysfunc( inputn( %str(88/88/8888), d88d ), d8d) ;

%put %sysfunc( inputn( %str(26/01/2013), d88d ), d8d) ;

Re: 88/88/8888 mmddyy10. format

Florent — Mon, 28 Jan 2013 17:09:25 GMT

Hi,

Here is an example with three different date formats adding a slash as separator in between the year, month and day values (this is achived by the 's' after the date format. It may also be a blank, colon, dash, period or no separator):

data want;

date='25JAN2013'd;

date1 = put(date, ddmmyys10.);

date2 = put(date, mmddyys10.);

date2 = put(date, yymmdds10.);

run;

Regards,

Florent