topic Re: Convert exponent to real values in proc freq in SAS Programming

Convert exponent to real values in proc freq

CathyVI — Mon, 06 May 2019 20:37:32 GMT

Hi,

I ran a prof freq and I got my results but i am trying to remove the Exponent (E) from my result.

Example;

proc freq data = income;

table amount;

run;

Result ;

amount frequency Percent Cum_freq Cum_persent

0 42344E12 60.20 3454E54 100.00

1 44535E33 34.44 5675E44 60.00

Re: Convert exponent to real values in proc freq

Jagadishkatam — Mon, 06 May 2019 20:44:02 GMT

I am not sure if we could resolve it, alternatively we use the proc sql.

Re: Convert exponent to real values in proc freq

Reeza — Mon, 06 May 2019 21:49:40 GMT

Use PROC TABULATE instead. Modifying the PROC FREQ template is a pain.

Re: Convert exponent to real values in proc freq

ballardw — Mon, 06 May 2019 21:54:57 GMT

Send the result to a data set an specify a longer format in Proc Print to display the values.

proc freq data = income noprint;
   table amount/ outcum out=work.count;
run;

proc print data=work.count;
   format count cum_freq best32.;
run;

HOWEVER, none of the SAS numeric formats want to display 54+digit with 32 the limit. So you are still going to have some scientific notation. And 2 to the 53rd power (15 significant digits) is the largest integer that SAS has for precision of storage so you are exceeding that anyway.

Re: Convert exponent to real values in proc freq

Reeza — Mon, 06 May 2019 21:59:13 GMT

proc tabulate data=income;
class amount;

table amount*n=''*f=32.;

run;

Maybe this will work?

@CathyVI wrote:

Hi,

I ran a prof freq and I got my results but i am trying to remove the Exponent (E) from my result.

Example;

proc freq data = income;

table amount;

run;

Result ;

amount   frequency      Percent Cum_freq       Cum_persent

0          42344E12      60.20        3454E54             100.00

  1          44535E33       34.44       5675E44               60.00

Re: Convert exponent to real values in proc freq

CathyVI — Wed, 08 May 2019 20:32:18 GMT

So I tried this for a 2 x 2 table but didn't work

For example;

proc tabulate data=med;

class name;

table blank*name*n=''*f=32.;

run;

???

I am using proc freq to find 2x2 and 2x3 table so how will I use the proc tabulate without getting an exponent in my result ?

Re: Convert exponent to real values in proc freq

Reeza — Wed, 08 May 2019 20:51:09 GMT

What does didn't work mean? Can you generate some sample data we can use to test this? If not, please show an example of a 2x2 table and the numbers you're getting.

Re: Convert exponent to real values in proc freq

CathyVI — Wed, 08 May 2019 23:48:27 GMT

@Reeza, what i mean by didn't work is that i can't get percent, cum_percent & cum_freq by using proc tabulate and i wanted percent.

Re: Convert exponent to real values in proc freq

Tom — Thu, 09 May 2019 00:28:44 GMT

Note that your totals are too large for SAS to represent exactly. Maximum number of decimal digits is 15 .

The value 42344E12 would take more than 15 digits.

So why not just accept the scientific notation?

Or roll your own CUM variables.

proc freq data=sashelp.class ;
  tables sex / noprint out=counts;
run;
data counts;
  set counts;
  cum_count+count;
  cum_percent+percent;
  format count cum_count 32. percent cum_percent 6.2 ;
run;
proc print width=min;
run;

Re: Convert exponent to real values in proc freq

Reeza — Thu, 09 May 2019 14:49:02 GMT

@CathyVI wrote:
@Reeza, what i mean by didn't work is that i can't get percent, cum_percent & cum_freq by using proc tabulate and i wanted percent.

Your code doesn't request the percentages as outputs, you need to explicitly code for those in PROC TABULATE, they are not part of the default output.