topic Re: proc format in SAS Procedures

proc format

annapurna — Mon, 15 Dec 2014 07:13:44 GMT

There is a field containing a date. It needs to be displayed in the format “ddmonyy” if it’s before 1975, “dd mon ccyy” if it’s after 1985, and as ‘Disco Years’ if it’s between 1975 and 1985.

I have used the following code

data new ;

input date ddmmyy10. ;

cards;

01/05/1955

01/09/1970

01/12/1975

19/10/1979

25/10/1982

10/10/1988

27/12/1991

;

run;

proc format ;

value dat low-’01jan1975’d=ddmmyy10.

’01jan1975’d-’01JAN1985’d=”Disco Years”

’01JAN1985’d-high=date9.;

run;

proc print;

format date dat. ;

run;

but am not getting the expected result

can anyone help me.

Re: proc format

bharathtuppad — Mon, 15 Dec 2014 07:27:38 GMT

Proc format ;

Value test low-"31dec1974"d =[date7.]

"01jan1975"d - "31dec1985"d = "disco years"

"01jan1986"disco - high =[ddmmyy10.];

Run;

Use this format test.

Re: proc format

Reeza — Mon, 15 Dec 2014 07:34:34 GMT

Lsat one should be date9? And no disco in the range

Re: proc format

bharathtuppad — Mon, 15 Dec 2014 07:57:22 GMT

Yes, typo error, my mistake. It is d in the range not disco.

Re: proc format

RW9 — Mon, 15 Dec 2014 09:23:47 GMT

Personally I am not a fan of formats, so I would just do a case statement (or if) into a character field:

proc sql;

create table WANT as

select DATE,

case when DATE <= '01JAN1975'd then put(date,ddmmyy10.)

when '01JAN1975'd < DATE <= '01JAN1985'd then "Disco Years"

else put(DATE,date9.) end as PROCESSED_DATE

from HAVE;

quit;

Re: proc format

annapurna — Mon, 15 Dec 2014 09:44:27 GMT

thankyou guys for helping me

Re: proc format

annapurna — Mon, 15 Dec 2014 10:13:38 GMT

in response to Rw9,

that code was working good

but if i try the same approach in a data step with select when statement it s not working

why doesnt it work .

Re: proc format

RW9 — Mon, 15 Dec 2014 10:32:37 GMT

Perhaps pop your code in your post, then I could see. This should work:

data want;

set new;

length processed_date $200.;

select;

when (date <= '01JAN1975'd) processed_date=put(date,ddmmyy10.);

when ('01JAN1975'd < date < '01JAN1985'd) processed_date="Disco";

otherwise processed_date=put(date,date9.);

end;

run;

Re: proc format

annapurna — Mon, 15 Dec 2014 11:03:07 GMT

i wrote the code wrong

i mentioned the variable name in select statement as well

rest all i hav written the same

thankyou so much Rw9