Skip to content
Advertisement

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

I have data with the columns

  • User_id (char)

  • filename (char)

  • filesize (numeric)

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,

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?

Advertisement

Answer

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement