How to show the full length of a numeric value created by proc freq

[France]

dear all,

how can I show the full length of a numeric value created by proc freq, the result looks like following,

Frequency Percent Row Pct Col Pct

Table 2 of granted by publn_first_grant Controlling for ipr_type=PI granted publn_first_grant 0 1 Total 0 2.549E7 43.61 100.00 64.75 0 0.00 0.00 0.00 2.549E7 43.61 1 1.388E7 23.74 42.10 35.25 1.908E7 32.65 57.90 100.00 3.296E7 56.39 Total 3.936E7 67.35 1.908E7 32.65 5.845E7 100.00

It is created by following codes,

proc freq data=Step2.appln_new;

  table ipr_type*granted*publn_first_grant;

run;

how can I show the full length of 1.908E7? Could you please give me some suggestion about this?

thanks in advance.

[Jagadishkatam]

Please try the proc freq template to control the formats.

ODS PATH RESET;                              
ODS PATH (PREPEND) WORK.Templat(UPDATE) ;    
                                             
PROC TEMPLATE;                               
  EDIT Base.Freq.OneWayList;                 
    EDIT Frequency;                          
      FORMAT = best.;                      
    END;                                     
    EDIT CumFrequency;                       
      FORMAT = best.;                      
    END;                                     
    EDIT Percent;                            
      FORMAT = best.;                          
    END;                                     
    EDIT CumPercent;                         
      FORMAT = best.;                          
    END;                                     
  END;                                       
RUN;

proc freq data=Step2.appln_new;
  table ipr_type*granted*publn_first_grant;
run;

[FreelanceReinh · Accepted solution]

Other options (within PROC FREQ) include:

• the LIST option of the TABLES statement:
  

  table ipr_type*granted*publn_first_grant / list;

• creating an output dataset, e.g. with the OUT= option of the TABLES statement (which can then be printed).

[ballardw]

Another approach would be to use the NOPRINT option in proc freq and send the result to a data set. Then you have all the power of proc print for displaying values.