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.
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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.