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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 851 views
  • 0 likes
  • 2 in conversation