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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.