SAS Format

[keds]

Hi All ,

i was just wondering if we have a sas format for "19 Aug , Mon". i have a date which needs to be converted to this format , do we have a inbuilt sas format which can give me this ? or any other way ?

Thanks

Keds

[stat_sas]

Try this.

data have;

dt='01JUN2014'd;

format dt WEEKDATE.;

run;

proc print;

run;

[Reeza · Accepted solution]

If that's exactly your format then no, you'll need to "roll your own".

proc format;

    picture date_custom_fmt (Default=45)

        low - high = '%d %b, %a'

    (datatype = date);

run;

data have;

dt='01JUN2014'd;

format dt date_custom_fmt.;

run;

See pages 14+:

http://www2.sas.com/proceedings/sugi31/243-31.pdf

[keds]

stat@sas this is coming as Friday ,  1 Jun , 2014. wanted very specific like "19 Aug , Mon".

Thanks Reeza , this worked out as i wanted.