title 'Indian Currency Format';
libname orion'D:\Workshop\pg1';
Proc format;
Picture indianc
low-high='0,00,00,00,00,00,00,00,000';
run;
data new;
a=100; output;
a=1000; output;
a=10000; output;
a=100000; output;
a=1000000; output;
a=10000000; output;
a=100000000; output;
a=1000000000; output;
a=10000000000; output;
a=100000000000; output;
format a indianc.;
run;
proc print data=new;
run;
I'm trying this but it's showing that no obs found. How to fix this error. Kindly update. Thanks!
Have you seen the error message in the log?
This works:
proc format;
picture indianc
low-high='0,00,00,00,00,00,00,000';
run;
data NEW;
do EXP=1 to 15;
A=10**EXP;
output;
end;
format a indianc.;
run;
proc print data=NEW noobs;
var A;
run;
The maximum precision is 16 digits .
| A |
|---|
| 10 |
| 100 |
| 1,000 |
| 10,000 |
| 1,00,000 |
| 10,00,000 |
| 1,00,00,000 |
| 10,00,00,000 |
| 1,00,00,00,000 |
| 10,00,00,00,000 |
| 1,00,00,00,00,000 |
| 10,00,00,00,00,000 |
| 1,00,00,00,00,00,000 |
| 10,00,00,00,00,00,000 |
| 1,00,00,00,00,00,00,000 |
There's a very big reason why "Read the Log" is Maxim #2 on my list. 90% of newbie's problems can be solved by themselves by just following that.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.