How to calculate standard deviation for all the values in a column?

[d6k5d3]

Hello!

Suppose I have a column called 'Diff' in a dataset:

Diff

23.56

45.77

23.67

67.86

24.97

86.45

I want to calculate the standard deviation (a single value= 26.66928) of Diff (it's not a rolling standard deviation).

My variable for standard deviation is SD_A. What should be the code to get a single value of SD_A which I will need for further calculation?

Much thanks. 

[PGStats]

There are countless ways. Here is one, assuming Diff is a variable in dataset have:

proc summary data=have;
output out=want std(diff)=sd_a;
run;

The std will be in dataset want.

[d6k5d3]

@PGStats, Thank you so much. However, I need to work with 'Have' dataset, and use SD_A. If the SD_A in a different dataset, how can I make use of it in 'Have'?

I appreciate your time. Much thanks.

[PGStats · Accepted solution]

Then you could start with:

proc sql;
create table want as
select *, std(diff) as sd_a
from have;
quit;

And you could use the same step to do some more calculations with diff and sd_a.