Limit Decimal place in Proc Corr output table

[shyam]

Hi,

I computed spearman correlation and output in the table by using following procedure.

Proc Corr Spearman data=mydata outp=corrtable;

var v1-v5;

run;

I want to limit the decimal place (two or three digits after the decimal) in  correlation matrix in output table "corrtable" . Could you sugget me the way to accomplish it.

Thanks,

Shyam

[ballardw]

I wouldn't actually change the value. Use an appropriate format when displaying the values such as:

proc print data=corrtable;

     var v1-v5;

     format v1-v5 f5.3;

run;

to show 3 decimals.

You can make this a default for the output set using Proc datasets to change the default format to the one you want.

[shyam]

Thanks Ballardw, However, I would like to change the decimal place in a output table when it output from Proc Corr procedure.

[stat_sas]

You can do it using data step

data corrtable;

  set corrtable(where=(_type_='CORR'));

  format _numeric_ 4.3;

run;