proc means data = c1.od noprint nonobs;
var Total_Media_Value ;
class _probability___/ descending;
output out=data (drop = _TYPE_ _FREQ_)
sum = Total_Budget
n= num_of_optys;
run;
in the output i am getting a row which gives me total of columns. I want to give that row a name - Total , how do i do that?
eg- my result looks like this -
probability total budget num
1 . 3200531 361
2 100 68100 7
3 90 56000 4
4 70 23200 8
5 50 156500 18
6 30 112000 5
7 10 2784731 319
In SAS, rows don't have names. What you will need to do is add a column to the output data set that you named DATA. For example:
data want;
set data;
if _n_=1 then row_name = 'Total';
else row_name = put(_probability___, 5.);
run;
Then when you print the data set, you can print ROW_NAME instead of _PROBABILITY___.
I guessed you only need the total sum.Add NWAY option.
proc means data = c1.od noprint nonobs nway;
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.