topic Re: Counting total in horizontal row in New SAS User

Counting total in horizontal row

Mil00 — Thu, 12 Mar 2020 20:19:33 GMT

I am trying to calculate total percent of each student horizontally (green arrow) using proc freq procedure, but the result I am getting is calculated vertically (orange arrow). Any help will be appreciated.

Re: Counting total in horizontal row

PeterClemmensen — Thu, 12 Mar 2020 20:22:31 GMT

Is it a requirement to use PROC FREQ?

Re: Counting total in horizontal row

PaigeMiller — Thu, 12 Mar 2020 20:33:19 GMT

PROC FREQ, by itself will not produce the count you want. You can do this in either a DATA step, or PROC TRANSPOSE followed by PROC FREQ, or possibly other methods.

Re: Counting total in horizontal row

Mil00 — Thu, 12 Mar 2020 20:36:29 GMT

No, it's not. I just need to count them horizontally

Re: Counting total in horizontal row

PaigeMiller — Thu, 12 Mar 2020 20:39:14 GMT

data want;
    set have;
    count = sum(of weekno1-weekno12);
run;

Re: Counting total in horizontal row

ballardw — Thu, 12 Mar 2020 22:56:25 GMT

@Mil00 wrote:

I am trying to calculate total percent of each student horizontally (green arrow) using proc freq procedure, but the result I am getting is calculated vertically (orange arrow). Any help will be appreciated.

If you need the Percent of values that are 1 on each row then the MEAN function is what you want:

You don't show valid SAS variable names for the week variables but

data want;
   set have;
   percent = mean(of week:);
run;

or explicitly list the variables of interest.

The mean will be between 0 and 1, so 0.5 = 50%. If you want to display percentage values then use a format like Percent8.2 , or do the multiply by 100 to shift the decimal.

Counting would be something different

n (of week: ) would give the number of variables that have a value. But you did not describe what you might actually be counting.