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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: