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

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

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