topic Re: count variable in SAS Programming

count variable

Barkamih — Thu, 26 Oct 2017 21:05:31 GMT

Hello

I'm looking for code that can count how many herds in my dataset MFD.

Each herd repeated in the original dataset many times. And this table is the output of proc freq of Herd.

this table is very long because of a large number of farms.

HOW CAN I KNOW THE NUMBER OF FREQUENCES?

Herd

A40

A56

A005

A025

A041

A115

A131

A143

A223

A376

REGARDS

Kurt_Bremser — Thu, 26 Oct 2017 21:41:19 GMT

From the original table, do a count(distinct herd) in sql.

Reeza — Thu, 26 Oct 2017 23:57:34 GMT

GUI solution in SAS studio - but it also generates the code:

and the examples/reference in the documentation for PROC FREQ