Help using Base SAS procedures

conditional formating

Reply
Contributor
Posts: 25

conditional formating

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

Respected Advisor
Posts: 3,156

Re: conditional formating

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

Ask a Question
Discussion stats
  • 1 reply
  • 139 views
  • 0 likes
  • 2 in conversation