Simple Standard Deviaton

[Stretlow]

Hi there.

I have a simple problem that I just cant seem to find the answer to.

I have a list of observations with two of the variables being AccountNumber and TransactionAmount, there are mutliple transactions for one account.

Im trying to find the standard deviaton per account.

i currently have the following:-

proc means data=OutboundPayments std ;
class AccountNumber ;
var TransactionAmount ;
output sum=TransactionAmount out=Count_Amount ;

run;

while the results window does contain the correct standard deviation the output dataset "Count_Amount" does not and im struggling as to why.

Any help greatly appreciated.

[Reeza]

In your OUTPUT statement you've only specified a SUM. Add STD to the list.

[art297]

You asked to output the sum rather than the standard deviation (std). Also, unless you want the overall std, include the nway option. e.g.:

proc means data=sashelp.class std nway;
class sex ;
var height ;
output std=TransactionAmount out=Count_Amount ;
run;

Art, CEO, AnalystFinder.com

[ballardw · Accepted solution]

You only requested SUM on the output statement.

Try

output sum=TransactionAmountSum std=TransactionAmountSTD out=Count_Amount ;

[Stretlow]

Thank you for everyones replys on this.

So Simple