topic Re: How to show the full length of a numeric value created by proc freq in SAS Programming

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

France — Sun, 28 Oct 2018 08:37:05 GMT

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

Total

2.549E7

43.61

100.00

64.75

0.00

2.549E7

43.61

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.

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

Jagadishkatam — Sun, 28 Oct 2018 09:12:34 GMT

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;

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

FreelanceReinh — Sun, 28 Oct 2018 09:29:35 GMT

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).

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

ballardw — Mon, 29 Oct 2018 17:59:10 GMT

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.