I am sorry for the errors. The data set has more than one animal and I want to count for each animal, how many observations fulfilling these conditions. Below is the corrected code. Thank you! data have;
input Animal type_of_service $14. type_of_diagnostic $12.;
cards;
1 Natural Negative
1 Insemination Negative
1 Natural Negative
1 Insemination Negative
1 Natural Positive
2 Insemination Negative
2 Natural Negative
2 Natural Negative
2 Insemination Positive
;
run;
Results wanted:
Animal count
1 1
2 2
... View more
Hello group! I have the following dataset with the following variables: Animal date_of_service type_of_service and type_of_diagnostic. I want to do by animal: count since the first type_of_diagnostic="Negative" (here the type of service can be natural or insemination), how many observations fulfilling these conditions: type_of_service="Natural" and type_of_diagnostic="Negative" until the first type_of_diagnostic being "positive". Thank you in advance for any help! Animal date_of_service type_of_service type_of_diagnostic 1 07/06/2021 Natural Negative 1 01/10/2021 Insemination Negative 1 12/01/2022 Natural Negative 1 03/02/2022 Insemination Negative 1 01/03/2022 Natural Positive Results wanted: Animal count 1 1
... View more
Thank you for your response. I have another question, with 5 dates: date1 date2 date3 date4 date5, and 5 corresponding 5 DO: DO1, DO2, DO3, DO4, and DO5, how to do it? Thank you in advance.
... View more
Hi all, I have the following data structure from a big dataset with: DO1= date1- parity_date, DO2= date2- parity_date, data parity; input animal parity_date date1 DO1 date2 DO2; cards; AM11024 16APR2012 15OCT2012 182 28APR2015 1107 AM11024 14MAR2013 15OCT2012 -150 28APR2015 775 AM11024 04FEB2014 15OCT2012 -477 28APR2015 448 AM11024 20JAN2015 15OCT2012 -827 28APR2015 98 run; I would like to get this result: animal parity_date date DO AM11024 16APR2012 15OCT2012 182 AM11024 20JAN2015 28APR2015 98 Grouping date1 and date2 into one variable (date) and DO1 and DO2 into DO with the following condition: with the mínimum value of DO1 and DO2. Any help will be thankful. Best regards.
... View more
Thank you for your response. The data I'am going to transpose is an output from another fortran program. Newg represents 2 variables. The data is: data transpose; input iteration; cards; round1 newr value1 newg value2 newg value3 round2 newr value4 newg value5 newg value6 round3 newr value7 newg value8 newg value9 ; run;
... View more
Dear all, I want to transpose this column structure from round 1 to n: round1 newr value1 newg value2 newg value3 . . n to the following one: Round newer newg newg 1 value1 value2 value3 . . n Thank you for any help!
... View more
