topic Re: equivalent of a pivot table in sas in New SAS User

equivalent of a pivot table in sas

sasprogramming — Fri, 13 Dec 2019 00:01:16 GMT

I have the current set of data that looks like this:

I want to summarise it by 'Score' like so:

Row LabelsCount of IDAverage of PB

How do I go about doing this in SAS? Thanks.

PaigeMiller — Fri, 13 Dec 2019 00:11:14 GMT

proc summary data=have nway;
    class score;
    var pb;
    output out=stats mean=;
run;

sasprogramming — Fri, 13 Dec 2019 00:18:23 GMT

This works well thanks, but is there anyway to add a column that is the count, i.e. the frequency of ID?

Thanks.

Tom — Fri, 13 Dec 2019 00:34:28 GMT

@sasprogramming wrote:

This works well thanks, but is there anyway to add a column that is the count, i.e. the frequency of ID?

Thanks.

What is wrong with the count it already produces?

novinosrin — Fri, 13 Dec 2019 00:35:13 GMT

The solution provided by @PaigeMiller should have a variable called _freq_ in the output dataset. I think that's what you are looking for .

You could rename that as count

output out=stats (drop=_type_ rename=(_freq_=count)) mean= ;

@sasprogramming wrote:

This works well thanks, but is there anyway to add a column that is the count, i.e. the frequency of ID?

Thanks.

sasprogramming — Fri, 13 Dec 2019 00:38:27 GMT

Oh I understand now, thank you