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 319In 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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!
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.