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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.