Using this code:
DATA WORK.TestDataSet; INPUT Uid Col1 Col2 Target $; DATALINES; 1 5.1 3.5 13.12345 2 4.9 3.15 2.1345 ; DATA WORK.TestDataSet; SET WORK.TestDataSet; MSE = (Target - ((Col1 + Col2) + exp(2.345)))**2; RUN; proc summary data = WORK.TestDataSet; var MSE; output out = WORK.ProcSumOut sum=; run; proc print data = WORK.ProcSumOut; run;
I would like to divide the 'computed column' by noobs (the number of rows in WORK.TestDataSet). Is this possible? The result should be in WORK.ProcSumOut.
Unless you have missing values the average is the sum divided by the number of observations so you can calculate your statistics by specifying the mean option
Sorry but your suggestion does not produce the desired output of 151.104. However, the following code, which makes use of _FREQ_. does the job:
DATA WORK.TestDataSet; INPUT Uid Col1 Col2 Target $; DATALINES; 1 5.1 3.5 13.12345 2 4.9 3.15 2.1345 ; DATA WORK.TestDataSet; SET WORK.TestDataSet; MSE = (Target - ((Col1 + Col2) + exp(2.345)))**2; RUN; proc summary data = WORK.TestDataSet ; var MSE; output out = WORK.ProcSumOut sum=; run; proc print data = WORK.ProcSumOut; run; data WORK.ProcSumOut2; set WORK.ProcSumOut ; MSE=MSE/_FREQ_; run; proc print data = WORK.ProcSumOut2; run;
proc means data = WORK.TestDataSet ;
var MSE;
output out = WORK.ProcSumOut sum= Mean= / autoname;
run;
Unless you have missing values the average is the sum divided by the number of observations so you can calculate your statistics by specifying the mean option
If for some reason you want what you are asking for, it's already there. The output data set automatically contains _FREQ_. It is the total number of observations (including those that have missing values, so using it in calculations may not give you the mean exactly).
You are specifying that the output data set should contain the SUM. You can also ask for other statistics, such as MEAN (as Reeza mentioned), N (number of observations with a non-missing value), and NMISS (number of observations with a missing value).
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.