topic Re: Limit Decimal place in Proc Corr output table in SAS Procedures

Limit Decimal place in Proc Corr output table

shyam — Thu, 15 May 2014 13:51:28 GMT

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

Re: Limit Decimal place in Proc Corr output table

ballardw — Thu, 15 May 2014 14:12:48 GMT

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.

Re: Limit Decimal place in Proc Corr output table

stat_sas — Thu, 15 May 2014 14:19:00 GMT

You can do it using data step

data corrtable;

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

format _numeric_ 4.3;

run;

Re: Limit Decimal place in Proc Corr output table

shyam — Thu, 15 May 2014 14:19:34 GMT

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