is it possible to create a dataset with sum in multiple columns?
With datat statement
Var1 var2 ..................... varn
1 10 20
4 10 20
6 10 20
10 10 20
totalvar1=21
totalvar2=40
totalvar2=80
@dali74 wrote:
is it possible to create a dataset with sum in multiple columns?
Yes. Your math appears incorrect or is it bad sample data?
https://github.com/statgeek/SAS-Tutorials/blob/master/proc_means_basic
Do you want the total to manipulate in another procedure for some reason? Or do you want to create a report with a sum total row?
Generally putting a total in the data leads to a number of potential problems if the data is used for input into other procedures.
data have;
input v1-v3;
datalines;
1 10 20
4 10 20
6 10 20
10 10 20
;
proc means data= have;
var v1-v3 ;
output out=want(drop=_: ) sum=;
run;
Note: Edited by @Reeza to remove emojis from code.
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.