create a variable from a date

[Annie_Fréchette]

Hi!

I want to create a variable who goes frome 1 to 12 based on the date of a test (like first test of the year, second test of the year etc) Here is a little example of what I want it to look like:

Annie_Fréchette_0-1594643534926.png

Anyone can teach me?

Thanks a lot!

Annie

[Jagadishkatam · Accepted solution]

please try

data have;
input cow$ irtest:ddmmyy10. scc;
cards;
daisy 10/7/2017 200
maggy 10/7/2017 120
lily 10/7/2017 98
daisy 11/8/2017 89
maggy 11/8/2017 120
lily 11/8/2017 98
;

proc sort data=have;
format irtest date9.;
by cow irtest;
run;

data want;
set have;
by cow irtest;
retain no_test;
if first.cow then no_test=1;
else no_test+1;
run;

[Annie_Fréchette]

Thank you very much!

[andreas_lds]

Can be solved by sorting data by Cow and JR_Test and a datastep with first and retain to create no_test.

data want;
  set have_sorted;
  by Cow;

  length no_test 8;
  retain no_test;

  if first.Cow then no_test = 0;
  no_test = no_test + 1;
run;

The code is untested, because you haven't provided data in usable form.