topic Re: Conditiinal Formating in New SAS User

Conditiinal Formating

SASPhile — Tue, 16 Jul 2019 17:26:45 GMT

Need help if there is away to apply date format conditionally based on the values:

Var1

13886

13353

For example, var1 how would like to apply date9. format to first two obeseravtions and leave the remaining records as is. So var2 looks like below:

Var1 var2

13886 07JAN1998

13353 23JUL1996

. .

0 0

1 1

Re: Conditiinal Formating

Tom — Tue, 16 Jul 2019 17:33:45 GMT

Make your own custom format.

proc format;
value mydate ;
  0,1 = [1.]
  other=[date9.]
;
run;

proc print data=have;
   format var1 mydate9.;
run;

Hopefully your real dates don't include the first two days of 1960.

Re: Conditiinal Formating

SASPhile — Tue, 16 Jul 2019 18:44:22 GMT

mydate is not resolving to date9. format.But it gives a numeric value

Re: Conditiinal Formating

Tom — Tue, 16 Jul 2019 18:55:00 GMT

Works fine for me.

741   proc format;
742   value mydate 0,1=[1.] other=[date9.];
NOTE: Format MYDATE is already on the library WORK.FORMATS.
NOTE: Format MYDATE has been output.
743   run;

NOTE: PROCEDURE FORMAT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


744   data _null_;
745     do x=-1 to 2,today();
746       put x= comma7. +1 x=mydate9.;
747     end;
748   run;

x=-1  x=31DEC1959
x=0  x=0
x=1  x=1
x=2  x=03JAN1960
x=21,746  x=16JUL2019