BookmarkSubscribeRSS Feed
Peter_Y
Calcite | Level 5

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

1 REPLY 1
Haikuo
Onyx | Level 15

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

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 928 views
  • 0 likes
  • 2 in conversation