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
April 27 - 30 | GAYLORD TEXAN
Register now to lock in early bird pricing through February 25!
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!