topic Re: frequencies and average in Statistical Procedures

frequencies and average

Barkamih — Tue, 16 Oct 2018 18:29:30 GMT

Hi all

I have data called fat, and it has variable PR and TEST DATE as well as COW ID.

Each cow has four test dates or more, and PR variable has four different levels.

My question is I want to know the average number of test dates per cow for each PR level.

someone told me it could be by using proc freq for cow id * pr, but I couldn't figure out that code

I hope you got my query

Regards

Ibrahim

Re: frequencies and average

PGStats — Tue, 16 Oct 2018 19:15:33 GMT

Please show an example of your data and the SAS code you have tried.

Re: frequencies and average

ballardw — Tue, 16 Oct 2018 19:38:40 GMT

@Barkamih wrote:

Hi all

I have data called fat, and it has variable PR and TEST DATE as well as COW ID.

Each cow has four test dates or more, and PR variable has four different levels.

My question is I want to know the average number of test dates per cow for each PR level.

someone told me it could be by using proc freq for cow id * pr, but I couldn't figure out that code

I hope you got my query

Regards

Ibrahim

"COW ID" is not normally acceptable as a SAS variable name, spaces are not allowed.

So first check on the names of your variables.

You should show the code you attempted and any notes or messages from the LOG when things aren't working correctly.

Copy the text from the log, open a code box one the forum using the {I} icon and paste the code and any messages.

Re: frequencies and average

Barkamih — Wed, 17 Oct 2018 11:58:25 GMT

COW_ID	         CAL_TE	      CEA       PR       TEST_DATE
71988495	06/09/2011	1	4	10/01/2012
71988495	06/09/2011	1	4	02/02/2012
71988495	06/09/2011	1	4	06/03/2012
71988495	06/09/2011	1	4	05/04/2012
71988495	06/09/2011	1	3	05/05/2012
75170579	07/10/2013	1	3	15/01/2014
75170579	07/10/2013	1	2	12/12/2013
75170579	07/10/2013	1	1	15/11/2013
75170579	07/10/2013	1	3	10/06/2014
76506914	19/03/2012	3	4	08/08/2012
76506914	19/03/2012	3	1	28/06/2012
76506914	19/03/2012	3	1	19/04/2012
76506914	19/03/2012	3	4	29/05/2012
77966344	17/01/2012	2	3	14/03/2012
77966344	17/01/2012	2	2	03/05/2012
77966344	17/01/2012	2	1	05/04/2012
77966344	17/01/2012	2	3	01/06/2012
77966344	17/01/2012	2	2	01/09/2012
77966344	17/01/2012	2	4	07/07/2012
77966344	17/01/2012	2	1	01/08/2012
77966344	17/01/2012	2	3	04/10/2012
77966344	17/01/2012	2	1	03/11/2012
82867861	02/05/2011	3	1	03/02/2012
82985152	01/09/2011	2	2	02/07/2012
82985152	01/09/2011	2	2	01/06/2012
82985152	01/09/2011	2	2	02/04/2012
82985152	01/09/2011	2	2	02/05/2012
82985152	01/09/2011	2	2	02/01/2012
82985152	01/09/2011	2	3	01/02/2012
82985152	01/09/2011	2	3	01/03/2012
108172029	29/05/2011	1	3	02/02/2012
108172029	29/05/2011	1	3	09/03/2012
108279276	27/05/2011	1	1	08/03/2012
108279276	27/05/2011	1	2	06/01/2012
108279276	27/05/2011	1	3	03/02/2012
110186178	18/08/2011	1	3	11/01/2012
110186178	18/08/2011	1	3	09/02/2012
110186178	18/08/2011	1	4	13/03/2012
110186178	18/08/2011	1	4	11/06/2012
110186178	18/08/2011	1	4	16/04/2012
110186178	18/08/2011	1	1	14/05/2012
110206340	13/11/2011	1	1	29/08/2012

this is my data, I didn't use any coed, but I just tried to use the normal proc freq as pr * cow_id, but it doesn't work.

regards

Re: frequencies and average

Barkamih — Wed, 17 Oct 2018 13:02:36 GMT

thanks for your replay, I knew the space issue, what I'm looking is how to create the proper code for this question, I didn't use any code yet except the proc freq code as cow_id * pr, but it doesn't work, actually, it worked but I didn't get my needs.

thanks again

regards

Re: frequencies and average

Barkamih — Wed, 17 Oct 2018 13:05:34 GMT

this code just showing the frequency of cow_id, but I'm looking for the average number of cow_id of all data.

Re: frequencies and average

ballardw — Wed, 17 Oct 2018 19:43:24 GMT

Example input data and example output for the given input really helps.

Here is an example of determining the average number of models of cars per make (or brand). You should have this data set to examine.

proc freq data=sashelp.cars noprint;
   tables make*type /out=makecount;
run;

proc means data=makecount mean;
  var count;
run;

The first step counts how many times combinations of MAKE and TYPE appear in the data. In this case there is one record per MODEL.

Then average the resulting count. Which yields the average number of records for MAKE and type combinations.

I think that COWID would take the place of MAKE and TYPE would be your PR. Which would give the average number of records per cow and pr.

If you need something else, provide some small actual example data for input and the output you want for that input.

Re: frequencies and average

Barkamih — Thu, 18 Oct 2018 11:00:42 GMT

thank you soooooooo much my brother.

I got the answer from this code. this requirement will be the last thing I was looking for to finish my first paper for publication.

thanks again

I might need your help for the second paper, be always online hahahahah.

best regards

Brakamih