topic Re: ERROR NOTE: No observations in data set WORK.NEW. in SAS Programming

ERROR NOTE: No observations in data set WORK.NEW.

nitya411 — Mon, 05 Feb 2018 06:22:51 GMT

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!

Re: ERROR NOTE: No observations in data set WORK.NEW.

ChrisNZ — Mon, 05 Feb 2018 07:14:50 GMT

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

Re: ERROR NOTE: No observations in data set WORK.NEW.

nitya411 — Mon, 05 Feb 2018 06:47:32 GMT

Oh yes! just saw that! thankyou so much

Re: ERROR NOTE: No observations in data set WORK.NEW.

Kurt_Bremser — Mon, 05 Feb 2018 09:33:10 GMT

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.