CODEWITHSUNDEEP
sqlsas
Rohit
Rohit

Reputation: 139

How to obtain summary summation when GROUP BY is not working?

I have data with the columns

Every user_id has more than 5 files to it's name, of different filesize values.

Problem statement: I want to have a summary of this table, with columns, User_id, Filesize, where it shows the total size occupied by each user id.

It tried Group By user id, in Proc SQL,

proc sql;
CREATE TABLE want as 
SELECT user_id, filesize 
FROM have
GROUP BY user_id;
QUIT;

but it throws a warning that says

A GROUP BY clause has transformed into an ORDER BY clause because neither the SELECT clause nor the optional HAVING clause of the associated table-expression referenced a summary function.

Are there other ways to do this in SAS?

Upvotes: 1

Views: 1929

Answers (1)

CleanBold
CleanBold

Reputation: 1592

proc sql;
CREATE TABLE want as 
SELECT user_id, SUM(filesize) as TotalFileSize 
FROM have
GROUP BY user_id;
QUIT;

Upvotes: 1

Related Questions