BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I have a SAS data set where I have a column of $ values, is there any way
that SAS can add up all the $ values in a column?

I know SAS can add a values in the same row of 2 different columns. But not
sure how I go about adding values in the same column.

Any help is much appreciated.

cheers,
3 REPLIES 3
Cynthia_sas
SAS Super FREQ
Hi:
SAS has many report procedures that will work for you. PROC PRINT, with the SUM statement, PROC SQL, PROC MEANS, PROC TABULATE, PROC REPORT. The code below shows MEANS, TABULATE and REPORT methods for producing a summary report from a SAS dataset. If you needed to create an output dataset of summary numbers, then all 3 procedures could do that as well.

It sort of boils down to whether you want an output dataset or an output report. The program below creates 1 HTML file with 3 summary reports based on the PRODUCT and SALES variables in SASHELP.SHOES.

cynthia
[pre]
ods html file='c:\temp\sumval.html' style=sasweb;

proc means data=sashelp.shoes sum;
title 'Proc Means';
class product;
var sales;
run;

proc tabulate data=sashelp.shoes f=dollar16.;
title 'Proc TABULATE';
class product;
var sales;
table product all,
n*f=comma6. sum*(sales);
keylabel n='Count'
sum=' ';
run;

proc report data=sashelp.shoes nowd;
title 'Proc REPORT';
column product n sales;
define product / group;
define n / 'Count' f=comma6.;
define sales / sum f=dollar16.;
rbreak after / summarize;
run;

ods _all_ close;
[/pre]
deleted_user
Not applicable
thanks Cynthia, appreciate your help always.
Ksharp
Super User
Hi.
In SAS,there is SUM statement ( i.e variable+increase ) ,
And sum Function also can do it. Just need to continuely cumulate this variable.



Ksharp

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 4517 views
  • 0 likes
  • 3 in conversation