topic Help summing variables on the basis of their names in SAS Enterprise Guide

Help summing variables on the basis of their names

Boka98 — Thu, 13 Aug 2015 08:20:24 GMT

Dear community

I've created a lot of numeric variables with the following naming convention: TIME[WEEK][WEEKDAY][HOUR][STATUS]

[week] has 2 digits, [weekday] 1 digit, [hour] 2 digits, [status] 1 digit (1/2 dummy).

Ex: August 13 10 AM would be named: TIME334102 ( I use European calendar and week calculations).

In the variables I've stored minute values ranging from 0 to 60.

I would for instance like to sum all TIME variables with [weekday]=4.

Can this be done?

I know the array num_vars

_NUMERIC_; function and the OF operator, but I'm missing some pieces in the puzzle.

Any help is appreciated.

Thank you.

Re: Help summing variables on the basis of their names

ballardw — Thu, 13 Aug 2015 16:14:54 GMT

Some example of what your data actually looks like would be helpful.

Depending on what your project started with you might have been better off with single variable for date/time and another for what ever you want to sum. If all of your summary activities are going to work around ideas like week of year, day of week then a date variable might suffice.

If you have a date variable then you can inspect that easily with functions such as Year, Month, Day and such and often summarize with other procedures by assigning a format to the date variable to create groups.

Re: Help summing variables on the basis of their names

Boka98 — Mon, 17 Aug 2015 06:40:30 GMT

I actually solved my problem right after posting it.

Seems that just to formulate the problem helped me solve it.

Thank you anyway.