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
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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Latest Updates
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.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!