topic conditional formating in SAS Procedures

conditional formating

Peter_Y — Tue, 18 Sep 2012 18:59:10 GMT

Hello all:

I know in SAS you can specify data format according to its value. I wonder if you can combine user-defined format with predefined format. i.e Can you code the following format

if value < 100 then

display '< $100';

else if value > 1000 then

display '>$1000';

else

display value with format = dollar6.2;

Thanks,

Peter

Re: conditional formating

Haikuo — Tue, 18 Sep 2012 19:24:10 GMT

Do a search on 'nested format', you will get lots of good examples, for a quickie, check out the following:

PROC FORMAT;

VALUE nested

low-100 = '<$100'

1000-high ='>$1000'

OTHER = [dollar10.2];

RUN;

data have;

input money @@;

format money nested.;

cards;

99 158 1234

;

proc print;run;

Haikuo