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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.