07-19-2017 10:48 AM
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 ;
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.
07-19-2017 10:57 AM
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
Need further help from the community? Please ask a new question.