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.
You only requested SUM on the output statement.
Try
output sum=TransactionAmountSum std=TransactionAmountSTD out=Count_Amount ;
In your OUTPUT statement you've only specified a SUM. Add STD to the list.
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
You only requested SUM on the output statement.
Try
output sum=TransactionAmountSum std=TransactionAmountSTD out=Count_Amount ;
Thank you for everyones replys on this.
So Simple
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.