topic Re: SAS Format in SAS Procedures

SAS Format

keds — Fri, 27 Jun 2014 17:06:41 GMT

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

Re: SAS Format

stat_sas — Fri, 27 Jun 2014 17:22:15 GMT

Try this.

data have;

dt='01JUN2014'd;

format dt WEEKDATE.;

run;

proc print;

run;

Re: SAS Format

Reeza — Fri, 27 Jun 2014 17:31:27 GMT

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

Re: SAS Format

keds — Sat, 28 Jun 2014 02:03:09 GMT

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.