BookmarkSubscribeRSS Feed
BrahmanandaRao
Lapis Lazuli | Level 10
data ss;
input  jan  feb mar;
datalines;
  200 500 650
  255 255 550
 400 844 666
 410 500 600
;
run;



data want;
	set ss end=last;
	jan_sum+jan;
	feb_sum+feb;
	mar_sum+mar;
	output;

	if last then   do;
		
			Total='Total';
			jan=jan_sum;
			feb=feb_sum;
			mar=mar_sum;
			
			output; drop jan_sum feb_sum mar_sum ;
		end;
run;

how to insert Total end of the table for all months total using datastep

1 REPLY 1
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 2145 views
  • 1 like
  • 2 in conversation